SYSTEM Cited by 1 source

SQLite

Definition

SQLite is an in-process, single-file embedded relational database — an engine linked directly into the application, running in its address space with no separate server. It is one of the most widely deployed software components in the world (browsers, phones, operating systems, countless apps), which makes it the canonical proof that packaging a data engine as an embeddable library is enormously effective. (Source: sources/2026-08-26-allthingsdistributed-duckdb-and-the-changing-physics-of-analytics)

Why it matters for this wiki

SQLite is the explicit template for DuckDB. DuckDB's 2019 SIGMOD demo paper used SQLite's popularity as the example of how effective it is to package an engine to be embedded inside applications — then argued for the value of an equivalent analytics-focused (OLAP, not OLTP) data-processing library. Where SQLite is the embedded engine for transactional/relational workloads, DuckDB is the embedded analytics engine for columnar/analytical ones. See analytics-engine-as-embedded-library. (Source: sources/2026-08-26-allthingsdistributed-duckdb-and-the-changing-physics-of-analytics)

Seen in

• sources/2026-08-26-allthingsdistributed-duckdb-and-the-changing-physics-of-analytics — Referenced as DuckDB's precedent: the DuckDB team "used the popularity of SQLite as an example of how effective it could be to package an engine to be embedded inside applications."

Related

• systems/duckdb — the analytical counterpart modeled on SQLite.
• embedded-analytics-engine — the OLAP generalization of SQLite's embedded model.
• analytics-engine-as-embedded-library — the design pattern.
• concepts/oltp-vs-olap — SQLite (OLTP) vs. DuckDB (OLAP).