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.

Scaling to 1M active GraphQL subscriptions on Postgres

353 pointsby tango12about 6 years ago

16 comments

aidosabout 6 years ago
Just another little shout out for Hasura here. It’s a really lovely system to use and the team behind it are awesome to deal with. Super friendly and helpful.<p>We evaluated a lot of stuff recently before settling on Hasura. Prisma, aws appsync, postgraphile, roll our own socketio backend etc. I had a few hesitations about Hasura. In particular I was hoping to lean on Postgres RLS for the authorisation, and to be able to customise the graphql endpoints a bit more. After hearing the rational from the guys about how their system is better than RLS and seeing the patterns they have for implementing the logic I’m really happy we made the leap.<p>We’re still in early days, but it’s been really solid and a real pleasure to use.<p>(No affiliation, but happily paying for their support licence)
评论 #20065529 未加载
评论 #20067828 未加载
评论 #20066474 未加载
Thaxllabout 6 years ago
I was curious about the code so I went to check it, it&#x27;s written in Haskell, never seen Haskell before, it&#x27;s really hard to follow for someone not used to it: <a href="https:&#x2F;&#x2F;github.com&#x2F;hasura&#x2F;graphql-engine&#x2F;blob&#x2F;master&#x2F;server&#x2F;src-lib&#x2F;Hasura&#x2F;Server&#x2F;App.hs" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;hasura&#x2F;graphql-engine&#x2F;blob&#x2F;master&#x2F;server&#x2F;...</a><p>Not sure how people enjoy FP.
评论 #20064438 未加载
评论 #20064867 未加载
评论 #20064822 未加载
评论 #20064312 未加载
评论 #20066862 未加载
评论 #20068114 未加载
评论 #20065461 未加载
评论 #20065166 未加载
londons_exploreabout 6 years ago
&gt; we’ve currently fallen back to interval based polling to refetch queries.<p>This fancy &quot;subscribe to events when the results of this query change&quot; system boils down to just polling the database...
评论 #20065430 未加载
评论 #20065752 未加载
评论 #20065436 未加载
themccallisterabout 6 years ago
I’ve been using Hasura for around 3 months now. It has changed the velocity and way I approach our projects. I have a small team that works as a startup inside of a larger organization and this was crucial to delivering some key projects... plus very little code. The event trigger really help reduce our costs as well, using the Serverless.com framework with Lambda Go has been a huge success in our organization!<p>Thank you to the Hasura team for all you do and in turn allow me and my team to do!
thegoleffectabout 6 years ago
When I first saw Hasura, it was AGPL licensed which makes it unusable in a lot of use cases so we passed on it. Looks like they converted it to Apache license two months ago. I suppose it is worth another look, I&#x27;m glad they made the change.
dmitryminkovskyabout 6 years ago
Hasura is such a promising application platform. I tried it a few months ago and was really pleased. In a way it kind of felt like RethinkDB, except GraphQL and Postgres. Was very easy to turn on with Docker Compose and play around. Looking forward to 1.0!
评论 #20064745 未加载
rishav_sharanabout 6 years ago
As an Indian engineer, Hasura is one the few indian startups that i really am proud of. They are innovative, distinct, product focused and super young. The only other company which made me feel like this was Notion Ink, but those guys seem to have faded away.<p>I wish Hasura the best and would be cheering for them from the sidelines
评论 #20068324 未加载
gunnarmorlingabout 6 years ago
I&#x27;m impressed by the numbers, but I&#x27;m having some doubts about the general idea of exposing your database via GraphQL.<p>It seems to expose your internal data structures, and any change to those will immediatly impact that public GraphQL API. Also it seems that this approach would only work well for applications without any business logic, or with business logic solely implemented in the database. At least the applications I&#x27;ve been working on wouldn&#x27;t fall into this category.<p>But in any case, impressive work and demos!
评论 #20067777 未加载
agrippanuxabout 6 years ago
Hasura is fantastic. I am using it for several projects atm. Coming from Prisma it&#x27;s refreshingly easy to use and well thought out. The security&#x2F;ACL model is esp. nice and easy to grok.
pier25about 6 years ago
We evaluated Hasura and the only problem we found is the integration with our own authorization system. Otherwise Hasura is quite frankly amazing.<p>Our auth system has many roles per user, then each role has its permissions, pretty common setup. The problem is that Hasura expects a single default role per request to then evaluate against its permissions. The Hasura team has been looking into accepting an array of roles and merging permissions and whatnot, but AFAIK this hasn&#x27;t been solved.<p>If you start with Hasura from scratch this is not really a problem, it happened to us because we had to figure out how to integrate Hasura with our current permissions.
评论 #20068353 未加载
lubesGordiabout 6 years ago
I&#x27;m curious about the underlying push tech. Is Hasura using firebase to handle that? Then firebase relies on different push services depending on the client, like Apple&#x27;s push service for iOS and http&#x2F;2&#x27;s push for web (which is supported by what percentage of browsers)?
评论 #20065909 未加载
StreamBrightabout 6 years ago
Nice scaling numbers. Can you use Hasura without Kubernetes or Docker?
评论 #20064635 未加载
jazoomabout 6 years ago
I know there&#x27;s an issue about this but it doesn&#x27;t really indicate Hasura&#x27;s intentions regarding it:<p>Is supporting CockroachDB something Hasura is actively working on?
评论 #20065238 未加载
machbioabout 6 years ago
Write Ahead Logs would have been amazing - hate that AWS RDS does not support WAL - could have saved so much time for some of the applications we build.
评论 #20067710 未加载
he0001about 6 years ago
How does it handle transactions and locking? It seem to support multiple databases, does it handle distributed transactions?
rj5almost 6 years ago
I can’t wait to try this out!