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

52 points by WA9ACE 1 year ago | 15 comments

Short-Circuiting Correlated Subqueries in SQLite(emschwartz.me)

6 points by emschwartz 10 months ago | 0 comments

How RocksDB Works(artem.krylysov.com)

235 points by DAlperin 3 years ago | 49 comments

Tablesample Picks Rows(boringsql.com)

3 points by surprisetalk 4 days ago | 0 comments

A technical blog post explaining how PostgreSQL's TABLESAMPLE SYSTEM and BERNOULLI methods select rows by hashing physical addresses, and the resulting sampling biases.

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

152 points by Maksadbek 3 years ago | 57 comments

How large should your sample size be?(vickiboykis.com)

29 points by sebg 1 year ago | 22 comments