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

6 points by emschwartz 10 months ago | 0 comments

Subtleties of SQLite Indexes(emschwartz.me)

117 points by emschwartz 1 year ago | 51 comments

Building docs like a product(emschwartz.me)

58 points by emschwartz 8 months ago | 6 comments

A Faster Alternative to Jq(micahkepe.com)

358 points by pistolario 7 months ago | 226 comments

Blog post introducing jsongrep, a JSON query tool, explaining its automata-based search engine and benchmarks against jq, jmespath, jsonpath-rust, and jql.

Knuth and McIlroy Approach a Problem (2021)(matt-rickard.com)

49 points by ingve 3 years ago | 18 comments

SQLite Index Visualization(mrsuh.com)

274 points by mrsuh 1 year ago | 23 comments