SQL is a very powerful language, and SQLite brings us all this power in a lightweight, easy-to-install, and open source software.

Initially, we went through the reasons why we chose SQLite as our database solution and why it's a good choice for our particular use case. In the process, we also went over some of the strengths and weaknesses of SQLite.

You then learned how to set up a running SQLite instance on our Pi. After that, we understood the data types used by SQLite and decided the schema for our data tables. We used this to initialize some tables to hold the data of our application.

After this, we discovered some basic CRUD operations to read and write selectively to our database using the SQL language. Finally, we took our queries to the next level by learning some advanced queries that used aggregations and subqueries.

This chapter was important as a base for the next chapter, which is where we will learn to integrate the knowledge we obtained on database management that you learned in this chapter with our existing server application.