Fun facts about SQLite(avi.im)
310 points by avinassh | 127 comments
First screen, captured .
Looks similar
How bloom filters made SQLite 10x faster(avi.im)
450 points by avinassh | 85 comments
Blog post summarizing the paper "SQLite: Past, Present, and Future" and explaining how Bloom filters made SQLite analytical queries 10x faster.
Subtleties of SQLite Indexes(emschwartz.me)
117 points by emschwartz | 51 comments
SQLite does not do checksums(avi.im)
96 points by todsacerdoti | 68 comments
SQLite Index Visualization(mrsuh.com)
274 points by mrsuh | 23 comments
Executable Is a SQLite Database(fzakaria.com)
479 points by setheron | 90 comments
Blog post by Farid Zakaria on replacing the ELF executable format with SQLite databases, and how the idea pairs with Nix.
Related stories
SQLite-on-the-server is misunderstood: Better at hyper-scale than micro-scale(rivet.gg)
332 points by PaulHoule | 151 comments
A Rivet blog post by CTO Nathan Flurry arguing that SQLite-on-the-server suits hyper-scale sharded databases better than small-scale apps.
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.
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.
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.
Cloud Backed SQLite(sqlite.org)
414 points by nalgeon | 125 comments
Documentation for Cloud Backed SQLite, a system for storing and accessing SQLite databases in cloud blob storage such as Azure and Google Cloud.
How bloom filters made SQLite 10x faster(avi.im)
450 points by avinassh | 85 comments
Blog post summarizing the paper "SQLite: Past, Present, and Future" and explaining how Bloom filters made SQLite analytical queries 10x faster.