1
00:00:02,240 --> 00:00:05,380
And that's it for this course section.

2
00:00:05,380 --> 00:00:07,952
We built this little demo blog here,

3
00:00:07,952 --> 00:00:11,400
which uses all four crowd operations

4
00:00:11,400 --> 00:00:13,480
for creating posts,

5
00:00:13,480 --> 00:00:15,670
reading posts,

6
00:00:15,670 --> 00:00:17,200
so showing us posts

7
00:00:17,200 --> 00:00:20,270
either all the posts or a single post,

8
00:00:20,270 --> 00:00:23,560
and of course also supports updating posts

9
00:00:23,560 --> 00:00:26,580
through this edit page or deleting posts

10
00:00:26,580 --> 00:00:28,660
through the delete button.

11
00:00:28,660 --> 00:00:29,660
This all works,

12
00:00:29,660 --> 00:00:32,540
and it works with help of SQL.

13
00:00:32,540 --> 00:00:36,040
With help of the MySQL package, which we are using.

14
00:00:36,040 --> 00:00:37,870
And with help of that pool,

15
00:00:37,870 --> 00:00:39,870
this connection pool we created,

16
00:00:39,870 --> 00:00:43,630
which we can use for sending queries to our database.

17
00:00:43,630 --> 00:00:46,000
Our local SQL database server,

18
00:00:46,000 --> 00:00:48,080
which is running on our local machine

19
00:00:48,080 --> 00:00:50,560
to which we send queries like this one,

20
00:00:50,560 --> 00:00:53,090
where we select data and join data

21
00:00:53,090 --> 00:00:55,250
with data from another table

22
00:00:55,250 --> 00:00:58,300
or creation queries like this one.

23
00:00:58,300 --> 00:01:01,030
So all the kind of commands you learned about

24
00:01:01,030 --> 00:01:02,657
in the previous core sections

25
00:01:02,657 --> 00:01:07,240
are now not executed by us in MySQL workbench,

26
00:01:07,240 --> 00:01:10,460
but instead here in the NodeJS code.

27
00:01:10,460 --> 00:01:13,600
And that's of course the realistic use case.

28
00:01:13,600 --> 00:01:15,990
That's why you use the database.

29
00:01:15,990 --> 00:01:18,460
You use it as a data storage

30
00:01:18,460 --> 00:01:21,030
in your website application

31
00:01:21,030 --> 00:01:24,520
so that the data is not stored in a standard file,

32
00:01:24,520 --> 00:01:27,640
which can be inefficient and so on as you learned,

33
00:01:27,640 --> 00:01:30,243
but that it is stored in a database instead.

34
00:01:31,350 --> 00:01:34,920
Now of course, feel free to play around with that.

35
00:01:34,920 --> 00:01:36,440
Change those queries.

36
00:01:36,440 --> 00:01:38,320
Add more functionalities,

37
00:01:38,320 --> 00:01:40,670
maybe try to add sorting.

38
00:01:40,670 --> 00:01:42,730
Play around with that.

39
00:01:42,730 --> 00:01:44,930
In the next core sections,

40
00:01:44,930 --> 00:01:46,620
we are instead going to dive

41
00:01:46,620 --> 00:01:48,610
into the Node SQL world

42
00:01:48,610 --> 00:01:49,450
and you will see

43
00:01:49,450 --> 00:01:52,660
how you could use a Node SQL database instead,

44
00:01:52,660 --> 00:01:55,400
or in addition to a SQL database

45
00:01:55,400 --> 00:01:59,059
and how querying such a database would work.

46
00:01:59,059 --> 00:02:01,110
Because it is quite different

47
00:02:01,110 --> 00:02:04,760
but also easy to learn and a lot of fun.

48
00:02:04,760 --> 00:02:06,870
And therefore that's it for a SQL

49
00:02:06,870 --> 00:02:08,750
and MySQL for the moment.

50
00:02:08,750 --> 00:02:10,530
I hope you got a lot out of that.

51
00:02:10,530 --> 00:02:12,630
Feel free to play around with that

52
00:02:12,630 --> 00:02:15,003
and let's move on to Node SQL next.