Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Hasura GraphQL Engine and SQL Server

github.com

Post reply on HN
Print view View original

31–40 of 85 posts

Re: Hasura GraphQL Engine and SQL Server

#31

Post by notsureaboutpg »

neural_thing wrote: post #19

I am now building on Hasura. Love the experience overall, but some aspects are frustrating. For example, setting up authentication for a React Native (Expo) app with Auth0 is quite cumbersome, and the docs are a bit out of date.

I built an Expo app on top of Hasura and rolled my own passwordless authentication mechanism and it was far far easier than using Auth0, imo. Auth was done using serverless functions to send emails with one-time-use tokens, to match the received one-time-use tokens with those generated in the database, and to return JWTs which the clients can use to auth later on and which grant access to different roles (it was an app with roles for managers, employees, etc.)

You can even implement refresh token / auth token with rotation relatively simply. I felt Auth0 makes these things complicated to implement, whereas implementing them took only a few days and the docs / help online on how to do so are very good these days.

Re: Hasura GraphQL Engine and SQL Server

#33

Post by rattray »

scoopertrooper wrote: post #11
yevpats wrote: post #4

The space is def interesting and the product probably lowers the barrier to entry for development. My main question will be why would you use it against plain/open-source PostgreSQL RBAC + GraphQL server or something like https://www.graphile.org/postgraphile/ ?

Both these projects support Postgres, have open source cores, and feature 'pro' options. https://github.com/hasura/graphql-engine/ https://www.graphile.org/postgraphile/pricing/ https://hasura.io/pricing/ (see: self-hosted) https://hasura.io/docs/2.0/graphql/core/databases/postgres/i...

That's technically true, though Hasura is a well-funded startup with a $99+/mo cloud offering and Enterprise features while postgraphile is one main open-source developer who has support contracts available and accepts donations (the "pro" package is pretty minimal and costs just ~$25/mo).

You can get started with Hasura for free which is great, and you can run it on your own servers (if you want to manage a Haskell service) which is also great, but in practice choosing Hasura means you're relying on a company for your backend and choosing postgraphile means you're relying on an express plugin which you can get a support plan for.

I'm not saying one is the better choice than the other for this reason, many would prefer the funded company.

Re: Hasura GraphQL Engine and SQL Server

#34

Post by CameronNemo »

vsurabhi wrote: post #2

(Vamshi from Hasura) We've been working on SQL server native support and we're happy to announce support for read-only GraphQL cases with new or existing SQL Servers. Next up is adding support for stored procedures, mutations, Hasura event triggers [1] and more! [1]: https://hasura.io/docs/latest/graphql/core/event-triggers/in...

I know this may not be exactly on topic, but do you know when version 2 will be released? My team has been waiting on a single feature from that release for what seems like months (slack in jwt verification time, right now the clocks on our hasura and keycloak servers are off and it is creating issues).

Re: Hasura GraphQL Engine and SQL Server

#35

Post by dkubb »

nerdbaggy wrote: post #23

It’s pretty cool how Hasura uses/abuses Postgres JSON support to be able to run many queries in the same “command”

I think the next generation of ORMs will be built on top of this approach. Being able to query and receive an entire object graph in a single round trip has changed how we develop apps at my company.

Re: Hasura GraphQL Engine and SQL Server

#36

Post by tango12 »

CameronNemo wrote: post #34
vsurabhi wrote: post #2

(Vamshi from Hasura) We've been working on SQL server native support and we're happy to announce support for read-only GraphQL cases with new or existing SQL Servers. Next up is adding support for stored procedures, mutations, Hasura event triggers [1] and more! [1]: https://hasura.io/docs/latest/graphql/core/event-triggers/in...

I know this may not be exactly on topic, but do you know when version 2 will be released? My team has been waiting on a single feature from that release for what seems like months (slack in jwt verification time, right now the clocks on our hasura and keycloak servers are off and it is creating issues).

Hey! We released 2.0-beta.2 this week and we're planning on releasing 2.0-stable on Mon/Tue.

Sorry, I know it took a while, but we had to make sure we could make the upgrade path non-breaking given it was a massive release and this took longer than we expected!

Please do feel free to reach out if you need any help with the upgrade :)

Re: Hasura GraphQL Engine and SQL Server

#37

Post by 1st1 »

dkubb wrote: post #35
nerdbaggy wrote: post #23

It’s pretty cool how Hasura uses/abuses Postgres JSON support to be able to run many queries in the same “command”

I think the next generation of ORMs will be built on top of this approach. Being able to query and receive an entire object graph in a single round trip has changed how we develop apps at my company.

Shameless plug: this is what we do in EdgeDB.

Re: Hasura GraphQL Engine and SQL Server

#38

Post by dominotw »

jensneuse wrote: post #17
nicoburns wrote: post #12

If anyone at Hasura is reading this. Are there any plans to make poll frequency configurable on a per-query basis? We have different queries with dramatically different latency requirements (e.g. 1 second vs 5 minutes vs 1 hour). Currently we are only using Hasura for the low-latency queries, and are falling back to polling for other things. But it would simplify our development model if we could just subscribe to th…

This feature is available with WunderGraph. You can configure Auth, caching, live query polling etc. at a global level and override it for each individual query: https://github.com/wundergraph/polyglot-persistence-postgres... https://github.com/wundergraph/wundergraph-demo/blob/906f72c...

Looks like you are associated with wundergraph( based on your posting history here). Would you mind making that clear in your post given you are posting on a competitors HN post.
Post reply on HN