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.
