SQLite

SQLite
source
Name	SQLite
Caption	SQLite logo
Developer	D. Richard Hipp
Released	17 August 2000
Operating system	Cross-platform
Genre	RDBMS (embedded)
License	Public domain
Website	https://www.sqlite.org/

SQLite. It is a widely deployed, self-contained, serverless, and zero-configuration relational database management system contained in a compact C library. The software implements most of the SQL standard and stores an entire database as a single cross-platform file on a host machine. Its design emphasizes reliability, simplicity, and ease of integration, making it a foundational component in countless applications and operating systems worldwide.

Overview

Unlike client-server database engines such as MySQL, PostgreSQL, or Oracle Database, it operates without a separate server process. The library reads and writes directly to ordinary disk files, a design that eliminates configuration and administration overhead. This architecture has led to its adoption as the primary data storage format for many prominent platforms, including the Android platform, the Safari browser, and the macOS and iOS operating systems. Its public domain status, granted by its author D. Richard Hipp, removes licensing barriers and encourages widespread use in both open-source and proprietary projects.

Features

Key characteristics include full ACID compliance, ensuring reliable transaction processing even during system crashes or power failures. It supports most of the SQL-92 standard, including complex queries with joins, subqueries, and triggers. The system implements a dynamic type system, which is more flexible than the static typing found in traditional RDBMS software. Other notable capabilities include in-memory databases, online backup, and full-text search integration. The entire library is typically less than 750 KiB in size, making it ideal for embedded systems and constrained environments.

History

The project was started in 2000 by D. Richard Hipp while working for General Dynamics on a program for the United States Navy. The initial goal was to create a database that did not require an administrative setup, inspired by frustrations with installing and configuring Oracle Database. The name "SQLite" was chosen to emphasize its lightweight nature. It gained significant traction after being adopted by the Mozilla Foundation for the Firefox browser and later by Google for the Android operating system. The project is overseen by Hwaci, a company founded by Hipp, which manages development and testing.

Design

The core architecture is built around a compact virtual machine that processes SQL statements by operating on a B-tree based pager and a sophisticated journaling system. This journal, typically using a write-ahead log (WAL) mode, is central to its ACID properties. The entire database is contained within a single cross-platform disk file, with a well-documented and stable file format. The library interface is minimal, with core functions like sqlite3_open() and sqlite3_exec() providing the primary API. This design prioritizes simplicity and robustness, avoiding complex client-server protocols or network dependencies.

Use cases

It is the database engine of choice for local/client storage in application software, including media players like VLC media player and financial tools like TurboTax. It serves as the on-device storage for mobile applications on iOS and Android, and as the backend for many desktop applications built with frameworks like Qt or Electron. Web browsers such as Google Chrome, Mozilla Firefox, and Safari use it for storing history, cookies, and other metadata. It is also extensively used as an embedded database in devices ranging from set-top boxes to industrial control systems.

Technical details

The source code, written in ANSI C, is highly portable and can compile on any platform with a standard C compiler, from supercomputers to microcontrollers. It uses a test suite with nearly 100% branch test coverage, a practice championed by Hipp to ensure exceptional reliability. The system employs a bytecode engine, where SQL statements are compiled into an internal instruction set executed by the virtual machine. Concurrency is managed via file locking mechanisms and the WAL mode, allowing multiple readers and a single writer. The file format is stable, backward-compatible, and publicly documented, ensuring long-term data accessibility.

Category:Database management systems Category:Free database management systems Category:Software using the public domain license Category:Cross-platform software