According to the official site (SQLite.org), SQLite is a "small, fast, self-contained, high-reliability, full-featured, SQL database engine".
Let's see what that means to us, as Flutter mobile developers: first of all, SQLite is an SQL database engine. That means that you can use the SQL language to build queries, so if you are already familiar with SQL, you can leverage your knowledge. If you are totally new to databases, I suggest you have a look at the excellent W3Schools SQL tutorial at https://www.w3schools.com/sql/default.asp: you'll find it much easier to follow along with the project in this chapter.
The main features of SQLite are as follows:
- Small and fast: Developers have extensively tested SQLite speed and file size, and it outperformed several other technologies, both as space on disk and for its speed of retrieval...