4 ms·
Even as a JSON document store I'd rather use postgres with a jsonb column.
by chpatrick 2y ago
Even as a JSON document store I'd rather use postgres with a jsonb column.
- tiltowait 2y agoWhy is that? I found Postgres's JSONB a pill to work with beyond trivial SELECTs, and even those were less ergonomic than Mongo.
- chpatrick 2y agoBecause you get the convenience of having a document store with a schema defined outside of the DB if you want it, along with the strong guarantees and semantics of SQL.
- chpatrick 2y agoFor example: let's say you had a CRM. You want to use foreign keys, transactions, all the classic SQL stuff to manage who can edit a post, when it was made, and other important metadata. But the hierarchical stuff representing the actual post is stored in JSON and interpreted by the backend.