3 ms·
> Postgres admittedly cheated a bit at first with the basic JSON support, validation of JSON but then storing it in a text field didn't quite make it a full doc
by anarazel 6y ago
> Postgres admittedly cheated a bit at first with the basic JSON support, validation of JSON but then storing it in a text field didn't quite make it a full document database.
Did anybody claim it was back then?
> Being a compressed format
I'd argue its a structured format, rather than a compressed format. I.e. it allows traversal without (re-)parsing the json from text. But most of the time the jsonb version won't be (meaningfully) smaller.
- craigkerstiens 6y agoHi Andres... I think I did back then ;) Though to be fair, yes the PostgreSQL has never officially said it's a full document database to my knowledge.