SQLite
MentionedDatabase
Lightweight relational database in a single file. No separate server needed.
SQLite, explained
Written by EduVerseWhat it is
SQLite is a relational database that lives in a single file. There’s no separate server to install or start: it’s a small library inside your application that reads and writes that file directly, using ordinary SQL. It’s built into both Android and iOS and into many desktop programs.
Why teams use it
For prototypes, tests, mobile apps and small sites, a database server is often overhead you don’t need. SQLite needs no setup, no password and no network, and copying the file copies the whole database. It allows only one writer at a time, so busy multi-user apps usually move to PostgreSQL or MySQL.
An example from work
You create a new Django or Laravel project and find a file called db.sqlite3 or database.sqlite in the project folder. Your app already has a working database without installing anything. You can open that file with the sqlite3 command or DB Browser for SQLite to see the tables your migrations created.
Our own explanation, not a quote from the book.
Where it fits
Mobile apps, embedded systems, local storage, prototyping
Coverage in the book
Mentioned as part of the wider landscape, without in-depth coverage.
