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