TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: Json2graphql – From a JSON file to Postgres-backed realtime GraphQL

120 点作者 wawhal超过 6 年前

7 条评论

michelpp超过 6 年前
I&#x27;ve tried Hasura and really liked it, but there were a few quirks that led me to another tool, but in general, the whole idea that tools like Hasura, PostgREST, pREST and PostGraphile are trying to solve are the future.<p>Server side frameworks are obsolete. ORMs are decrepit meta-models and log hewing busywork. Mapping an already powerful model onto one that is less powerful, eating gigabytes of ram to run JVM&#x2F;Python stacks, countless rolling and restarting of processes. So many hand-rolled loops of code that could just be joins. Multiple queries to smash together two datum that could just be views all in so many thousands of lines of pointless code.<p>Postgres is already object-oriented, and has been for decades. It already speaks JSON and has for almost 10 years now. It can speak a number of languages, including Python and Javascript, right in the database. Postgres not only stores your data, it <i>knows</i> your data, the statistical distribution and selectivity of queries. No ORM system maintains this kind of optimization state when they generate SQL.<p>The real power of tools like Hasura is that they get out of the way. They encourage the use of views, functions, extensions, all the powerful stuff that&#x27;s native to Postgres.<p>Who cares if it runs on MySQL? The idea is so simple that MySQL can have its own version that gets out of the way and leverages the core power of MySQL. The idea is not to have more frameworks, but to have fewer.
评论 #18937248 未加载
cpursley超过 6 年前
Hasura is a boon to productivity and keeps gaining very useful features. I really wish they had a hosted version (like netlify); I don&#x27;t want to manage servers.
评论 #18933466 未加载
jacques_chester超过 6 年前
I was excited to see graphql-engine, but unfortunately the AGPL is a bit hard to pitch to folks in an enterprise software context.
评论 #18932139 未加载
评论 #18930432 未加载
评论 #18930960 未加载
maratd超过 6 年前
Is there some way to make data available to specific users, but unavailable to others? Basically enforcing an ACL or similar?
评论 #18931580 未加载
priansh超过 6 年前
This is awesome but how do you deal with circular references?
评论 #18930821 未加载
marknadal超过 6 年前
For other related automatic GraphQL tools that create realtime subscriptions to queries, check out <a href="https:&#x2F;&#x2F;github.com&#x2F;brysgo&#x2F;graphql-gun" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;brysgo&#x2F;graphql-gun</a><p>I&#x27;m curious though, with Postgres, how does the realtime aspect work?
dksidana超过 6 年前
Is your code heavily dependent on Postgres or it works with any SQL store ?
评论 #18931008 未加载