Live data from Hacker News

Pg_jsonschema – JSON Schema Support for Postgres

supabase.com

11–20 of 46 posts

Re: Pg_jsonschema – JSON Schema Support for Postgres

#11

This is long overdue and elegantly done. Great work! On a personal note, it's great to finally see Neon & Supabase playing with each other. Much more interesting to me than Hasura.

There’s nothing stopping you from using this with Hasura. Don’t see the relevance.

Re: Pg_jsonschema – JSON Schema Support for Postgres

#12

PG community had a similar patch, which got reverted from PG 15 on the last minute: https://www.depesz.com/2022/04/06/waiting-for-postgresql-15-...

this would be our preference. we'll try to support this for the next commitfest, and if it gets merged then we will deprecate our extension in favour of the native solution.

Re: Pg_jsonschema – JSON Schema Support for Postgres

#13
post #7

Earlier quoted context omitted.

The power of FOSS

Hasura is also FOSS

Hasura is open core. Given the massive price increase they just did for their hosted version, I’d expect more and more future features will not land in core at all, to push people to pay.

Re: Pg_jsonschema – JSON Schema Support for Postgres

#14

PG community had a similar patch, which got reverted from PG 15 on the last minute: https://www.depesz.com/2022/04/06/waiting-for-postgresql-15-...

this would be our preference. we'll try to support this for the next commitfest, and if it gets merged then we will deprecate our extension in favour of the native solution.

Is there a chance it gets committed during the current commitfest? See https://commitfest.postgresql.org/42/4086/

This years feature freeze will be on April 8th (https://www.postgresql.org/message-id/flat/9fbe60ec-fd1b-6ee...), so if it does not get committed within the next two and a half weeks it will miss this years Postgres release in September...

Re: Pg_jsonschema – JSON Schema Support for Postgres

#15
post #14

Earlier quoted context omitted.

this would be our preference. we'll try to support this for the next commitfest, and if it gets merged then we will deprecate our extension in favour of the native solution.

Is there a chance it gets committed during the current commitfest? See https://commitfest.postgresql.org/42/4086/ This years feature freeze will be on April 8th ( https://www.postgresql.org/message-id/flat/9fbe60ec-fd1b-6ee... ), so if it does not get committed within the next two and a half weeks it will miss this years Postgres release in September...

I'll flag it with the team this week. I'm not sure what the blocker was previously, but it might just be a matter of submitting the patch again (with minor changes) so that it's "in" for commitfest, with someone willing to own the work over the next few months.

Re: Pg_jsonschema – JSON Schema Support for Postgres

#17
post #14

Earlier quoted context omitted.

Is there a chance it gets committed during the current commitfest? See https://commitfest.postgresql.org/42/4086/ This years feature freeze will be on April 8th ( https://www.postgresql.org/message-id/flat/9fbe60ec-fd1b-6ee... ), so if it does not get committed within the next two and a half weeks it will miss this years Postgres release in September...

I'll flag it with the team this week. I'm not sure what the blocker was previously, but it might just be a matter of submitting the patch again (with minor changes) so that it's "in" for commitfest, with someone willing to own the work over the next few months.

I think the things that needed to be fixed from last year are already committed (more general stuff not directly related to the JSON patches). Also according to this message at least partial stuff from the JSON patches should be committed "...in the next few days..." however that was two weeks ago: https://www.postgresql.org/message-id/454db29b-7d81-c97a-bc1...

I am a bit worried, even though the patches seem to be "stable", they will miss the deadline... (since I would need those features as well)

Re: Pg_jsonschema – JSON Schema Support for Postgres

#18
post #13

Earlier quoted context omitted.

Hasura is also FOSS

Hasura is open core. Given the massive price increase they just did for their hosted version, I’d expect more and more future features will not land in core at all, to push people to pay.

It’s already quite bad unfortunately. Both support for read replicas and metrics(!) are not in the open source version. They have a prometheus exporter but not on free, afaik.

I was also concerned with people reporting memory consumption/leak issues, as I’m planning to have lots of subscriptions. I don’t know haskell well enough, but from the outside it does match the symptoms of having dug themselves into an architectural complexity hole, which I assume is much harder to navigate with unorthodox tooling and practices.

Im still rooting for hasura, I like their way of making things dumb, simple and without too much technophilia for its own sake. They genuinely want you to focus on your business problems instead of blasting you with novel and overengineered concepts, like others do.

Re: Pg_jsonschema – JSON Schema Support for Postgres

#19
post #16

So how do you apply this in the real world when dealing with schema versions and database migrations?

Add a new constraint that supports the new schema version, migrate json columns to conform to new schema as need be, and then drop old constraint. This assumes your schema is backwards compatible. If it isn't I would probably not use a DB constraint and just handle everything on the application layer.

Re: Pg_jsonschema – JSON Schema Support for Postgres

#20
post #17

Earlier quoted context omitted.

I'll flag it with the team this week. I'm not sure what the blocker was previously, but it might just be a matter of submitting the patch again (with minor changes) so that it's "in" for commitfest, with someone willing to own the work over the next few months.

I think the things that needed to be fixed from last year are already committed (more general stuff not directly related to the JSON patches). Also according to this message at least partial stuff from the JSON patches should be committed "...in the next few days..." however that was two weeks ago: https://www.postgresql.org/message-id/454db29b-7d81-c97a-bc1... I am a bit worried, even though the patches seem to be "…

I don't know any of the people involved in this patch, so I've sent it to Alexander Korotkov to get his opinion. I'll let you know his response after he has a chance to look at it.
Post reply on HN