NoSQL vs SQL, which one are you using and why

Having worked with both kinds of databases, I would say I will use Postgres any time of the day.

Though it is easy to start with NoSQL databases like MongoDB, and elastic search they need an expert level understanding to configure them correctly for the production environment. We have spent an enormous amount of time just going through the docs of both of them. Managing them is a huge pain.

However, managing the Postgres database has been a breeze, the only thing I haven't enjoyed in Postgres is writing migrations when altering schema. Tools like Prisma are great to help you deal with it. It generates the SQL query that you can inspect and manage efficiently.

For me it comes down to familiarity. Shipping quickly and learning fast is one of the most important tenants to focus on to prevent building the wrong thing.

If you start to see traction after shipping, then you may want to consider whether your tech decision will be an issue down the road.

I lean towards SQL from a pure familiarity standpoint, since I can build substantially faster with it than learning new techs I'm not as familiar with.