sqlite-jsonschema

Exactly so. SQLite also has a rich collection of CHECK constraints which can raise errors if data is not to your liking in some fashion, this includes validating JSON. Not a JSON schema, admittedly, although (just like for Postgres) this is available as an extension. https://github.com/asg017/sqlite-jsonschema Saying that SQLite doesn't have "real types" is simply false. If one doesn't want to learn how to use a tool, blaming it for that failure is poor form.

This is such a huge step forward for the usability of custom SQLite extensions in Python world. Alex has a whole family of SQLite extensions that he's built in Rust which are worth checking out: - sqlite-xsv: https://github.com/asg017/sqlite-xsv - sqlite-fastrand: https://github.com/asg017/sqlite-fastrand - sqlite-ulid: https://github.com/asg017/sqlite-ulid - sqlite-jsonschema: https://github.com/asg017/sqlite-jsonschema - sqlite-regex: https://github.com/asg017/sqlite-regex - sqlite-url: https://github.com/asg017/sqlite-url - sqlite-http: https://github.com/asg017/sqlite-http - sqlite-lines: https://github.com/asg017/sqlite-lines - sqlite-path: https://github.com/asg017/sqlite-path - sqlite-html: https://github.com/asg017/sqlite-html