Wddbfs – Mount a SQLite database as a filesystem(adamobeng.com)

251 points by vitplister 2 years ago | 35 comments

Moving my website from Netlify to Caddy(alexwlchan.net)

12 points by twapi 2 years ago | 2 comments

Replacing a 3 GB SQLite db with a 10 MB FST (finite state transducer) binary(til.andrew-quinn.me)

131 points by hiAndrewQuinn 5 months ago | 26 comments

Hosting SQLite Databases on GitHub Pages (2021)(phiresky.github.io)

52 points by WA9ACE 1 year ago | 15 comments

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

152 points by Maksadbek 3 years ago | 57 comments

Parsing 8-bit integers quickly(lemire.me)

85 points by usdogu 2 years ago | 40 comments

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.

SQLite concurrency and why you should care about it(jellyfin.org)

339 points by HunOL 11 months ago | 155 comments

A Jellyfin server team blog post explaining SQLite concurrency limitations and how Jellyfin addresses database locking issues.

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.

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

664 points by tomasol 5 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.

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.

Instant database clones with PostgreSQL 18(boringsql.com)

386 points by radimm 10 months ago | 148 comments

A boringSQL blog post by Radim Marek explaining how to create instant database clones in PostgreSQL 18 for testing, migrations, and reproducible snapshots.