GraphQL and PostgreSQL as a managed back end? | Hacker News Reader

GraphQL and PostgreSQL as a managed back end?

14 pointsniolap11 comments

Graphql is amazing but can be complicated to setup. Postgraphile, give you a Graphql server ready to go but still complicated to understand and maintain. What if you could just have a managed backend backed by Postgraphile and Postgresql that allows you to quick start applications with Graphql, managed authentication, sessions and asynchronous tasks?

View on HN

Take a look at https://hasura.io

Indeed but I don't see Postgresql hosting included in their plan. I'm thinking more into a fully managed backend solution including Postgresql, auth, async tasks, Recaptcha to protect public mutation. This would be backed by postgraphile that is open source and quite powerful.

Hasura supports authentication and ACLs with the builtin PostgreSQL user system. And we use Kratos (from the ory.sh ecosystem) for OAuth.

It supports PostgreSQL triggers, and webhooks so you can implement your own business logic.

Hasura is open source and provide way more features than postgraphile. IIRC, their SaaS offering includes a PostgreSQL.

It's a wonderful piece of technology that covers 95% of your needs. They also provide a complete docker-compose so you can start tinkering with it on your dev host.

And what you think about https://supabase.io/? They have a managed PostgreSQL and managed Auth.

I don’t think you can get around SQL (in my industry of healthcare) because most of the middleware API generators do the fine grained row level access controls at the API layer. They take over your DB schema without using it for security features, so you have to go in and write SQL either way. That was what turned me off to Hasura a while ago. Their Auth system is fantastic, but it didn’t at the time live in the database, so it didn’t meet my use case. Still a great way to get going and I’m sure folks can figure out how to enable security on the database side if they try. I’m a simpleton and just use SQL

Why would you like to have the Auth system in the database?

Supabase: https://supabase.com/

You prefer postgrest API over Grapql?

if you just need to "translate" graphql query to sql-query (ir doesn't matter is it mssql or PostgreSQL) - you may take a look NReco.GraphQL (which is based on GraphQL.Net engine). Ofc, if you have .Net stack - https://www.nuget.org/packages/NReco.GraphQL/

Hasura is fantastic. While they don’t manage Postgres they do give you a one click deploy to Heroku.

Overall it’s a fantastic tool

Fantastic only because you have Graphql environment few second?

Reply on news.ycombinator.com