The Database You Defaulted To Might Be Overkill
A developer ran benchmarks comparing three flat-file storage approaches against SQLite. For 1M records, a simple in-memory hash map backed by a JSONL file hit roughly 169,000 requests per second in Rust. SQLite hit 25,000. That is a 4 to 6x gap on reads.
The HN thread hit