WEBVTT

1
00:00:01.370 --> 00:00:03.350
in this video we're going to install the

2
00:00:03.350 --> 00:00:05.750
sqlite command line shell for the Linux
in this video we're going to install the

3
00:00:05.750 --> 00:00:08.330
computers now if you're using Windows or
sqlite command line shell for the Linux

4
00:00:08.330 --> 00:00:10.370
Mac refer to the previous two videos
computers now if you're using Windows or

5
00:00:10.370 --> 00:00:12.290
where we actually set up for those
Mac refer to the previous two videos

6
00:00:12.290 --> 00:00:14.150
platforms but if you're running linux
where we actually set up for those

7
00:00:14.150 --> 00:00:15.589
you're in the right place so let's get
platforms but if you're running linux

8
00:00:15.589 --> 00:00:18.350
started so Python includes sqlite
you're in the right place so let's get

9
00:00:18.350 --> 00:00:20.480
in its standard library so we don't need
started so Python includes sqlite

10
00:00:20.480 --> 00:00:22.190
to install anything to use sqlite
in its standard library so we don't need

11
00:00:22.190 --> 00:00:25.130
in our python programs but writing data
to install anything to use sqlite

12
00:00:25.130 --> 00:00:26.660
base code straightaway isn't the
in our python programs but writing data

13
00:00:26.660 --> 00:00:28.460
easiest way to learn about sqlite
base code straightaway isn't the

14
00:00:28.460 --> 00:00:30.500
and the sql language because if you
easiest way to learn about sqlite

15
00:00:30.500 --> 00:00:31.910
get errors you have to work out if the
and the sql language because if you

16
00:00:31.910 --> 00:00:33.890
errors in your python code or the
get errors you have to work out if the

17
00:00:33.890 --> 00:00:35.719
sql statements that you actually use
errors in your python code or the

18
00:00:35.719 --> 00:00:37.670
so what we're going to do is we're going
sql statements that you actually use

19
00:00:37.670 --> 00:00:39.199
to start by using the sqlite
so what we're going to do is we're going

20
00:00:39.199 --> 00:00:41.449
command line shell so that we can create
to start by using the sqlite

21
00:00:41.449 --> 00:00:44.030
databases in use sql commands
command line shell so that we can create

22
00:00:44.030 --> 00:00:45.890
without having to worry about Python
databases in use sql commands

23
00:00:45.890 --> 00:00:48.559
code at this stage now on ubuntu linux
without having to worry about Python

24
00:00:48.559 --> 00:00:50.899
turns out this is really easy going to
code at this stage now on ubuntu linux

25
00:00:50.899 --> 00:00:52.850
start by opening a terminal session so
turns out this is really easy going to

26
00:00:52.850 --> 00:00:55.789
i'm just going to use the shortcut on ubuntu
start by opening a terminal session so

27
00:00:55.789 --> 00:01:00.109
which is control alt t that opens the
i'm just going to use the shortcut on ubuntu

28
00:01:00.109 --> 00:01:04.220
windows you can see they're obviously
which is control alt t that opens the

29
00:01:04.220 --> 00:01:05.480
I could have just come up here and just type
windows you can see they're obviously

30
00:01:05.480 --> 00:01:07.580
terminal in there to open up that way as
I could have just come up here and just type

31
00:01:07.580 --> 00:01:08.060
well
terminal in there to open up that way as

32
00:01:08.060 --> 00:01:10.040
alright so installing sqlite3
well

33
00:01:10.040 --> 00:01:11.210
firstly we check to see whether we've
alright so installing sqlite3

34
00:01:11.210 --> 00:01:15.320
got it we type...you can see that
firstly we check to see whether we've

35
00:01:15.320 --> 00:01:16.880
it's saying that currently we haven't
got it we type...you can see that

36
00:01:16.880 --> 00:01:19.700
got the program installed so again on
it's saying that currently we haven't

37
00:01:19.700 --> 00:01:23.240
ubuntu linux we do...
got the program installed so again on

38
00:01:23.240 --> 00:01:28.100
...
ubuntu linux we do...

39
00:01:28.100 --> 00:01:31.840
....
...

40
00:01:31.840 --> 00:01:33.579
and you can see that was really really
....

41
00:01:33.579 --> 00:01:34.899
quick installation is only a small
and you can see that was really really

42
00:01:34.899 --> 00:01:36.399
program is already getting the
quick installation is only a small

43
00:01:36.399 --> 00:01:38.020
command-line shell not the sqlite
program is already getting the

44
00:01:38.020 --> 00:01:40.329
itself this point we can then check to
command-line shell not the sqlite

45
00:01:40.329 --> 00:01:42.310
see whether sqlite is installed
itself this point we can then check to

46
00:01:42.310 --> 00:01:47.049
type...you can see instead
see whether sqlite is installed

47
00:01:47.049 --> 00:01:48.610
of getting an error like we did
type...you can see instead

48
00:01:48.610 --> 00:01:50.860
previously we can see its showing
of getting an error like we did

49
00:01:50.860 --> 00:01:53.170
the sqlite version number....
previously we can see its showing

50
00:01:53.170 --> 00:01:55.539
...and incidentally you
the sqlite version number....

51
00:01:55.539 --> 00:01:56.950
might see a slightly different version
...and incidentally you

52
00:01:56.950 --> 00:01:58.990
number what I've got on the screen
might see a slightly different version

53
00:01:58.990 --> 00:02:00.759
but that's ok so long as you can
number what I've got on the screen

54
00:02:00.759 --> 00:02:02.619
actually get it working and you can see
but that's ok so long as you can

55
00:02:02.619 --> 00:02:04.239
that we actually started the sqlite
actually get it working and you can see

56
00:02:04.239 --> 00:02:07.450
command line shell your good to go and just
that we actually started the sqlite

57
00:02:07.450 --> 00:02:09.789
keep in mind specifically with ubuntu
command line shell your good to go and just

58
00:02:09.789 --> 00:02:13.360
i'm using 14.04 but if you're
keep in mind specifically with ubuntu

59
00:02:13.360 --> 00:02:15.819
using Ubuntu 16.04 you will actually get
i'm using 14.04 but if you're

60
00:02:15.819 --> 00:02:18.280
a much later version but both versions
using Ubuntu 16.04 you will actually get

61
00:02:18.280 --> 00:02:20.349
will actually work fine with the course
a much later version but both versions

62
00:02:20.349 --> 00:02:21.700
their is no prerequisites for a specific
will actually work fine with the course

63
00:02:21.700 --> 00:02:23.590
version of sqlite3
their is no prerequisites for a specific

64
00:02:23.590 --> 00:02:25.450
alright so this point we've completed
version of sqlite3

65
00:02:25.450 --> 00:02:28.030
the installation type...to get
alright so this point we've completed

66
00:02:28.030 --> 00:02:30.250
out of the sqlite command line shell
the installation type...to get

67
00:02:30.250 --> 00:02:32.470
....to close down the terminal
out of the sqlite command line shell

68
00:02:32.470 --> 00:02:36.280
session and at this point we're done so
....to close down the terminal

69
00:02:36.280 --> 00:02:37.750
let's now move on to the next video
session and at this point we're done so

70
00:02:37.750 --> 00:02:38.950
we're going to go through a bit of an
let's now move on to the next video

71
00:02:38.950 --> 00:02:41.650
introduction on using sqlite see you
we're going to go through a bit of an

72
00:02:41.650 --> 00:02:47.280
in the next video
introduction on using sqlite see you