SQLite

SQLite is a lightweight, open-source, [[Serverless Architecture|serverless]], self-contained, and embedded [[relational database]] management system (RDBMS). It is designed for simplicity, speed, and ease of use, making it a popular choice for small to medium-sized applications and embedded systems where a full-fledged database server is not necessary.

SQLite is a single, standalone library that can be linked with apps. It does not require a separate database server process or installation. Unlike [[MySQL (KB)]] or [[PostgreSQL]], SQLite operates without a separate client-server architecture.

SQLite is a relational database management system and it supports tables with rows and columns, indexes, and [[Structured Query Language|SQL]] for data manipulation.

SQLite database are stored as flat files on disk, making it portable and easy to manage.