Live data from Hacker News

Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

github.com

21–26 of 26 posts

Re: Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

#21

Earlier quoted context omitted.

Where I can see this being really useful is for people trying out GraphQL for the first time. If you already know PostgreSQL, throwing this interface over it means the GraphQL bit is the only thing you've got to learn.

Agreed. My impression is that using this in a real project is almost a non-starter, but it's a good way for trying out GraphQL.

What? Why would it be a "non-starter"? It is made for being used for real, and people use it for real.

Re: Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

#22

Earlier quoted context omitted.

Agreed. My impression is that using this in a real project is almost a non-starter, but it's a good way for trying out GraphQL.

What? Why would it be a "non-starter"? It is made for being used for real, and people use it for real.

It's just that many people want to be able to use the software by doing modifications to it for their secret sauce. And they don't want to share the sauce. AGPL forces you to share it, even if you don't distribute the software: as long as you make a service with your modified version, you are legally entitled to share the modifications.

Of course, it's almost impossible to prove IRL, but still, a lot of corporations have problems with that. They want the free open source project to make them earn money, no price to pay.

Re: Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

#23

Earlier quoted context omitted.

What? Why would it be a "non-starter"? It is made for being used for real, and people use it for real.

It's just that many people want to be able to use the software by doing modifications to it for their secret sauce. And they don't want to share the sauce. AGPL forces you to share it, even if you don't distribute the software: as long as you make a service with your modified version, you are legally entitled to share the modifications. Of course, it's almost impossible to prove IRL, but still, a lot of corporations…

[deleted]

Re: Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

#24

Earlier quoted context omitted.

What? Why would it be a "non-starter"? It is made for being used for real, and people use it for real.

It's just that many people want to be able to use the software by doing modifications to it for their secret sauce. And they don't want to share the sauce. AGPL forces you to share it, even if you don't distribute the software: as long as you make a service with your modified version, you are legally entitled to share the modifications. Of course, it's almost impossible to prove IRL, but still, a lot of corporations…

Did you reply to the wrong post? It isn't AGPL, and corporations have nothing to do with what I said.

Re: Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

#25
post #8

This looks amazing. I can't wait to dig into the internals and play around. I've been thinking about a "Postgres-first" application design for some time, where a thin GraqhQL/REST layer sits on top, and most of the business logic lives in Postgres directly, or operates as a triggered async function (eg; AWS Lambda).

You might want to look at the serverless project.

You can setup a cloudfront distribution postgres rds.

Use Postgraphql/postgrest as stateless api layer. I would use a docker container and ECS to keep it horizontally scalable.

Then just whip together a client app that consumes your api.

https://github.com/serverless/serverless

Re: Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

#26

Earlier quoted context omitted.

Agreed. My impression is that using this in a real project is almost a non-starter, but it's a good way for trying out GraphQL.

What? Why would it be a "non-starter"? It is made for being used for real, and people use it for real.

Because there are many benefits to using GraphQL that aren't supported if you explicitly tie the schema to the data source - one of them being the relative ease of supporting out-of-date clients. Another being the ease of supporting multiple data sources in the same schema, like Elasticsearch, Redis, etc (though I guess you can have PostgreSQL talk to those data sources instead).

My use of "real project" was perhaps a little unfair. What I mean is that as soon as you go beyond the simplest requirements of a GraphQL server, a solution like this is going to present more problems than it solves.

Post reply on HN