postgres-json-schema

I'd assume this might be solvable in the DB layer using CHECK constraints, possibly combined with JSON Schema validation? From quick glance, JSON Schema validation isn't built-in to Postgres, but there are third-party extensions, such as https://github.com/supabase/pg_jsonschema or https://github.com/gavinwahl/postgres-json-schema. I'm more familiar with MySQL and MariaDB, which offer it built-in: https://dev.mysql.com/doc/refman/8.0/en/json-validation-func... and https://mariadb.com/kb/en/json_schema_valid/

I've found that this PL/pgSQL implementation also works well when you don't need maximum performance: https://github.com/gavinwahl/postgres-json-schema

This is awesome -- really excited that Supabase is picking this up with their commitment to open source in general and PG in particular. Some prior art: - https://github.com/gavinwahl/postgres-json-schema (mentioned in the repo) - https://github.com/furstenheim/is_jsonb_valid pgx[0] is going to be pretty revolutionary for the postgres ecosystem I think -- there is so much functionality that would benefit from happening inside the database and I can't think of a language I want to use at the DB level more than Rust. [0]: https://github.com/tcdi/pgx