4 ms·
GraphQL and PostgreSQL as a managed back end?
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?
- linkdd 5y agoTake a look at https://hasura.io https://hasura.io
- niolap 5y agoIndeed 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.
- linkdd 5y agoHasura 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.
- niolap 5y agoAnd what you think about https://supabase.io/ https://supabase.io/? They have a managed PostgreSQL and managed Auth.
- tbrock 5y agoSupabase: https://supabase.com/ https://supabase.com/
- niolap 5y agoYou prefer postgrest API over Grapql?
- deleted 5y ago[deleted]
- bionhoward 5y agoI 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
- niolap 5y agoWhy would you like to have the Auth system in the database?
- bnchrch 5y agoHasura is fantastic. While they don’t manage Postgres they do give you a one click deploy to Heroku. Overall it’s a fantastic tool
- niolap 5y agoFantastic only because you have Graphql environment few second?
- Maka_buka 5y agoif 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/ https://www.nuget.org/packages/NReco.GraphQL/