4 ms·
The JSON datatype is only useful if you want to query on the blob, which is not the case in Wix's case.
by javajosh 11y ago
The JSON datatype is only useful if you want to query on the blob, which is not the case in Wix's case.
- orf 11y agoYou can query on individual fields with the jsonb type
- staz 11y agoBut you tell to keep columns that need indexs outside of the JSON so you can query on them, which is not necessary with Postgres
- morgo 11y agoIt 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.