SQLite Home Page
SQLite - Wikiwand
SQLite Tutorial - An Easy Way to Master SQLite Fast
SQLite Tutorial - Tutorialspoint
Many Small Queries Are Efficient In SQLite
The SQLite OS Interface or "VFS"
JSON Functions And Operators included in 3.38 (2022-02)
List of SQLite Syntax Diagrams
SQLite Syntax: sql-stmt
How does SQLite work? Part 1: pages! - Julia Evans
The Origin of SQLite, the World’s Most Widely-Used Database – The New Stack
Why you should use SQLite | InfoWorld
Why SQLite may become foundational for digital progress | VentureBeat
A hands-on tutorial of SQLite3 | Opensource.com
SQLite Tutorial - An Easy Way to Master SQLite Fast
kripken/sql.js: SQLite compiled to JavaScript through Emscripten
mapbox/node-sqlite3: Asynchronous, non-blocking SQLite3 bindings for Node.js
Using SQLite /w Node.js for Rapid Prototyping — Medium
sqlite-utils documentation Python
#201: SQLite with Richard Hipp - Changelog
GUI Client
SqliteMan
SQLiteStudio
DB Browser for SQLite
Datasette
simonw/datasette: A tool for exploring and publishing data
Datasette — Datasette documentation
Simon Willison: Datasette and Datasette Publish - YouTube
Datasette: instantly create and publish an API for your SQLite databases
Datasette Lite runs Datasette in browser with Pyodide
Datasette Lite: a server-side Python web application running in a browser
CLI client
Command Line Shell For SQLite
SQLite commands and general usage
SQLite - the sqlite3 command line tool
sqlite> .mode
Error: mode should be one of: ascii column csv html insert line list tabs tcl
sqlite> .mode LIST
sqlite> .headers ON
sqlite> .tables
sqlite> PRAGMA table_info(Table);Or specify when invoking sqlite: sqlite3 -list -header <db>
LiteCLI
dbcli/litecli: CLI for SQLite Databases with auto-completion and syntax highlighting
LiteCLI - SQLite Client with Autocomplete
sqlite-utils command-line tool - sqlite-utils
Application
I'm All-In on Server-Side SQLite · The Fly Blog
Scaling
Litestream - Streaming SQLite Replication
How it works - Litestream
I'm All-In on Server-Side SQLite · Fly
superfly/litefs: FUSE-based file system for replicating SQLite databases across a cluster of machines
litefs/ARCHITECTURE.md at main · superfly/litefs
Introducing LiteFS · Fly