Hacker GitHub

← All repos

gavinwahl/postgres-json-schema

View on GitHub ↗ ★ 508 PLpgSQL

JSON Schema validation for PostgreSQL

3 mentions on Hacker News by 3 people: 0 stories, 3 comments · first 2022-07-21 · latest 2024-07-08

Mentions per year 3 mentions · busiest year 2022 (1)
20082026
AllStoriesComments NewestTopOldest
  1. …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:…
    comment by evanelias · 2024-07-08 · in Mongo but on Postgres and with strong consistency benefits
  2. I've found that this PL/pgSQL implementation also works well when you don't need maximum performance: https://github.com/gavinwahl/postgres-json-schema
    comment by julian37 · 2023-03-22 · in Pg_jsonschema – JSON Schema Support for Postgres
  3. …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) - https://github.com/furstenheim/is_jsonb_valid pgx[0] is going to be…
    comment by hardwaresofton · 2022-07-21 · in Show HN: Pg_jsonschema – A Postgres extension for JSON validation