WEBVTT

1
00:00:00.980 --> 00:00:03.050
so in this video we're going to see how to

2
00:00:03.050 --> 00:00:05.509
run the sqlite command-line shell on
so in this video we're going to see how to

3
00:00:05.509 --> 00:00:08.210
a mac if you're using Windows refer to
run the sqlite command-line shell on

4
00:00:08.210 --> 00:00:10.639
the previous video if you're using linux
a mac if you're using Windows refer to

5
00:00:10.639 --> 00:00:12.619
and actually refer to the video after
the previous video if you're using linux

6
00:00:12.619 --> 00:00:14.510
this one where we actually set up for
and actually refer to the video after

7
00:00:14.510 --> 00:00:16.430
those relevant operating systems but if
this one where we actually set up for

8
00:00:16.430 --> 00:00:17.420
you're on a Mac you're in the right
those relevant operating systems but if

9
00:00:17.420 --> 00:00:18.289
place
you're on a Mac you're in the right

10
00:00:18.289 --> 00:00:21.019
let's get started now as it turns out
place

11
00:00:21.019 --> 00:00:23.449
python includes sqlite in its
let's get started now as it turns out

12
00:00:23.449 --> 00:00:25.099
standard library so we don't actually
python includes sqlite in its

13
00:00:25.099 --> 00:00:27.079
need to install anything to install a
standard library so we don't actually

14
00:00:27.079 --> 00:00:28.999
sqlite in our python programs
need to install anything to install a

15
00:00:28.999 --> 00:00:32.090
but writing database code straightaway
sqlite in our python programs

16
00:00:32.090 --> 00:00:33.829
isn't the easiest way to learn about
but writing database code straightaway

17
00:00:33.829 --> 00:00:36.260
sqlite and the sql language if
isn't the easiest way to learn about

18
00:00:36.260 --> 00:00:37.730
you get errors you have to work out then
sqlite and the sql language if

19
00:00:37.730 --> 00:00:39.829
if the errors in your python code or the
you get errors you have to work out then

20
00:00:39.829 --> 00:00:42.199
sql statements that you've used so
if the errors in your python code or the

21
00:00:42.199 --> 00:00:43.430
what we're going to do is we're going to
sql statements that you've used so

22
00:00:43.430 --> 00:00:44.629
start out by using the sqlite
what we're going to do is we're going to

23
00:00:44.629 --> 00:00:46.969
command line shell so that we can create
start out by using the sqlite

24
00:00:46.969 --> 00:00:48.710
databases and use sql commands
command line shell so that we can create

25
00:00:48.710 --> 00:00:50.449
directly without having to worry about
databases and use sql commands

26
00:00:50.449 --> 00:00:52.219
the python side of things that for now
directly without having to worry about

27
00:00:52.219 --> 00:00:55.129
now on a Mac turns out this is really
the python side of things that for now

28
00:00:55.129 --> 00:00:56.989
really easy and that's because the
now on a Mac turns out this is really

29
00:00:56.989 --> 00:00:59.570
sqlite command line shell is already installed
really easy and that's because the

30
00:00:59.570 --> 00:01:01.399
on a mac so there's really nothing else
sqlite command line shell is already installed

31
00:01:01.399 --> 00:01:03.109
we need to do to be able to get to work
on a mac so there's really nothing else

32
00:01:03.109 --> 00:01:05.300
to be able to get that up and running so
we need to do to be able to get to work

33
00:01:05.300 --> 00:01:07.130
just to confirm that it is working
to be able to get that up and running so

34
00:01:07.130 --> 00:01:09.320
open a terminal session you can do that
just to confirm that it is working

35
00:01:09.320 --> 00:01:13.190
by holding a command pressing space that
open a terminal session you can do that

36
00:01:13.190 --> 00:01:14.690
will open that screen up there and we can
by holding a command pressing space that

37
00:01:14.690 --> 00:01:18.590
just type in terminal press enter that
will open that screen up there and we can

38
00:01:18.590 --> 00:01:20.600
loads the terminal screen and to test
just type in terminal press enter that

39
00:01:20.600 --> 00:01:22.670
that we've got a sqlite
loads the terminal screen and to test

40
00:01:22.670 --> 00:01:24.620
sqlite is installed we type...
that we've got a sqlite

41
00:01:24.620 --> 00:01:28.490
....and you
sqlite is installed we type...

42
00:01:28.490 --> 00:01:29.630
can see that we've got some
....and you

43
00:01:29.630 --> 00:01:31.490
text showing on the screen you can
can see that we've got some

44
00:01:31.490 --> 00:01:33.020
see that sqlite3 is actually
text showing on the screen you can

45
00:01:33.020 --> 00:01:35.450
successfully installed now don't worry
see that sqlite3 is actually

46
00:01:35.450 --> 00:01:37.070
if you see slightly different version
successfully installed now don't worry

47
00:01:37.070 --> 00:01:39.290
numbers there this program is updated
if you see slightly different version

48
00:01:39.290 --> 00:01:41.510
from time to time but to so long as you
numbers there this program is updated

49
00:01:41.510 --> 00:01:43.370
you actually can see that it has started
from time to time but to so long as you

50
00:01:43.370 --> 00:01:44.900
the program and it looks like it's
you actually can see that it has started

51
00:01:44.900 --> 00:01:46.670
working then we're good to go
the program and it looks like it's

52
00:01:46.670 --> 00:01:48.260
so at this point we can quit out of this
working then we're good to go

53
00:01:48.260 --> 00:01:52.100
by typing....going to type exit
so at this point we can quit out of this

54
00:01:52.100 --> 00:01:53.540
to close down the command shell and I
by typing....going to type exit

55
00:01:53.540 --> 00:01:54.710
going to close down the terminal
to close down the command shell and I

56
00:01:54.710 --> 00:01:58.280
window and this point we're good to go
going to close down the terminal

57
00:01:58.280 --> 00:02:00.650
so skip the next video unless for some
window and this point we're good to go

58
00:02:00.650 --> 00:02:02.600
reason you also want to install sqlite3
so skip the next video unless for some

59
00:02:02.600 --> 00:02:04.880
on a linux machine and the
reason you also want to install sqlite3

60
00:02:04.880 --> 00:02:06.680
video after that then actually go ahead
on a linux machine and the

61
00:02:06.680 --> 00:02:09.409
and start using sqlite so i'll see
video after that then actually go ahead

62
00:02:09.409 --> 00:02:15.429
you in the next video
and start using sqlite so i'll see