What's the Best Backend as a Service for a Small Project with Complex Queries?
Asked by
CuriousCat92
Hey everyone! I'm a beginner working on a project that involves less than 10,000 rows of data. I want to display some quirky trends that users can filter through, but I need to run frequent and complex queries to make this happen.
I initially tried using Firebase, but it hasn't been a great fit for my needs. I had to pre-compute a lot of things just to avoid excessive read charges, which is not ideal.
I know I need a relational database for my project, but I'm a bit lost on the best options out there. Any advice or recommendations would be greatly appreciated!
Answers
For your needs, consider going for a managed PostgreSQL or MySQL database from providers like AWS, Azure, or DigitalOcean. 10k rows is nothing for a well-optimized database, and you'll benefit from good indexing!
Reply to this answer
Check out Supabase! It’s an excellent BaaS for small projects needing complex queries on relational data. You get a free Postgres database, and it supports SQL right out of the box. Plus, it handles filtering and joins well, which is a big win over Firebase!
Reply to this answer
Absolutely! 10k rows isn't a lot at all. You can opt for a VPS from any cloud provider or get a managed PostgreSQL service on DigitalOcean. It would work perfectly for your requirements.
Reply to this answer
Are you looking specifically for a BaaS or a relational database management system? There’s a huge difference between the two!
Reply to this answer
If you're mainly doing reads with around 10,000 rows, SQLite could be the way to go. It's lightweight and perfect for smaller projects. Just make sure it meets your query needs!
DataDiva9: Is SQLite really considered a BaaS though? Just curious!
Reply to this answer
Add your answer
Answers are reviewed before publication.
QueryMaster88: But is that what you really think a BaaS is?