Pg_jsonschema – A Postgres extension for JSON validation

Hacker News

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!

Visit product View on Hacker NewsJul 21, 2022

Share card

Actual performance

203points

56comments

Made the leaderboard

Launch Intel predictions

Analyze your own launch →

Hacker NewsStrong engagement from HN community · Strong signals: exist, existing, io · Missing: https docs, excited, just released

50%50% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

TrustMRRLess likely to generate early MRR · Missing: mobile apps, ios, personal

47%47% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Indie HackersIH features products with proven revenue · Missing: supports, reddit linkedin, podcasting

34%34% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive

33%33% predicted probability of success on AppSumo, based on ML models trained on real launch data.

Product HuntUnlikely to reach the leaderboard · Strong signals: code · Missing: mac, agents, macos

32%32% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

16%16% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

3%3% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Snowplow 0.9.5 released with JSON validation and shredding34%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Snowplow 0.9.5 released with JSON validation and shredding

Hacker News3

Pg_CRDT – an experimental CRDT extension for Postgres62%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Pg_CRDT – an experimental CRDT extension for Postgres

Hacker News296

BSON Extension for Postgres44%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

BSON Extension for Postgres

Hacker News115

Pg_stat_ch, a Postgres extension to export every metric to ClickHouse63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Pg_stat_ch, a Postgres extension to export every metric to ClickHouse

Hacker News4

Pg_session_JWT, a Postgres Extension for JWT Sessions42%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Pg_session_JWT, a Postgres Extension for JWT Sessions

Hacker News5

ZomboDB – Postgres extension for indexes backed by Elasticsearch66%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

ZomboDB – Postgres extension for indexes backed by Elasticsearch

Hacker News88

PgModeler – EER Diagramming for postgres73%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

PgModeler – EER Diagramming for postgres

Hacker News9

Merging RethinkDB and Postgres with GraphQL79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Merging RethinkDB and Postgres with GraphQL

Hacker News6

Now supporting MySQL, Postgres, Redis, Mongo60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Now supporting MySQL, Postgres, Redis, Mongo

Hacker News3

GraphQL for Postgres83%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

GraphQL for Postgres

Hacker News195

Browse all products Analyze your launch