I'm developing a cross-platform mobile app that will run on both Android and iOS, paired with a web backend to manage the system. I'm looking for recommendations on the best database solution considering performance, scalability, and monthly costs. The application is expected to support about 10,000 users, focusing on real-time updates for bookings and user accounts. I'm weighing several options, including Supabase (PostgreSQL + Auth + Storage), Firebase, and a traditional setup with Node.js and MySQL hosted on a VPS. What would you suggest as the most cost-effective and scalable database architecture for my project? I'm specifically looking for insights from developers who have experience with similar setups.
1 Answer
Honestly, starting with a service like Supabase makes a lot of sense for your situation. Given you're currently at zero users, it’s wise to focus on an easy solution until you actually have to scale up. Supabase will handle much of the infrastructure for you, which is crucial when you're tight on resources. You can deal with more complex setups once you hit significant user numbers.
Totally agree! Supabase is built for developers who need rapid solutions. You can always switch to a more hands-on server solution later.