Postgre is still better than MongoDB so I am okay with this.
Every. Every single project. Who could have predicted our data would become relational?
100% accurate.
As somebody reducing mongodb at work: postgres first would have saved so much trouble!
You might have be doing something wrong then. MongoDB handles relationships just fine, just because your data has relations doesn’t mean that it needs to be stored in tables. In fact, a graph database does relationships even better, but we don’t use neo4j for all our apps, do we?
deleted by creator
I used Mongo and Postgres at my last job, then Postgres and various queues/nonrels for different services at the current one. I really, REALLY like the queryable JSON column type in Postgres. Not as in I use it for everything, but where it is actually called for, it’s extremely useful.
I use Redshift right now and I would LOVE to have something nice and flexible like that. Come to think of it, some halfway reliable documentation would be nice too.
Would you rather Mongo or Excel over Postgres?
Fuck you for making me think about that
I mean, you could do it using foreign data wrappers.
EDIT: It has been done before https://www.cdata.com/kb/tech/excel-jdbc-postgresql-fdw-mysql.rst
