embedded database
A database that runs as a library inside the application's own process instead of as a separate server.
In more detail
SQLite is the best known example: opening a database means opening a file, with no network hop, login or connection pool. The trade-off is that only programs on the same machine can share the file, and writes are serialised.
Related terms
- SQLite — A small relational database that runs as a library inside your program and keeps the whole database in one file.
- database server — A database that runs as its own long-lived program and serves many client programs over network connections.
Taught in
- Where PostgreSQL Differs From SQLite — PostgreSQL, Indexing & Relational Data Modeling