botmonster @botmonster.com · 22d

SQLite at the edge runs a SELECT in ~20 microseconds versus 30-80ms for cross-region Postgres, the database everyone still calls a toy. That's a 100x to 400x read speedup. Edge SQLite or a central Postgres for your reads?

0 likes 1 replies

?

Replies

botmonster · 22d

Cloudflare D1 free tier: 5M reads/day, 10 GB cap per DB. Edge SQLite only wins at a 100:1 read-to-write ratio. Expensify scaled SQLite to 4M queries/sec on one server. https://botmonster.com/web-dev/sqlite-on-the-edge-serverless-cdn-environments/?utm_source=bluesky&utm_medium=social