SQLite

SQLite is a library, not a server — the whole database is a single file opened inside your process. That constraint shapes everything below it: dynamic typing, the file format, the write concurrency model, and why it is the default database on every phone.