Y
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
staz
3847 days ago
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
link
morgo
3847 days ago
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.
link
orf
3847 days ago
You can query on individual fields with the jsonb type
link