I’ve been using Firebase, Turso, Supabase, and MongoDB, they’ve worked fine for my small projects. But when it comes to medium or larger projects, I’m not really sure what the best option would be.
From your experience, what would you recommend? Something that scales well, has reasonable limits, and won’t get too expensive down the line.
What do you mean by scale? I think that's important to understand for both you and me to help you.
Are you expecting millions of unique users per hour? More reads than writes? Do you have tons of data? Are you doing data analysis? Are you global?
Otherwise, stick to supabase and then dump to managed digital ocean instances or something like that and click the auto-scale button to increase resources if/when it makes sense.
PostgreSQL: The World's Most Advanced Open Source Relational Database. PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database
https://planetscale.com/ would be a good bet.
Coolify Postgres on Hetzner if you want cheap
- [deleted]