SQLite
SQLite is a lightweight, serverless, self-contained relational database engine that reads and writes directly to a single ordinary disk file, making it one of the most widely deployed database engines in the world.
Definition
SQLite is a lightweight, serverless, self-contained relational database engine that reads and writes directly to a single ordinary disk file, making it one of the most widely deployed database engines in the world.
Overview
SQLite was created by D. Richard Hipp and first released in 2000, designed to be embedded directly inside applications rather than run as a separate server process — there's no separate database server to install, configure, or administer. The entire database — tables, indexes, triggers, and views — lives in a single cross-platform file, and the SQLite library is linked directly into the host application, which talks to it through function calls rather than network sockets. It implements most of standard SQL along with ACID transactions, using a flexible "dynamic typing" model, and its Write-Ahead Logging (WAL) mode improves concurrent read and write behavior despite having no server process. It's even bundled directly into Python's standard library, making it a common first database for Python developers. SQLite is embedded inside virtually every smartphone as the default local storage engine for iOS and Android apps, most web browsers, and countless desktop applications. It's also popular for small-to-medium web apps, local caches, and testing environments where a full client-server database like PostgreSQL or MySQL would be overkill.
Key Features
- Serverless — the entire database is a single file with no separate server process
- Zero-configuration setup; nothing to install or administer
- Full ACID-compliant transactions and most of the standard SQL language
- Cross-platform file format usable identically across operating systems
- Extremely small footprint, ideal for embedded and mobile environments
- Write-Ahead Logging (WAL) mode for improved concurrent read/write performance
Use Cases
History
SQLite is a self-contained, serverless, zero-configuration SQL database engine embedded directly inside applications rather than run as a separate server — and one of the most widely deployed software components in the world, found in browsers, phones, and countless apps. It was created by D. Richard Hipp in the spring of 2000 while he was working for General Dynamics on a U.S. Navy contract, with the goal of a database that needed no installation or administrator; version 1.0 was released in August 2000. SQLite is dedicated to the public domain, and its modern file format was established with SQLite 3.0 in 2004. It emphasizes reliability, small footprint, and long-term stability.
Sources
- SQLite — official website · as of 2026-07-17
- SQLite — About · as of 2026-07-17