Hacker News new | ask | show | jobs
by javajosh 3847 days ago
The JSON datatype is only useful if you want to query on the blob, which is not the case in Wix's case.
3 comments

But you tell to keep columns that need indexs outside of the JSON so you can query on them, which is not necessary with Postgres
It also provides validation and is often more space efficient :) the internal format also technically supports partial update, but that is not yet a supported feature. So I wouldn't suggest using text if you are not querying.
You can query on individual fields with the jsonb type