And that's it for this course section.
We built this little demo blog here,
which uses all four crowd operations
for creating posts,
reading posts,
so showing us posts
either all the posts or a single post,
and of course also supports updating posts
through this edit page or deleting posts
through the delete button.
This all works,
and it works with help of SQL.
With help of the MySQL package, which we are using.
And with help of that pool,
this connection pool we created,
which we can use for sending queries to our database.
Our local SQL database server,
which is running on our local machine
to which we send queries like this one,
where we select data and join data
with data from another table
or creation queries like this one.
So all the kind of commands you learned about
in the previous core sections
are now not executed by us in MySQL workbench,
but instead here in the NodeJS code.
And that's of course the realistic use case.
That's why you use the database.
You use it as a data storage
in your website application
so that the data is not stored in a standard file,
which can be inefficient and so on as you learned,
but that it is stored in a database instead.
Now of course, feel free to play around with that.
Change those queries.
Add more functionalities,
maybe try to add sorting.
Play around with that.
In the next core sections,
we are instead going to dive
into the Node SQL world
and you will see
how you could use a Node SQL database instead,
or in addition to a SQL database
and how querying such a database would work.
Because it is quite different
but also easy to learn and a lot of fun.
And therefore that's it for a SQL
and MySQL for the moment.
I hope you got a lot out of that.
Feel free to play around with that
and let's move on to Node SQL next.