Hacker News new | ask | show | jobs
by chpatrick 484 days ago
Even as a JSON document store I'd rather use postgres with a jsonb column.
1 comments
tiltowait 484 days ago
Why is that? I found Postgres's JSONB a pill to work with beyond trivial SELECTs, and even those were less ergonomic than Mongo.
link
chpatrick 484 days ago
Because 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.
link
chpatrick 483 days ago
For 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.
link