Show HN: Pg_jsonschema – A Postgres extension for JSON validation

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • pg_jsonschema

    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!

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • postgres-json-schema

    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)

  • is_jsonb_valid

    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

    Discontinued 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

    Open-source developer platform to turn scripts into workflows and UIs. Fastest workflow engine (5x vs Airflow). 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

    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

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

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • web service framework and OpenAPI spec

    2 projects | /r/rust | 24 Mar 2023
  • Need help: Faster JSON Schema validation in Rust

    1 project | /r/rust | 14 Jun 2022
  • Fast Linked Lists

    4 projects | news.ycombinator.com | 14 May 2024
  • How Authentication and Authorization Work for SPAs

    4 projects | dev.to | 13 Apr 2023
  • Most complex hello world program

    2 projects | /r/ProgrammerHumor | 21 Jan 2023