Awesome SQLite

• SQLite - Official Documentation
• marmot - A distributed SQLite replicator
• litestream - Streaming replication for SQLite
• sqlean - The ultimate set of SQLite extensions
• ws4sqlite - Query SQLite via http and remote clients
• Datasette - Multi-tool for exploring and publishing data
• dqlite - Embeddable, replicated and fault tolerant SQL engine
• litefs - FUSE-based file system for replicating SQLite databases
• mvsqlite - Distributed, MVCC SQLite that runs on FoundationDB
• rqlite - Lightweight, distributed relational database built on SQLite
• SQLite Source Repository - Official Git mirror of the SQLite source tree

Articles

• Consider SQLite
• SQLite is not a toy database
• Advanced SQL/SQLite tutorials
• Writing a SQLite clone from scratch in C
• Scaling SQLite to 4M QPS on a Single Server
• SQLite the only database you will ever need in most cases
• Google Chrome to replace Web SQL with SQLite-based WASM library
• D1 announcement - Cloudflare's newest SQL database, running on SQLite

Desktop

• SQLite Toolbox - Visual Studio extension
• sqlite-gui - Lightweight SQLite editor for Windows
• SQLiteStudio - Create, edit, browse SQLite databases
• Beekeeper Studio - cross-platform SQL editor and database manager
• DB Browser for SQLite
• SQLite Viewer for VSCode

Web

• SQLite fiddle - a WASM-compiled copy of a recent SQLite build in a sandbox
• Datasette Lite - a server-side Python web application running in a browser
• sqliteviz - Instant offline SQL-powered data visualisation in your browser
• sqlite-viewer - Web-based SQLite Explorer
• sqlite-viewer (2) - View SQLite file online
• SQLime - Online SQLite playground

CLI

• sqlite3 | sqlite3.exe - Official Command Line Shell For SQLite
• litecli - CLI for SQLite Databases with auto-completion and syntax highlighting
• sqlite-utils - CLI tool and Python utility functions for manipulating SQLite databases

JavaScript

• sql.js - A javascript library to run SQLite on the web
• absurd-sql - SQLite in your IndexedDB (a backend for sql.js)
• better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js
• denodrivers/sqlite3 - SQLite driver for the Deno runtime (using FFI API)
• remix/indie-stack - The Remix Stack for deploying to Fly with SQLite, auth, testing, linting, formatting

Go

• mattn/go-sqlite3 - sqlite3 driver for go using database/sql (requires gcc)
• go-sqlite3-stdlib - A library for mattn/go-sqlite3 (a set of functions)
• pocketbase - Go/SQLite backend with realtime subscriptions
• riyaz-ali/sqlite - Go library to build SQLite extensions
• crawshaw/sqlite - Low-level Go interface to SQLite
• modernc.org/sqlite - cgo-free port of SQLite
• go-dqlite - Go bindings for libdqlite

SQLite • keep it simple • Twitter