Show HN: Pg_jsonschema – A Postgres extension for JSON validation

• pg_jsonschema

  13 772 6.4 Rust

  PostgreSQL extension providing JSON Schema validation

  

  author here:

  pg_jsonschema is a solution we're exploring to allow enforcing more structure on json and jsonb typed postgres columns.

  We initially wrote the extension as an excuse to play with pgx, the rust framework for writing postgres extensions. That let us lean on existing rust libs for validation (jsonschema), so the extension's implementation is only 10 lines of code :)

  https://github.com/supabase/pg_jsonschema/blob/fb7ab09bf6050...

  happy to answer any questions!

• postgres-json-schema

  2 436 0.0 PLpgSQL

  JSON Schema validation for PostgreSQL

  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)

• SonarQube

  www.sonarqube.org

  sponsored

  Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  

• is_jsonb_valid

  2 145 0.0 C

  Native PostgreSQL extension to validate jsonb

  - 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

  10 2,376 9.6 Rust

  Build Postgres Extensions with Rust! [Moved to: https://github.com/tcdi/pgrx] (by tcdi)

  

  - 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

• windmill

  56 4,959 0.0 JavaScript

  Open-source developer platform to turn scripts into workflows and UIs. Open-source alternative to Airplane and Retool.

  

  This is absolutely brilliant.

  In windmill, https://github.com/windmill-labs/windmill (self-hostable AWS Lambda, OSS AGPLv3) we infer the jsonschema of your script by doing static analysis but so far we were not doing validation of the payload itself, if your script failed because of incorrect payload that was your problem. Now without any additional effort I will be able to add validation and great error reporting "for free".

• jsonschema

  3 366 2.2 Rust

  JSON Schema validation library

  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`.

• pgx_json_schema

  1 3 10.0 Rust

  JSON Schema validation for Postgres

  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`.

• InfluxDB

  www.influxdata.com

  sponsored

  Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  

Suggest a related project