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!
5 Answers
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!
Are you looking specifically for a BaaS or a relational database management system? There’s a huge difference between the two!
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.
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!
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!
But is that what you really think a BaaS is?
Is SQLite really considered a BaaS though? Just curious!