Pg_jsonschema Alternatives

pg_jsonschema reviews and mentions

• Mongo but on Postgres and with strong consistency benefits
  9 projects | news.ycombinator.com | 7 Jul 2024

  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/

• Introducing pgzx: create PostgreSQL extensions using Zig
  3 projects | news.ycombinator.com | 21 Mar 2024

  And lots of interesting extensions use it, like

  https://github.com/tembo-io/pgmq

  https://github.com/zombodb/zombodb

  https://github.com/supabase/pg_jsonschema

• Beyond SQL: A relational database for modern applications
  4 projects | news.ycombinator.com | 22 Aug 2023

  > In other words, there is still a (lossy) translation layer, it just happens to be in the RDBMS rather than in-app.

  It's not lossy if your application can guarantee a json <-> datatype roundtrip and the json is validated with jsonschema (generated by your application)

  In Rust it's something like this

  https://serde.rs/ to do the data type <-> json mapping

  https://docs.rs/schemars/latest/schemars/ to generate jsonschema from your types

  https://github.com/supabase/pg_jsonschema to validate jsonschema in your database (postgres). with this setup it's interesting (but not required) to also use https://docs.rs/jsonschema/latest/jsonschema/ to validate the schema in your application

• FerretDB, a truly open-source MongoDB alternative
  5 projects | news.ycombinator.com | 12 Apr 2023

  Pretty exciting!

  What about optionally validating some columns with jsonschema? Perhaps using https://github.com/supabase/pg_jsonschema - is using other postgres extensions supported in FerretDB? (if not, maybe it's feasible to incorporate the code of pg_jsonschema in FerretDB?)

• Type Constraints in 65 lines of SQL
  5 projects | news.ycombinator.com | 17 Feb 2023
• Ask HN: Do you use JSON Schema? Help us shape its future stability guarantees
  15 projects | news.ycombinator.com | 30 Jan 2023

  I'm not currently using it, but I'm strongly considering validating json in postgres with https://github.com/supabase/pg_jsonschema - which uses the https://docs.rs/jsonschema/latest/jsonschema/ Rust crate

  So I'm not sure if my feedback is valid but, I sure hope that the jsonschema crate follows the spec! Otherwise I'll never use jsonschema but instead something-not-exactly-jsonschema. In other words.. you better not break anything.

• Features I'd Like in PostgreSQL
  14 projects | news.ycombinator.com | 28 Jan 2023

  Sounds dumb, but I want JSON field schema validation. I added a JSON column for flexible data, and although I'm happy with its flexibility, I kinda hope I can validate the JSON data structure. Recently I just found an extension [1] and will try soon.

  [1] https://github.com/supabase/pg_jsonschema

• Dynamic JSON schema validation, how can I do that in Postgres?
  2 projects | /r/PostgreSQL | 30 Aug 2022

  https://github.com/supabase/pg_jsonschema is new and looks good

• Supabase Beta July 2022
  2 projects | dev.to | 4 Aug 2022

  Born as an excuse to play with pgx, pg_jsonschema is a solution we're exploring to allow enforcing more structure on json and jsonb typed postgres columns. Only 10 lines of code 😎

• GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation
  2 projects | /r/PostgreSQL | 23 Jul 2022
• A note from our sponsor - InfluxDB
  influxdata.com | 27 Apr 2025

  Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems. Learn more →