is_jsonb_valid
pgx_json_schema
is_jsonb_valid | pgx_json_schema | |
---|---|---|
2 | 1 | |
157 | 4 | |
- | - | |
5.9 | 0.0 | |
7 months ago | over 1 year ago | |
C | Rust | |
MIT License | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
is_jsonb_valid
-
Dynamic JSON schema validation, how can I do that in Postgres?
Came across a nice Psql extension btw: https://github.com/furstenheim/is_jsonb_valid
-
Show HN: Pg_jsonschema – A Postgres extension for JSON validation
- 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 can be utilized at the database level and I can't think of a language I want to do it with more than Rust.
[0]: https://github.com/tcdi/pgx
pgx_json_schema
-
Show HN: Pg_jsonschema – A Postgres extension for JSON validation
The `jsonschema` crate author here.
First of all, this is an exciting use case, I didn't even anticipate it when started `jsonschema` (it was my excuse to play with Rust). I am extremely pleased to see such a Postgres extension :)
At the moment it supports Drafts 4, 6, and 7 + partially supports Draft 2019-09 and 2020-12. It would be really cool if we can collaborate on finishing support for these partially supported drafts! What do you think?
If you'll have any bug reports on the validation part, feel free to report them to our issue tracker - https://github.com/Stranger6667/jsonschema-rs/issues.
Re: performance - there are a couple of tricks I've been working on, so if anybody is interested in speeding this up, feel free to join here - https://github.com/Stranger6667/jsonschema-rs/pull/373
P.S. As for the "Prior Art" section, I think that https://github.com/jefbarn/pgx_json_schema should be mentioned there, as it is also based on `pgx` and `jsonschema`.
What are some alternatives?
pg_jsonschema - PostgreSQL extension providing JSON Schema validation
postgres-json-schema - JSON Schema validation for PostgreSQL
pgx - Build Postgres Extensions with Rust! [Moved to: https://github.com/tcdi/pgrx]
windmill - Open-source developer platform to turn scripts into workflows and UIs. Fastest workflow engine (5x vs Airflow). Open-source alternative to Airplane and Retool.
jsonschema - JSON Schema validation library