Curious what your thoughts are on using sqlite in Durable Objects as an alternative, since you can create new instances on the fly, each with their own 10GB limit.
D1 is built on top of sqlite in DO. With cloudflare DO it may gets a bit complicated but it's doable. Honestly 10 GB is plenty of storage I would migrate to hyberdrive or sub-base if hit by the limit.
Cloudflare is a cloud service provider like any other. I agree with you; you need to understand the pricing section of the services you are using. Regarding DO, they offer two types of storage APIs: in-memory or SQLite-backed. The distributed (uncapped storage) approach can be done via creating a DO object with database memory in-state, persisted data in SQLite, and WAL log in R2. I have done this scalably and cost-efficiently when I built MeridianDB. Regarding your point that this may get expensive, yes, like any metered cloud service. Nevertheless, Cloudflare's offering is very generous: a whopping 5 GB free of charge and then $0.28 per extra GB; there is nothing in the cloud provider space that provides anything like this. In fact, from my experience building and scaling SaaS and my friends' experience, once the software hits 1 GB of data, you would have multiple users, and whether your cloud bill is expensive or not depends on your business model and how profitable the solution is. If a software I build reaches 1 GB of data and generates $0 income, I will sleep on the solution regardless.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Curious what your thoughts are on using sqlite in Durable Objects as an alternative, since you can create new instances on the fly, each with their own 10GB limit.
D1 is built on top of sqlite in DO. With cloudflare DO it may gets a bit complicated but it's doable. Honestly 10 GB is plenty of storage I would migrate to hyberdrive or sub-base if hit by the limit.
Durable Objects now have a per-storage charging, so it may get expensive. There are also charges for reading the data.
Cloudflare is a cloud service provider like any other. I agree with you; you need to understand the pricing section of the services you are using. Regarding DO, they offer two types of storage APIs: in-memory or SQLite-backed. The distributed (uncapped storage) approach can be done via creating a DO object with database memory in-state, persisted data in SQLite, and WAL log in R2. I have done this scalably and cost-efficiently when I built MeridianDB. Regarding your point that this may get expensive, yes, like any metered cloud service. Nevertheless, Cloudflare's offering is very generous: a whopping 5 GB free of charge and then $0.28 per extra GB; there is nothing in the cloud provider space that provides anything like this. In fact, from my experience building and scaling SaaS and my friends' experience, once the software hits 1 GB of data, you would have multiple users, and whether your cloud bill is expensive or not depends on your business model and how profitable the solution is. If a software I build reaches 1 GB of data and generates $0 income, I will sleep on the solution regardless.