In other words, PostgreSQL vs. MongoDB

When I was working on Finish-Line I initially set up a Postgresql database using Supabase and Prisma. PostgreSQL is one of the most common relational database systems used and is pretty industry standard, definitely worth learning.

Using a relational database for this project made enough sense, I would be linking users to races, each user would hold tasks that could also be linked to the race objects- you see the vision.

I started to get fed up with setting up the tables, schemas, row security policies, etc. though so I switched to MongoDB lol. Mongo is a noSQL document based system, data is stored in a JSON format so you don’t have to go through as much trouble in my opinion, and it was easier to pick up for a dummy like me.