Supabase or MongoDB
Hi everyone! đź‘‹ I'm building a B2B2C SaaS platform that involves:
Securely storing and verifying user contacts.
Managing relationships between users (e.g., family members, admins).
Sending notifications based on user-defined preferences.
Supporting two different types of logins: one for businesses (B2B) and another for individual users (B2C).
Currently, I'm using MongoDB Atlas for the database, but I'm considering whether Supabase might be a better fit.
Would Supabase's relational database and integrated features (like auth and real-time) be a good choice for this use case? Or should I stick with MongoDB for flexibility with document-based data?
I'd really appreciate your advice—thanks in advance! 🙏
2 Replies
You don't mention anything that is really json document oriented. A relational database is better at relationships and contact type info.
Doing different user type logins is a weakness for Supabase Auth, but users have worked around it. I don't know what Atlas does for User auth in that regard.
I was a Mongo user myself, and I would say go with Supabase, as Gary mentions, any of your requests is JSON/unstructured data, and if you happen to need that, you still have JSON columns on Postgres. Plus you will get many more features under the same umbrella fully integrated (Auth, Storage, Local dev, Queues, Cron, many others).
If you have experience with SQL and relational DBs is a no brainer, if not experience, tbh AI assistants will help you a lot in migrating your Documents Schemas to a Relational Tables Schemas.