A database in one file
What SQLite is
Understand how an embedded database differs from a database server and why one ordinary file can hold a complete relational database.
8 minute lesson
~~~
SQLite is a relational database engine embedded inside the program that uses it. There is no separate server process to install, configure, or keep running.
A database normally lives in one file. Your application opens that file and SQLite reads and writes it directly while still giving you tables, SQL, indexes, constraints, and transactions.
That small operational footprint is the main reason SQLite appears in local tools, desktop and mobile apps, tests, caches, and many web applications.
Lesson completed