Hey everyone! We've been using Google Sheets as our backend database for a prototype, and it has been great for quick setup and manual data entry, plus it has some solid analysis tools. However, we're starting to hit a performance wall with around 4-5K rows in our biggest sheet, and things are getting really sluggish. I'm looking for alternatives that can still offer easy access and good analysis capabilities but with better performance. I'm not keen on spending ages on database management tools when I could be focusing on developing other features. Any suggestions on what we should consider?
2 Answers
Using something like Supabase could be a great move. It provides a GUI for managing your Postgres database, making it super easy to modify entries without too much hassle. Plus, you get the performance boost you need!
The performance issues you’re facing are typical. If you think about switching, even a basic DB setup will outperform Sheets by lightyears. SQL databases still allow for manual tweaks, and learning a bit of SQL for sorting and filtering is worth it!
Spot on! Just think of how much easier your life will be without those slow sheet hiccups.