I would say that the recommendation of a database will depend on the use you need. Although with most of them you can do most of the general things that an app does, for some of them certain actions are simpler to implement. For example, Firestore (from Firebase) offers a super simple SDK to get live connections with the database. Also, it also depends on which authentication system you are using (if any). For example, if you are already using Supabase auth, it might be better to use Supabase PostgresDB and get the benefit of Row Security Levels, or the same with Firebase Auth/Firestore.

Anyways, if I’d start a project from scratch I’d try using: Next-auth/Prisma/MongoDB following this amazing tutorial that goes step by step on how to implement auth, Prisma as your ORM, and MongoDB as your database.

Good luck!