Some SQLite

A collection of some SQLite resources.

Applications

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

Extensions

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

JavaScript

JavaScript programming language

name	summary	tags
deno-sqlite	A Deno module with SQLite embedded as WebAssembly	deno; webassembly

Tutorial

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.

Utilities

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

Licence

This dataset is licensed under the Creative Commons Zero v1.0 Universal.