Fun facts about SQLite (avi.im)

Screenshot of avi.im: Fun facts about SQLite

First screen, captured 1 year ago.

Looks similar

Screenshot of avi.im: In Search of a Faster SQLite

In Search of a Faster SQLite (avi.im)

336 points by avinassh 1 year ago | 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.

sqlite limbo rust async-io

Screenshot of avi.im: How bloom filters made SQLite 10x faster

How bloom filters made SQLite 10x faster (avi.im)

450 points by avinassh 1 year ago | 85 comments

Blog post summarizing the paper "SQLite: Past, Present, and Future" and explaining how Bloom filters made SQLite analytical queries 10x faster.

sqlite bloom-filters query-optimization database-internals

Screenshot of avi.im: PSA: SQLite WAL checksums fail silently and may lose data

PSA: SQLite WAL checksums fail silently and may lose data (avi.im)

266 points by avinassh 1 year ago | 121 comments

Screenshot of avi.im: SQLite does not do checksums

SQLite does not do checksums (avi.im)

96 points by todsacerdoti 1 year ago | 68 comments

Screenshot of emschwartz.me: Subtleties of SQLite Indexes

Subtleties of SQLite Indexes (emschwartz.me)

117 points by emschwartz 1 year ago | 51 comments

Screenshot of mrsuh.com: SQLite Index Visualization

SQLite Index Visualization (mrsuh.com)

274 points by mrsuh 1 year ago | 23 comments

Looks similar

In Search of a Faster SQLite(avi.im)

How bloom filters made SQLite 10x faster(avi.im)

PSA: SQLite WAL checksums fail silently and may lose data(avi.im)

SQLite does not do checksums(avi.im)

Subtleties of SQLite Indexes(emschwartz.me)

SQLite Index Visualization(mrsuh.com)