Seeking advice: Best database for scaling a travel/social app before App Store launch?
Hey everyone,
I’m currently in the final stages of building out my app (a travel-focused brand called Letters To Somewhere) and I’ve realized my current database setup might not be the most sustainable once I actually go live on the App Store.
The Context: The app features travel planning tools, social writing features, and potentially a sensory journal component. Right now, I’m using a no-code/low-code backend (Base44), but I’m looking to migrate to something more robust and industry-standard that can handle growth without breaking the bank or my UI.
What I need to handle:
- Social Features: User profiles, following, and content sharing.
- Media: Storing and retrieving photos/travel content efficiently.
- Authentication: I’m already using Google Sign-In/OAuth.
- Scalability: I want to move now so I don't have to do a massive migration mid-growth.
The Ask:
- For those who have migrated from a "starter" database to a production-grade one (like PostgreSQL, Supabase, or Firebase), what was your biggest "I wish I knew this before" moment?
- Since I’m essentially a solo founder, should I lean toward a BaaS (Backend-as-a-Service) like Supabase for the ease of use, or go straight to a managed SQL database?
- Any specific tips for mapping data during the migration to ensure I don’t lose the work I've already done on the front end?
I'm currently based in Canada and trying to keep the tech stack manageable while I focus on the product side. Would love any insights or "lessons learned" from your own migrations!
Thanks in advance!