Kebob's recent activity
-
Comment on What's a simple, cheap way to run a database-backed website as a hobbyist? in ~comp
-
Comment on What's a simple, cheap way to run a database-backed website as a hobbyist? in ~comp
Kebob LinkHow much data do you need to store? You could consider the free tiers at one of the DBaaS' cloud offerings: PlanetScale (https://planetscale.com/pricing): based on MySQL. 5GB storage, 1 billion...How much data do you need to store? You could consider the free tiers at one of the DBaaS' cloud offerings:
- PlanetScale (https://planetscale.com/pricing): based on MySQL. 5GB storage, 1 billion row reads/month, 10 million row writes/month.
- CockroachDB (https://www.cockroachlabs.com/lp/serverless/): similar to Spanner, supports PostgreSQL wire protocol. 5GB storage, 50 million RUs (request units)/month
- YugabyteDB (https://www.yugabyte.com/managed/): similar to CockroachDB. 10GB storage, 2 vCPU, 4GB RAM. 500 table or 12.5M row limit, up to 10 concurrent DB connections.
For PlanetScale, you only get one database for free. CockroachDB Serverless on the other hand gives you a cluster which you can create multiple databases under which sounds like a better fit for your use case. I was also mistaken, they give 10GB storage and not 5GB under their free tier.
I also like that you can self-host CockroachDB if you ever wanted to go that route later. PlanetScale is based on Vitess which is open source, but you can't self-host an instance of PlanetScale yourself.
The one thing I do like about Yugabyte is that if you do eventually want to go the self-hosted route later, their open source offering includes all features and doesn't lock out features behind an enterprise paywall like CockroachDB does.