SQLite

Overview

SQLite is an embedded relational database that stores everything in one file and needs no server process. It ships in Python's standard library and most operating systems. Checked against SQLite 3.54.1 (2026-10-16) and better-sqlite3 13.0.3; the schema, Node.js and Python code below were run (SQLite 3.45.1 with FTS5, Node 24, Python 3.12).

Instructions

Installation

# Debian/Ubuntu
sudo apt-get install sqlite3
# macOS ships a copy; Homebrew gives a newer one
brew install sqlite
# Node.js driver (version 13 requires Node.js 22 or newer)
npm install better-sqlite3
# Python: sqlite3 is in the standard library, nothing to install