Knex.js VS GraphQL Zeus

AdonisJS core team has created/maintains Lucid. It is a SQL query builder, and an Active Record ORM built on top of Knex. - Source: dev.to / 3 months ago

Now, why not use an ORM? I've seen performance issues too many times with ORMs. I prefer writing my own SQL to avoid surprises. After all, I know the database schema and writing code for a specific purpose very often leads to better performance than generic code. ORMs have to support all kinds of database schemas. I only have to support mine. Having successfully used Knex.js in NodeJS (a popular query builder) in... - Source: dev.to / 5 months ago

Given the dynamic nature of the schema, we employ Knex, a query builder, for database access. - Source: dev.to / 5 months ago

SQL is an old, irregular language to work with, but it is better known than HCL and SQL already has it's own Pulumi/CDK in the form of every ORM with introspection (like Javascript's Prisma, Python's Django, Go's XO etc) and QueryBuilder (LINQ, Knex, etc) in whatever programming language you prefer. You probably already know it. - Source: dev.to / about 1 year ago

How does HN receive SQL builders in general? I feel like most of us agree ORMs are typically a bad idea. I feel like that almost instantly leaves the need for "something" to take its place. In my experience, it's typically been a query builder like this. I've also tried: https://knexjs.org/ https://www.npmjs.com/package/sql-template-strings ("out of date" since like 2016?... - Source: Hacker News / over 1 year ago

When I asked this in StackOverflow over a year ago I reached the solution of using graphql + graphql-zeus. Source: 10 months ago

Graphql-zeus: You write your graphql queries using a JavaScript object like syntax. Looks cool, but I think it's too big of a burden on the team to have to give up writing queries using graphql-tag/gql. Source: over 1 year ago

Https://github.com/graphql-editor/graphql-zeus generates subscription code and in generated code you'll find simple apiSubscription function you can use/copy. Source: almost 2 years ago

You can do this with GraphQL too: https://genql.vercel.app/ https://github.com/graphql-editor/graphql-zeus I did a 5 min talk about these newer breeds of codegen tools (where it's a single client SDK that does automatic return type inference based on the input args), it's really neat: https://www.youtube.com/watch?v=7n3MeMFHiMk. - Source: Hacker News / almost 2 years ago

"Blog spam" = plagiarism of other articles with advertisements inserted? If so, not a good look. On the other hand, the author of this is also the author of "graphql-zeus", to which I owe a great debt of gratitude due to the massive productivity improvements over manually-written query/operation types generation https://github.com/graphql-editor/graphql-zeus. - Source: Hacker News / over 2 years ago