The history of SQLite’s rise from a Navy prototype to global dominance

D. Richard Hipp created SQLite in 2000 to replace Informix software on the Navy destroyer USS Oscar Austin. Informix caused the ship’s applications to fail whenever the server went down. Hipp wanted a way to pull data directly from the disk to remove dependencies. The problem on the ship involved an arbitrary directed graph that was NP-complete, which caused Informix to run forever and chew up CPU cycles. The Automated Common Diagrams program needed to identify valves to isolate damage from ruptured pipes, but it failed when the database connection broke. When the database failed, users saw a dialog box stating they could not connect to the database server. Hipp wrote a byte code engine and a compiler to translate SQL into that byte code. During a government funding hiatus in 2000, caused by a fight between Newt Gingrich and Bill Clinton, Hipp decided to write the database engine. Motorola paid Hipp $80,000 in 2001 to support a new cell phone operating system. AOL also used the engine to manage data on CDs.

Trillions of deployments

SQLite exists in over one trillion active databases. This scale makes it one of the five most deployed software modules on the planet. The engine acts as the default local database for Android and iOS, and it remains embedded in Chrome. Motorola provided Hipp with $80,000 in 2001 to support a new cell phone operating system. AOL later used the engine to handle data on CDs. I notice that the engine’s reach extends from mobile phones to commercial planes and even to the cars on the road. While the engine powers billions of devices, it remains a small, self-contained C library that users can embed into almost any application without needing a separate server process to manage the data. Most developers use it for offline capabilities when they need data to persist without an internet connection. The library has built-in support in the standard libraries of Python and PHP. More copies exist than there are people on Earth. It also supports the B-Tree algorithm based on the work of Donald Knuth. How many more trillions of databases will appear in the next decade?

Technical constraints and features

The library is a 1MB file that requires zero configuration and operates under a public domain license. This means anyone can copy, modify, or sell the code without restrictions. SQLite provides full ACID transaction support and standard SQL query language features. However, the engine lacks built-in encryption for data at rest or in transit at levels like 128-bit. It also cannot handle hundreds of active downstream IoT devices attempting to write to a single instance at the same time. This single-client limitation prevents it from serving as a scalable solution for environments with hundreds of active users. You can embed the entire database into a single application as a single C library.

SQLite utilizes five data types: NULL, INTEGER, REAL, TEXT, and BLOB. The engine employs type affinity where the type works by substring match. Expensify runs a custom database called Bedrock that is built on top of SQLite. David Barrett, the CEO of Expensify, used SQLite for a 40GB database in 2012. Richard Hipp originally told Barrett that he was pushing SQLite beyond its intended use. Now, Expensify uses it to power its multi-datacenter deployments. The SQLite team maintains 600 lines of test code for every line of production code, including fuzz tests and regression tests. They use the DO-178B development process used for safety critical software. The developers manage the source code using Fossil. Foreign keys are disabled by default and must be opted in. The 3.50.0 version released in May 2025 added Unicode functions for the 25th anniversary. Hwaci sells a Warranty of Title to organizations that need legal proof of their right to use the software. The B-Tree was coded by Hipp while traveling on a plane.