Question:
I’m building a cross-platform mobile application (Android + iOS) along with a web backend for managing the system. I need advice on choosing the best database solution in terms of performance, scalability, and monthly cost.
The project will eventually support around 10,000 users, with real-time updates for bookings and user accounts.
The app allows users to browse nearby sports fields, check availability, and book playgrounds in real time through a mobile app and web dashboard.
I’m considering several options:
Supabase (PostgreSQL + Auth + Storage)
Firebase
Traditional backend using Node.js + MySQL on a VPS
Any other recommended setup
Which database (and architecture) would you recommend for this kind of app, especially when cost efficiency and long-term scalability are important?
Would appreciate insights from developers who have handled similar projects.