TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: Hasura – Fast, instant GraphQL APIs on Postgres

382 pointsby tango12almost 7 years ago

27 comments

kilburnalmost 7 years ago
This is very impressive. Congratulations!<p>What I&#x27;m not seeing is how do you envision enforcement of complex business rules when using this API. Examples (silly, but you get the idea):<p>- The price is only visible for projects of type &quot;whatever&quot;.<p>- The price may only be updated when it is not closed (closed_date is null)<p>- The project is only visible on mondays<p>The other point I don&#x27;t see is how do you expect to trigger side-actions when changes are made. For instance:<p>- Send an e-mail when a project is created<p>- Call a webhook when a post is modified<p>Finally, and this may be from my lack of expertise with GraphQL, how do you deal with recursive data structures? For instance, how would you store and fetch a tree of categories?
评论 #17540788 未加载
评论 #17540716 未加载
评论 #17541402 未加载
评论 #17541300 未加载
tango12almost 7 years ago
Hi HN! Super happy to announce the first open-source release of the Hasura GraphQL engine.<p>This is a standalone service that gives you GraphQL on Postgres. It comes with fine-grained access control that can integrate with any auth provider. It can also work with any existing postgres database as is, and allows you to expose select tables&#x2F;views across your postgres schemas over GraphQL.<p>Looking forward to your feedback!
评论 #17540480 未加载
评论 #17540866 未加载
评论 #17544600 未加载
评论 #17540446 未加载
rcdmdalmost 7 years ago
Nice work. There are several competitors in the automagic Postgres REST&#x2F;GraphQL space, and you&#x27;re nailing documentation and ergonomics here. Your site and the Hansura Console sets your project apart from the rest.
sheeshkebabalmost 7 years ago
GraphQL is interesting although it doesn’t appear to be answer to designing better APIs (poor modularaization, monitoring, and tooling come to mind). “Mutations” look to be an afterthought, and schema&#x2F;ui are not impressive either.<p>Above plus companies tripping hard to monetize tooling around something that you get completely for free with REST...<p>Even as UI engineer I don’t get the appeal of it - state, caching and all the “performance” tuning make it too complicated.
miklalmost 7 years ago
First glance reaction: Awesome, just the thing I need.<p>Then I saw the fine print: AGPL. Haskell.<p>The thing might be awesome, but the combination of the legal risk from AGPL (very little legal precedent for AGPL, especially outside the US, so the real legal implications of the license are very murky) and maintenance risk from Haskell (finding good Haskell developers is hard, and the learning curve is brutal), makes it a lot harder to choose.
评论 #17540631 未加载
评论 #17545265 未加载
mmanfrinalmost 7 years ago
I have a bit of a dumb question: where does GraphQL fit in a stack? I&#x27;ve seen in used primarily as a means of aggregating a bunch of disparate microservices, but then I see things like this that put it in the role of app server, almost. What advantages does this give over, for example, a Rails API (also on Postgres)? If it is supposed to fill the role of app server, how do you handle things more involved than simple CRUD operations? Like, if I sign up a user, how -- in a GraphQL world -- would I send a welcome email, typically?
评论 #17542241 未加载
评论 #17541932 未加载
评论 #17542074 未加载
评论 #17541976 未加载
评论 #17541943 未加载
评论 #17542309 未加载
michaelmcmillanalmost 7 years ago
I am very hesitant to couple the business logic of any application to the transport layer (GraphQL) or the persistence layer (Postgres) for that matter.
评论 #17543766 未加载
评论 #17540890 未加载
benororalmost 7 years ago
Impressive! How&#x27;s it different from postgraphql (<a href="https:&#x2F;&#x2F;postgraphql.github.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;postgraphql.github.io&#x2F;</a>) or postgraphile (<a href="https:&#x2F;&#x2F;www.graphile.org&#x2F;postgraphile&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.graphile.org&#x2F;postgraphile&#x2F;</a>)?
评论 #17542216 未加载
评论 #17547845 未加载
tango12almost 7 years ago
Oops! GitHub is down :(<p>We&#x27;re on <a href="https:&#x2F;&#x2F;hasura.io" rel="nofollow">https:&#x2F;&#x2F;hasura.io</a> too.
评论 #17543321 未加载
评论 #17543310 未加载
SOLAR_FIELDSalmost 7 years ago
As a newbie to GraphQL who is having some growing pains adopting a UI for a data warehouse that was basically bolted onto a REST API designed for backend queries, can someone help me understand what the pros and cons are for something like this vs hand rolling all of the backend GraphQL stuff yourself? We have been evaluating switching&#x2F;offering a GraphQL backend for our UI to consume for our product since it seems well suited to our use case but so far the effort required has outweighed the gain we would get from it. Because of this a somewhat turnkey solution like above might be more appealing.
评论 #17543516 未加载
garindraalmost 7 years ago
We at Sale Stock (fashion e-commerce in Indonesia) built an in-house system similar to this but more automatic and works with CockroachDB. Not open source yet, but might be interesting to you guys: <a href="https:&#x2F;&#x2F;speakerdeck.com&#x2F;salestock&#x2F;laskar-high-velocity-graphql-and-lambda-based-software-development-model" rel="nofollow">https:&#x2F;&#x2F;speakerdeck.com&#x2F;salestock&#x2F;laskar-high-velocity-graph...</a> (skip to around mid-way, first half is intro to GraphQL)
评论 #17544766 未加载
victor106almost 7 years ago
Great job!!! Looks awesome<p>I see that one of the ways you want to monetize this is by offering support. Providing support is a good approach to monetize an open source project but it’s not very scalable. Have you thought of any other ways you can monetize this?<p>If others in the HN community can pitch in with any ideas they have on how to monetize an open source project that would be great as well.
HugoDanielalmost 7 years ago
Really cool! Congrats.<p>It would be awesome if it could be made compatible with Postgraphile (<a href="https:&#x2F;&#x2F;www.graphile.org&#x2F;postgraphile&#x2F;introduction&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.graphile.org&#x2F;postgraphile&#x2F;introduction&#x2F;</a>)
评论 #17541879 未加载
zapitaalmost 7 years ago
This is exactly what I was looking for. I will give it a try on my next project.
评论 #17544085 未加载
spocklivelongalmost 7 years ago
I work with a Django app on Postgres, and I&#x27;m not sure how I would migrate that to GraphQL. How things play out in terms of django specific tables? What about relationships between tables? We mostly use the Django app to expose REST APIs, which deal with making complex queries using QuerySets to Postgres. Moving this to GraphQL mean that all the business logic that sits on the REST APIs need to be moved to the frontend?
评论 #17542850 未加载
uptimealmost 7 years ago
Thank you for releasing this. I am impressed with Hasura! No knock on postgraphile, I am trying that out too as well as prisma, but this looks very well done and the boundaries are clear (like postgraphile, views are important to make things work). Your UI is going to make people happy.<p>I have two questions: 1. can I point the hasura cli at my local install? and 2. Can we have UUID fields? I&#x27;d like to use them as primary keys.
评论 #17546580 未加载
wjonasalmost 7 years ago
I have been playing around with it. It&#x27;s great.<p>Better support for ENUMS and MANY TO MANY relationships would be very needed though.
评论 #17565562 未加载
no-such-addressalmost 7 years ago
This is a good trend. Will we see more work aimed at separating the data model and human interface (to make programming with attributed graphs safe and convenient) from back end issues (how to store data and process queries efficiently, where traditional databases are already very advanced.)
jxubalmost 7 years ago
Almost a third of the codebase is written in Haskell, that&#x27;s really nice to hear ;)
评论 #17544073 未加载
jarymalmost 7 years ago
Great to see another project at this problem! We&#x27;ve been internally building something very similar but it uses Kotlin (Java) instead of Haskell.
migaalmost 7 years ago
Why does hasura.io block residential network providers in Poland? I need to use VPN to just check the docs. That does not bode well for users.
评论 #17550693 未加载
评论 #17541707 未加载
faitswulffalmost 7 years ago
How does it handle batch execution of queries?
评论 #17540997 未加载
reilly3000almost 7 years ago
This is going to get tested today for a project. Thanks!
评论 #17541630 未加载
machbioalmost 7 years ago
there is mention of GraphQL proxy - any idea about any available proxies for GraphQL at this moment ?
antigirlalmost 7 years ago
Any subscription support?
评论 #17541767 未加载
jamhanalmost 7 years ago
&quot;Fast, instant&quot;? That&#x27;s, err, just dumb. Fast perhaps. Instant, never.
Alex3917almost 7 years ago
GraphQL is basically the new Mongo, so of course someone will try doing it in Postgres.
评论 #17541102 未加载
评论 #17541116 未加载