proofler: 430 Checks Across Five Libraries, Zero Workarounds
Integration testing five SQLite-backed Python libraries through their public APIs. 16 bugs found and fixed at the source. What the seams between libraries actually look like under chaos.
Posts tagged: sqlite
6 posts
sqler: The Columnar Baseline
Parts 1–4 measured ORM overhead: sqler vs raw sqlite, both using JSON storage. This post asks a different question. What does the document-oriented architecture itself cost? Equality filter: 11x. Aggregates: 9.5x. JSONL export: 1.0x.
qler: The Honest Benchmark
qler vs Celery+Redis — 7 scenarios, 3 rounds, and one embarrassing 12x gap we found by benchmarking ourselves honestly.
sqler: The Final Scorecard
1,725 measurements, 4 scales, 10.5 hours. Bulk insert 0.89x (faster than raw sqlite). FTS ranked 1.00x. Everything else ≤1.15x. One irreducible gap at 1.34x.
sqler: Five Fixes, Five Days
FTS rebuild from 4.65x to 1.03x (benchmark bug). Bulk insert from 1.9x to 0.89x (faster than raw sqlite). FTS ranked from 1.50x to 1.00x (single JOIN). Plus msgspec at 5.1x hydration.
sqler: Probably Good Enough Benchmarks
We wrote 22 benchmarks; every one was biased in our favor. An adversarial audit found 18 fairness issues. The rewrite made every number worse but useful.