Databases & Data Storage
SQLite
Definition
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. It is the most used database engine in the world, built into all mobile phones and most computers.
Why It Matters
SQLite is an "embedded" database, meaning the database engine is not a separate server process but is linked directly into the application. This makes it incredibly easy to use for applications that need a simple, local data store without the overhead of a full client-server database.
Contextual Example
Many mobile applications, including Android and iOS apps, use SQLite internally to store application data like user settings, message history, or cached content directly on the device.
Common Misunderstandings
- SQLite is serverless. The entire database is stored in a single `.sqlite` file.
- It is not designed for high-concurrency or multi-user web applications, which are better served by client-server databases like PostgreSQL or MySQL.