A collection of some SQLite resources.
Solutions using SQLite as a building block.
| name | summary | tags |
|---|---|---|
| simple-graph | A graph database in SQLite inspired by 'SQLite as a document database'. | python |
| LiteTree | A modified version of the SQLite engine to support branches a-la Git. | c |
| bibliothecula | Document organizer with tags and full-text-search, in a simple and clean sqlite3 schema | python; rust |
| git-history | Tools for analyzing Git history using SQLite | git; python |
| marmot | A distributed SQLite replicator. | go; utilities |
| libSQL | LibSQL is a fork of SQLite that is both Open Source, and Open Contributions. | c; rust; utilities |
| ChiselStore | ChiselStore is an embeddable, distributed SQLite for Rust, powered by Little Raft. | rust |
| Dqlite | Dqlite is a fast, embedded, persistent SQL database with Raft consensus that is perfect for fault-tolerant IoT and Edge devices. | application; c |
| sqlite-difftable | Tools for dumping/loading a SQLite database to diffable directory structure - GitHub - simonw/sqlite-diffable: Tools for dumping/loading a SQLite database to diffable directory structure. | python; utilities |
| Ploomber | The fastest way to build data pipelines. Develop iteratively, deploy anywhere. | data_analysis; python; utilities |
| litefs | FUSE-based file system for replicating SQLite databases across a cluster of machines | go; utilities |
| SQLPage | A web server driven by SQL queries. | rust |
| SQLedge | A tool to stream changes from Postges to SQLite so the database can run on the edge. | go |
| SQLSync | A collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge. | rust |
| Redka | Redis re-implemented with SQLite. Contribute to nalgeon/redka development by creating an account on GitHub. | go |
| Limbo | An in-process OLTP database management system, compatible with SQLite. | data_analysis; rust |
| starbasedb | HTTP SQLite scale-to-zero database on the edge built on Cloudflare Durable Objects. | typescript |
| litecli | A command-line client for SQLite databases that has auto-completion and syntax highlighting. | python; utilities |
Extensions to enhance SQLite.
| name | summary | tags |
|---|---|---|
| sqlite-parquet-vtable | A SQLite virtual table extension to expose Parquet files as SQL tables. | utilities |
| SQLCipher | A SQLite extension adding on-the-fly encryption, tamper detection, strong key derivation and memory sanitisation. | security |
| SpatiaLite | A library intended to extend the SQLite core to support fully fledged Spatial SQL capabilities. | geospatial; utilities |
| SQLean | Extends SQLite with json1, math, re, stats, text, unicode and vsv at once. | c; utilities |
| Verneuil | Verneuil is a VFS extension for SQLite that asynchronously replicates databases to S3-compatible blob stores. | c; rust |
| XLite | A SQLite extension to query Excel files as virtual tables. | rust; utilities |
| sqlite-zstd | Transparent dictionary-based row-level compression for SQLite. | rust; utilities |
| sqlite-lines | A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.) | c; utilities |
| sqlite-html | A SQLite extension for querying, manipulating, and creating HTML elements. | go; utilities |
| libgsqlite | A SQLite extension which loads a Google Sheet as a virtual table. | rust; utilities |
| cr-sqlite | Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite. | c |
| pivot_vtab | An extension implementing pivot tables as virtual tables. | c; data_analysis; utilities |
| sqlite-xsv | A SQLite extension to query CSV as virtual tables. | rust |
| Mycelite | A SQLite extension that allows you to synchronize changes from one instance of SQLite to another. | rust; utilities |
| Stanchion | A SQLite extension that brings column-oriented tables to SQLite | c; data_analysis; zig |
| sqlite-lembed | A SQLite extension for generating text embeddings from GGUF models using llama.cpp. | c |
JavaScript programming language
| name | summary | tags |
|---|---|---|
| deno-sqlite | A Deno module with SQLite embedded as WebAssembly | deno; webassembly |
Resources for learning SQLite, SQL and related topics.
| name | summary | tags |
|---|---|---|
| SQL Teaching | An interactive tutorial to learn the rudiments of SQL using SQLite in the browser. | javascript |
| Optimising SQLite for servers | A tutorial on how to optimise SQLite for backend applications. |
Useful tools to work with SQLite.
| name | summary | tags |
|---|---|---|
| sqlite-utils | Python CLI utility and library for manipulating SQLite databases. | python |
| datasette | An open source multi-tool for exploring and publishing data. | python |
| rqlite | A distributed relational database. | go |
| sqleton | A tool to visualise SQLite database schemas. | javascript |
| Litestream | Litestream is a standalone streaming replication tool for SQLite. | go |
| sqlitebiter | A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file. | python |
| sqlime | An online SQLite playground for debugging and sharing SQL snippets. Kinda like JSFiddle or CodePen, but for SQL instead of JavaScript. | webassembly |
| sqlite-loadable-rs | A framework for writing fast and performant SQLite extensions in Rust | rust |
| mvSQLite | MVCC SQLite that runs on FoundationDB. | rust |
| sqlite-schema-diagram | A SQLite schema diagram generator. | sql |
This dataset is licensed under the Creative Commons Zero v1.0 Universal.