Why I Had to Migrate from MongoDB to PostgreSQL

Yep, ever other time I post on here I suggest folks avoid nosql. If you really need unstructured data, just use the Postgres jsonb type - it's even better at JSON documents than Mongo claims to be.

This leaves you with enough flexibility to outgrow the unstructured approach. And using Postgres with Hasura or Supabase makes relational databases really easy to approach for people more comfortable on the front end.

https://hasura.io/blog/postgres-json-and-jsonb-type-support-on-graphql-41f586e47536/

I wrote a while ago on the NoSQL craze and why most projects should use SQL as the main database and NoSQL as complementary storages for very specific tasks. I especially dislike document databases because nowadays, relational databases can work with JSON documents as well without losing the benefits of SQL (joins, foreign keys, constraints, etc). MongoDB still exists because it's easier to integrate natively with javascript projects for beginners, but that's it. For real-case workloads, SQL will work better in 100% of the cases.

https://vladcalin.ro/blog/2021-06-26-whats-the-deal-with-nosql

Yeah I 100% use Mongo like a relational db and I'm not proud of it. But I like Mongo only because of Atlas. I can spool up a database at the click of a button, and then easily browse the data from the website, plus it's free for most things I use it for. I haven't found anything as simple for Postgres.

Hey thats a great blog post so insightful