Benchmarked SQLite write performance 11 ways and the result was not what I expected. The database wasn't the bottleneck. The ORM was. Raw sqlite3.executemany hits 88K r/s. SQLAlchemy caps at 3,800. The ORM throughput stays flat from 3M rows to 50M rows — it's so slow it never even touches SQLite's actual I/O scaling curve. The raw path drops 25% over the same range because it actually hits B-tree depth and WAL checkpoint costs. Full breakdown with industry comparison (Expensify 4M QPS, Litestream, Cloudflare D1) in the post. submitted by /u/Content-Berry-2848 [link] [comments]