3 ms·
The JSON data type is nothing more than a self validating varchar field i.e. fairly pointless. Better off just validating the JSON yourself in the application
by taligent 14y ago
The JSON data type is nothing more than a self validating varchar field i.e. fairly pointless.
Better off just validating the JSON yourself in the application layer and maintaining cross database compatibility. To be honest it is rare that you would even need to explicitly validate as when you deserialize into objects it will just fail at that point.
- willlll 14y agoSure but combined with plv8 you trivially can have indexes on the json
- deleted 14y ago[deleted]