Queryable Executables(fzakaria.com)

280 points by rguiscard 2 months ago | 75 comments

Three ways to smuggle SQLite into Nix(fzakaria.com)

15 points by domenkozar 2 months ago | 4 comments

Nix wrote half of my debugger(fzakaria.com)

226 points by ingve 17 days ago | 54 comments

Blog post by Farid Zakaria describing how Nix helped build a debugger on top of Rewind VM, a deterministic VM for Nix builds.

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

152 points by Maksadbek 3 years ago | 57 comments

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

52 points by markusw 1 year ago | 70 comments

My Database Is My Application: Rethinking Webhook Logic with DuckDB and SQL(hey.earth)

14 points by chw9e 1 year ago | 1 comments

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.

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 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.

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.

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.

JSONB has landed(sqlite.org)

579 points by nalgeon 2 years ago | 181 comments

SQLite forum post by Richard Hipp announcing JSONB, a binary rewrite of SQLite's JSON functions that landed on trunk and can be several times faster.