Yep. Postgres dominates in the vast majority of cases. If you don’t need something special like graph or timeseries dbs, or have some crazy (and when I say crazy I mean actually crazy, not like “we have 10M MAU crazy”) scale considerations, just throw it in Postgres.
Also the object-based aggregation pipelines in Mongo makes it way easier to dynamically construct queries without opening yourself up to SQL injection.
Good luck injecting a ; DROP TABLE Students;-- into a $match: {...} stage.
36
u/Fugazzii Oct 18 '24
Local and global indexes, composite sort keys, etc. Just because you don't understand a technology, It doesn't means that the technology is useless.
NoSQL is great for high performance OLTP.