What if we treated Postgres like SQLite?(maragu.dev)

52 points by markusw 1 year ago | 70 comments

We still chose C++ (instead of Rust) for new database development(eloqdata.com)

45 points by the_precipitate 1 year ago | 51 comments

SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s(phiresky.github.io)

152 points by Maksadbek 3 years ago | 57 comments

The Case of a Curious SQL Query(buttondown.email)

162 points by petercooper 3 years ago | 37 comments

InfluxDB 3.0 System Architecture(influxdata.com)

52 points by ren_engineer 3 years ago | 15 comments

100k TPS over a billion rows: the unreasonable effectiveness of SQLite(andersmurphy.com)

344 points by speckx 10 months ago | 124 comments

Blog post by Anders Murphy benchmarking SQLite at 100k transactions per second over a billion rows, arguing its embedded single-writer design helps it scale.

SQLite is all you need for durable workflows(obeli.sk)

664 points by tomasol 4 months ago | 365 comments

Obelisk blog post arguing that SQLite, backed up to S3, is sufficient for many durable workflow systems, responding to DBOS's Postgres argument.

SQLite JSON at full index speed using generated columns(dbpro.app)

334 points by upmostly 10 months ago | 102 comments

A DB Pro blog post explaining how to index JSON data in SQLite using virtual generated columns for fast queries.

A faster way to copy SQLite databases between computers(alexwlchan.net)

437 points by ingve 1 year ago | 169 comments

Blog post by Alex Chan describing a faster method to copy large SQLite databases from remote servers to a local machine than plain rsync.

Executable Is a SQLite Database(fzakaria.com)

479 points by setheron 2 months ago | 90 comments

Blog post by Farid Zakaria on replacing the ELF executable format with SQLite databases, and how the idea pairs with Nix.

Sqlite3 WebAssembly(sqlite.org)

603 points by whatever3 2 years ago | 178 comments

Documentation index for SQLite's official WebAssembly and JavaScript APIs, enabling sqlite3 use in WASM-capable browsers, in beta since version 3.40.

Twelve years of distributed SQLite(philipotoole.com)

365 points by otoolep 2 days ago | 62 comments

Philip O'Toole's blog post recounting the history of distributed SQLite since he launched rqlite in 2014, covering dqlite, Litestream, LiteFS, libSQL/Turso, cr-sqlite and Cloudflare D1.