Pg_jsonschema
Data
postgres extension
SHOW HN2022
How HN took it
6 positive, 17 neutral or asking, 0 mixed, 1 critical, out of 24 comments about the project. Thread score +0.20.
Idea: 4 for, 0 againstExecution: 2 for, 0 againstPerformance: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Brings schema validation to the database level via CHECK constraints
From 2 comments
All this does is make writing a CHECK constraint for a JSON blob relatively straightforward. And yes you should use CHECKs in the database. In practice, it is very easy for…
billythemaniam on HNThis is awesome! I remember playing with Hasura (which uses Postgres) a few years ago. Hasura is great but one of the things I really wanted was JSON schema validation at a…
tsujp on HN
Excited about pgx and Supabase's open source commitment
From 2 comments
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: -…
hardwaresofton on HNI just love the work both Supabase & Hasura have done making people aware of how powerful Postgres is.
cpursley on HN
Objections
Validation on a centralized RDBMS hurts scalability and ties up connections
From 2 comments
Nice work, however, I am structurally dubious of putting too much functionality onto a classical centralized RDBMS since it can't be scaled out if performance becomes a problem.…
paulmd on HNScaling isn't really a concern for everybody and every application. It's good to be aware of additional strain you put on your DB, but I've worked with lots of applications where…
perlgeek on HN
Requests
Support for full JSON Schema drafts 2019-09 and 2020-12
From 1 comment
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…
dmitry_dygalo on HN
Dockerfile, PG15 compatibility info, and CI/CD
From 1 comment
Thank you! Some suggestion for the next roadmap: - a Dockerfile ( The dockerfile helps me a lot in trying out new technologies ) - info about the compatibility with new PG15 -…
pella on HN
Questions
Which JSON Schema drafts are supported and whether $schema is honored
From 1 comment
It would be valuable to know which JSON-Schema it supports, since there are currently 4 different versions that differ in their capabilities (as one might expect). Related to…
mdaniel on HN
Whether adding the constraint to a large table scans existing rows
From 1 comment
If adding this check to an existing table with millions of records, will it scan the entire table checking all of the records, or just check when the records are inserted or…
warmwaffles on HN
Alternatives named
postgres-json-schema (gavinwahl)
From 1 comment
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: -…
hardwaresofton on HN
is_jsonb_valid
From 1 comment
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: -…
hardwaresofton on HN
pgx_json_schema (jefbarn)
From 1 comment
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…
dmitry_dygalo on HN