SQLite vs DuckDB on the same $16 box: every cliff moved 100x
Jovan Stojiljkovic runs the comparison that embedded-database conversations often skip: the same observability application, the same inexpensive machine, and disclosed load and read thresholds. For wide scans, aggregations, and telemetry retention, DuckDB's columnar execution moves the practical limit dramatically. The most valuable part is not the headline multiplier; it is the attempt to define a real user-facing read cliff and publish the conditions behind it.
The Hacker News discussion correctly narrows the conclusion. DuckDB is not a generic replacement for SQLite: its strengths are analytical scans and local batch work, while SQLite remains a durable fit for transactional application state and different concurrency needs. Benchmarks should make the workload decision sharper, not turn two distinct engines into a universal winner and loser.