wait so why do people prefer sql databases over noSQL db's

nosql databases are great when you know your exact use-case and the trade-offs you're choosing. relational dbs like postgresql are, imo, better suited when the structure is unknown or will change, or when bottlenecks have not been identified that NEED nosql. Nosql trades away some features for some benefit from SQL. Sometimes its worth it. Most of the time it isn't worth what's being traded away.

To be honest, nosql is great for materialized views, other than that, i will always go with sql

Thanks guys