In Search of a Faster SQLite(avi.im)
336 points by avinassh | 140 comments
Blog post with notes on the paper "Serverless Runtime / Database Co-Design With Asynchronous I/O", the research behind Limbo, a Rust rewrite of SQLite.
First screen, captured .
Looks similar
Fun facts about SQLite(avi.im)
310 points by avinassh | 127 comments
SQLite Index Visualization(mrsuh.com)
274 points by mrsuh | 23 comments
Bloom Filters(eli.thegreenplace.net)
170 points by mfrw | 54 comments
SQLite does not do checksums(avi.im)
96 points by todsacerdoti | 68 comments
Related stories
SQLite: 35% Faster Than the Filesystem(sqlite.org)
374 points by yla92 | 127 comments
SQLite documentation page explaining that reading and writing small blobs in SQLite is about 35% faster and uses less disk space than individual files.
SQLite JSON at full index speed using generated columns(dbpro.app)
334 points by upmostly | 102 comments
A DB Pro blog post explaining how to index JSON data in SQLite using virtual generated columns for fast queries.
So you want to parse a PDF?(eliot-jones.com)
369 points by UglyToad | 199 comments
Blog post by Eliot Jones explaining how PDF parsing should work per the spec, covering headers, cross-reference tables, object offsets and trailers, and its real-world pitfalls.
Show HN: PgQueuer – Transform PostgreSQL into a Job Queue(github.com)
350 points by jeeybee | 110 comments
GitHub repository for PgQueuer, a Python library that uses PostgreSQL and LISTEN/NOTIFY to implement an efficient job queue.
Twelve years of distributed SQLite(philipotoole.com)
365 points by otoolep | 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.
Make Ubuntu packages 90% faster by rebuilding them(gist.github.com)
513 points by jeffbee | 323 comments
A GitHub Gist explaining how rebuilding Ubuntu's jq package from the same source with different build options yields about 90% better performance.