HACKER Q&A
📣 4nof

What's a good current distributed DB I can use on AWS EC2?


I'm trying to get a database together for a general database for an app I'm writing. - I'm going for low-cost prioritized over easy setup. - I looked into making a sqlite db for each user stored in s3, but that is generally only readonly unless I want to pickup and drop on s3 every read/write, then there's write collisions, in which I would need a queue for transaction to place on the db in sequence. Doable, but more complex than I was hoping. - I could vertically scale a PostgresDB with 200GB , place on a t2.medium instance, and just be done with it there, but sooner or later I will need to scale again, It would be nice to have it as an easy scale. - I've considered CockroachDB and Yugabyte. Yugabyte Terraform has issues I can't solve - something about an ami resource not found, and support has issues open and unhandled from March 2023 on Github, so I'm leaning toward CockroachDB , but licensing is sorta confusing - I want to use this for a customer facing app: https://www.cockroachlabs.com/docs/stable/licensing-faqs I think that CCL should cover it? I guess I can ask on their support.

I saw FoundationsDB , but I haven't really looked at it, how good is it? https://tech.marksblogg.com/minimalist-guide-tutorial-foundationdb.html

Are there any other distributed DB solutions I can look at that can run on EC2 on AWS? Any suggestions or comments would be appreciated. Thanks.


  👤 cebert Accepted Answer ✓
Is there a reason you don’t want a managed service? If DynamoDB can meet your access patterns it’s always my first option to consider since it’s so inexpensive.

👤 marcobambini
Take a look at https://sqlitecloud.io (BTW I am the founder).