Hacker GitHub

← All repos

supabase/pg_jsonschema

View on GitHub ↗ ★ 1,207 Rust

PostgreSQL extension providing JSON Schema validation

11 mentions on Hacker News by 5 people: 1 story, 10 comments · first 2022-07-21 · latest 2024-08-11

Mentions per year 11 mentions · busiest year 2023 (7)
20082026
AllStoriesComments NewestTopOldest
  1. …Full disclosure: I'm a Rust Engieer at Supabase. [0] https://github.com/supabase/pg_graphql [1] https://github.com/supabase/pg_jsonschema [2] https://github.com/supabase/wrappers
    comment by imor80 · 2024-08-11 · in Show HN: Pg_replicate – Build Postgres replication applications in Rust
  2. …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,…
    comment by evanelias · 2024-07-08 · in Mongo but on Postgres and with strong consistency benefits
  3. …extensions use it, like https://github.com/tembo-io/pgmq https://github.com/zombodb/zombodb https://github.com/supabase/pg_jsonschema
    comment by nextaccountic · 2024-03-21 · in Introducing pgzx: create PostgreSQL extensions using Zig
  4. …<-> 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…
    comment by nextaccountic · 2023-08-23 · in Beyond SQL: A relational database for modern applications
  5. 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…
    comment by nextaccountic · 2023-04-15 · in FerretDB: open-source MongoDB alternative
  6. …jsonb frequently, check out pg_jsonschema[1] as a way to express the constraints more concisely [1] https://github.com/supabase/pg_jsonschema
    comment by oliverrice · 2023-02-18 · in Type constraints in 65 lines of SQL
  7. …Right now I think the ideal is a jsonb column (with a field that stores the tag) plus https://github.com/supabase/pg_jsonschema . But this is only usable if your language translates to/from JSON and generates json schema for you. Rust can…
    comment by nextaccountic · 2023-02-17 · in Type constraints in 65 lines of SQL
  8. …[2] https://github.com/supabase/pg_graphql/blob/34cc266da972d356... [3] https://github.com/supabase/pg_jsonschema
    comment by oliverrice · 2023-02-17 · in Type constraints in 65 lines of SQL
  9. 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…
    comment by nextaccountic · 2023-01-31 · in Ask HN: Do you use JSON Schema? Help us shape its future stability guarantees
  10. …can validate the JSON data structure. Recently I just found an extension [1] and will try soon. [1] https://github.com/supabase/pg_jsonschema
    comment by hamasho · 2023-01-29 · in Features I'd Like in PostgreSQL