3 ms·
> Arguably psql does offer a NoSQL-like experience with JSON columns. I hope not. JSON columns purge all the good things a relational database offers and keeps
by roenxi 4y ago
> Arguably psql does offer a NoSQL-like experience with JSON columns.
I hope not. JSON columns purge all the good things a relational database offers and keeps the SQL. It is the worst of every option.
That really should be the opposite of the NoSQL experience. Disbarred by the fact that SQL is involved.
- zztop44 4y agoJSON columns are very useful in some circumstances but you shouldn’t use them as a replacement for a database schema, and if I’m honest I’m yet to see anyone truly suggest that.
- sudhirj 4y agoI use schema for everything relational, and put everything else (all the nice-to-know data) in JSONB. Works really well. Stacks like Rails lean into this with `store_accessor` which lets you designate a JSON column as storage for arbitrary data that looks and feels like a separate column.
- emodendroket 4y agoI guess it depends what part of NoSQL you’re looking for, but if you want a bit of schemaless data it makes sense.