Tools · SPBoucher
Menu

SQLite

In-depth entry

by SQLite Consortium / Hipp, Wyrick & Company · Database

Public-domain embedded SQL database engine that stores a whole database in one file and ships inside most operating systems and browsers

Open sourceOpen sourceFreeLocalSelf-hostable
Visit official site Compare

Link verified Nov 2, 2026

Overview

SQLite is an embedded relational database engine written in C, developed by D. Richard Hipp's team and supported by the SQLite Consortium. The source code is dedicated to the public domain, so it can be embedded in any product without license obligations. Rather than running as a server, SQLite is a library linked into the host program; a complete database, with its tables, indexes and schema, lives in a single cross-platform file.

The engine supports most of SQL-92 plus later additions such as window functions, common table expressions, JSON functions, generated columns and strict tables. Optional extensions add full-text search (FTS5), R*Tree spatial indexing and session-based change tracking. A write-ahead log mode allows readers and one writer to work concurrently. A command-line shell is included, and bindings exist for essentially every language; Python, for example, ships the sqlite3 module in its standard library.

SQLite is the storage layer of iOS, Android and macOS system services, of all major web browsers and of countless desktop and mobile applications. In research and small-service contexts it serves as a zero-configuration store for configuration, caches, experiment results and application data; many web applications run on it in production when write concurrency is modest. Litestream-style replication and the backup API cover simple durability needs.

The design imposes clear limits: a single writer at a time per database file, no network protocol or user management, flexible typing that differs from strict SQL engines unless strict tables are used, and performance characteristics tuned for transactional rather than large analytical scans, where DuckDB is the usual companion.

Editorial note on uncertainty. license_spdx is omitted on purpose: SQLite is public domain rather than licensed under an SPDX-listed license.

Capabilities

  • Serverless library engine with a single-file database
  • Transactions with rollback journal or write-ahead log
  • Window functions, CTEs, JSON functions and generated columns
  • FTS5 full-text search and R*Tree extensions
  • Command-line shell and bindings in most languages
  • Online backup API and attachable multiple databases

Typical workflows

  1. Local application data store for desktop or mobile apps
  2. Cache or results store inside a Python or Node script
  3. Lightweight backing database for a low-traffic web service
  4. Portable dataset distribution as a single file

Strengths

  • No installation, configuration or server process
  • Public-domain code embeddable anywhere
  • Stable, backward-compatible file format
  • Extremely wide platform and language support

Limitations

  • One writer at a time per database file
  • No built-in network access or user management
  • Flexible typing unless strict tables are declared
  • Analytical scans over large tables favor columnar engines

Prerequisites

  • A host program or language runtime with SQLite bindings (most include them)

Who it is for

  • Application developers
  • Data scientists needing a local store
  • Embedded and mobile developers

Alternatives & comparison

DuckDB shares the embedded, single-file design but is columnar and tuned for analytical queries, whereas SQLite is row-oriented and optimized for transactional access and small reads and writes. PostgreSQL and MySQL are networked servers with concurrent writers, users and replication, which SQLite deliberately omits. Kùzu applied the same embedded idea to property graphs before its archival.

  • Apache Parquet

    Open columnar file format for analytical data with compression, encodings and statistics, readable by nearly every data engine and library

    Open sourceOpen source
  • DuckDB

    In-process analytical SQL database that queries Parquet, CSV and Arrow data directly from Python, R, Node or the CLI

    Open sourceOpen source
  • Kùzu

    Embedded property-graph database with Cypher, vector and full-text search; MIT-licensed but archived in October 2025 after the company was acquired

    Open sourceOpen source
  • MySQL

    Oracle's widely deployed open-source relational database server, offered as a GPL community edition and commercial enterprise and cloud editions

    MixedOpen source
  • PostgreSQL

    Open-source object-relational database server with a large extension ecosystem (PostGIS, pgvector, TimescaleDB) and broad SQL coverage

    Open sourceOpen source
Compare SQLite with its alternatives →

Sources & verification

Primary sources consulted for this record. Claims are tied to the fields each source supports; the automated link checker re-verifies every URL on a schedule.

  • License
    SQLite Copyright

    https://sqlite.org/copyright.html

    Supports: source_model, pricing_model

    Code is dedicated to the public domain; no SPDX license identifier recorded

    checked Nov 1, 2026
  • Official documentation
    SQLite Documentation

    https://sqlite.org/docs.html

    Supports: capabilities, data_formats, interfaces

    checked Nov 1, 2026
  • Official site
    SQLite Home Page

    https://sqlite.org/

    Supports: name, summary, product_status

    checked Nov 1, 2026
  • Repository
    SQLite source repository (Fossil)

    https://sqlite.org/src/doc/trunk/README.md

    Supports: repo_url

    checked Nov 1, 2026
Confidence
High
Reviewed
Nov 1, 2026
Links
Verified · Nov 2, 2026

Spotted an error?

Broken link, outdated license, wrong category, or a tool that no longer exists? Tell us; reports are reviewed by the editor.

ClickHouse

ClickHouse, Inc. · Analytical engines & OLAP

In-depth entry

Open-source columnar OLAP database server for fast aggregations over billions of rows, with MergeTree storage, SQL and a managed ClickHouse Cloud

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

pgvector

Andrew Kane (pgvector project) · Vector databases

In-depth entry

PostgreSQL extension adding vector types, distance operators and HNSW/IVFFlat indexes for similarity search inside the database

PostgreSQLOpen sourceFreeSelf-hostedNov 2, 2026

PostGIS

PostGIS Project Steering Committee (OSGeo) · GIS & mapping

In-depth entry

Spatial extension for PostgreSQL adding geometry, geography and raster types with indexing and hundreds of SQL functions

GPL-2.0-or-laterOpen sourceFreeSelf-hostedNov 2, 2026

Neon

Neon (Databricks) · Relational databases

Serverless PostgreSQL service with separated storage and compute, instant database branching and scale-to-zero, now part of Databricks

Apache-2.0FreemiumPaidNov 2, 2026

Supabase

Supabase Inc. · Relational databases

Open-source backend platform built around a dedicated PostgreSQL database with auto-generated APIs, authentication, file storage, realtime subscriptions and edge functions

Apache-2.0Open sourceFreemiumSelf-hostedNov 2, 2026

Prisma ORM

Prisma Data, Inc. · Web frameworks & UI

TypeScript ORM with a declarative schema language, generated type-safe client and migration tooling, from the company that also offers Prisma Postgres and related hosted services

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026