SQLite

Links
​EXPLAIN QUERY PLAN - SQL command that is used to obtain a high-level description of the strategy or plan that SQLite uses to implement a specific SQL query.
​FTS5 - SQLite virtual table module that provides full-text search functionality to database applications.
​Awesome SQLite​
​All things around SQLite​
​SQLite 3.32.0 (2020) (HN)
​Scaling SQLite to 4M QPS on a Single Server (EC2 vs Bare Metal) (2018) (HN)
​sqlite-web - Web-based SQLite database browser written in Python.
​DB Browser for SQLite - High quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
​SQLancer - Detecting Logic Bugs in DBMS. (HN)
​SQLite As An Application File Format (HN) (Lobsters)
​How does SQLite work? (2014) (HN)
​SQLite Localtime Date Modifier is Slow (2019)​
​Why SQLite succeeded as a database (2016)​
​Appropriate Uses For SQLite​
​SQLite 3.33 adds support for UPDATE FROM (HN)
​SQLite: Protégé of PostgreSQL (2014) (Tweet)
​SQLite Quirks and Gotchas​
​sqlite-utils - Python CLI utility and library for manipulating SQLite databases.
​CG/SQL - Easy, accurate SQLite code generation. (Article)
​SQLite: Begin Concurrent​
​SQLite now allows multiple recursive SELECT statements in a single recursive CTE (2020) (HN)
​Making SQLite Upserts Snappy (with Python and SQLAlchemy) (2020)​
​pgsqlite - PostgreSQL extension that embeds SQLite3 and uses large objects as storage.
​sqlite-diffable - Tools for dumping/loading a SQLite database to diffable directory structure.
​hybrid-disk-cache - Hybrid disk cache library that utilized both the solid SQLite3 and file system.
​SQLite briefing for Linux kernel hackers (HN)
​Richard Hipp - SQLite lecture (2015)​
​SQLite as a Document Database (2020) (HN)
​Dqlite - High-Availability SQLite. (Code)
​LiteTree - SQLite with Branches.
​Working with SQLite using Go and Python (2020)​
​sandman2 - Generates a RESTful API service from your existing database, without requiring you to write a line of code. Works with SQLite.
​node-sqlite - SQLite client for Node.js applications with SQL-based migrations API written in TypeScript.
​What If OpenDocument Used SQLite?​
​The Use Of assert() In SQLite​
​simple-graph - Graph database in SQLite. (Lobsters) (HN)
​SQLite is 35% Faster Than The Filesystem​
​SQLiteC++ - Smart and easy to use C++ SQLite3 wrapper.
​sqlite-worker - Simple, and persistent, SQLite database for Web and Workers.
​Grafito - Portable, Serverless & Lightweight SQLite-based Graph Database.
​GRDB.swift - Toolkit for SQLite databases, with a focus on application development. (Web)
​edge-sql - Serverless edge worker embedding SQLite using Cloudflare Workers and WASM. (Code) (HN)
​Litestream - Streaming replication for SQLite. (Why I Built Litestream (2021)) (HN) (Lobsters)
​Rqlite - Lightweight, distributed relational database built on SQLite. (HN)
​SQLite CREATE TABLE Parser​
​sqlite-transform - Tool for running transformations on columns in a SQLite database.
​SQLite DB Migrations with PRAGMA user_version​
​Many Small Queries Are Efficient In SQLite​
​Rust SQLite - SQLite clone from scratch in Rust.
​Command Line Shell for SQLite (HN)
​sqleet - Encryption extension for SQLite3.
​SQLite Viewer - View SQLite file online. (Code)
​Amalgalite - SQLite embedded in a Ruby extension.
​Cross-Database Queries in SQLite (2021) (HN)
​Build SQLite Extensions in Go​
FoundationDB
Prometheus
Last modified 5mo ago
Copy link