3 ms·
Does anyone, preferably from Cloudflare, know the settings used in D1, since it's a SQLite dialect?
by wiradikusuma 1y ago
Does anyone, preferably from Cloudflare, know the settings used in D1, since it's a SQLite dialect?
- koakuma-chan 1y agoIs D1 a dialect? I thought they actually run SQLite.
- wiradikusuma 1y agoI hit some issues where they worked in localhost but not in production. Fortunately, they're not dealbreakers. Unfortunately, my mind is very good at forgetting bad experiences (especially if they have a workaround), so I don't remember the issues. I do know the transaction is handled "differently".
- kentonv 1y agoD1 is built on Durable Objects, where SQLite is used on top of a custom distributed storage layer. This blog post describes in detail how the system works: https://blog.cloudflare.com/sqlite-in-durable-objects/ https://blog.cloudflare.com/sqlite-in-durable-objects/ In short, while we don't technically fsync, we do much better. If the local disk suddenly explodes, we won't lose confirmed writes. (I wrote much of said storage layer.)