←back to thread

Zero-latency SQLite storage in every Durable Object

(simonwillison.net)
285 points ajhit406 | 1 comments | 13 Oct 24 23:07 UTC | HN request time: 0.204s | source
Show context
kikimora ◴[14 Oct 24 16:02 UTC] No.41838799[source]▶
This design does not handle hot partitions well and they are ubiquitous to so many domains.
replies(1): >>41839511 #
1. simonw ◴[14 Oct 24 17:07 UTC] No.41839511[source]▶
Your partition would have to be VERY hot for SQLite not to be able to handle it - anything up to several thousand writes per second would likely work fine.

Since this is all running on Cloudflare you could scale reads with a 1 second cache TTL somewhere, which would drop your incoming read queries to around one per second no matter how much read traffic you had.