News for hackers. Stuff that matters.

A comment on When to Avoid JSONB in a PostgreSQL Schema. Parent comment

Re:When to Avoid JSONB in a PostgreSQL Schema by azinman2 on Friday September 02, 2016 @03:24AM (#12411476)
You think database schemes are somehow immune to evolve haphazardly over time?

I've seen otherwise...

[ Parent | on HN ]
Re:When to Avoid JSONB in a PostgreSQL Schema by nbraud on Friday September 02, 2016 @09:45AM (#12412982)
The point is not that the DB schema will evolve sanely, nothing can guarantee that (nor with JSON).

The point is that the schema is explicit: worst case, I can go look it up, and I /know/ that the data conforms to it.

[ Parent | on HN ]
Re:When to Avoid JSONB in a PostgreSQL Schema by andybak on Friday September 02, 2016 @04:33AM (#12411729)
No one is arguing it's not impossible but it's certainly harder to mess up a schema than a document db or JSON field.
[ Parent | on HN ]