Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



Sure but combined with plv8 you trivially can have indexes on the json




Consider applying for YC's Fall 2026 batch! Applications are open till July 27.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: