Looks exactly like https://knexjs.org/ but I bet there are query builders / ORMs with same syntax. - Source: Hacker News / 7 days ago
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 / 4 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 / 6 months ago
Given the dynamic nature of the schema, we employ Knex, a query builder, for database access. - Source: dev.to / 7 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
Of course, this is a trivial example that you probably won’t find in production code, but there are many projects that use lazy-evaluated Promise-like objects. Probably the most common example is with database ORMs and query builders like Knex.js or Prisma. - Source: dev.to / over 1 year ago
Why not just use a mariadb or postgres docker image? heck, even sqlite should be fine, given the simplicity of your needs. I work with nodejs myself, I'd highly recommend knexjs for this- it's super flexible! Source: over 1 year ago
Also, but that's just me, I would at least use a query builder like Knex to avoid having to write sql in code (if not using an ORM but that might be an overkill depending on what you've got to do). Source: over 1 year ago
It’s based on the Knex.js (https://knexjs.org/) query builder for JavaScript. I’m personally using it with MySQL and PostgreSQL databases with fantastic results. If you’re interested and need help feel free to PM me and I’ll try to help out as much as I can. Source: over 1 year ago
MikroOrm is a pretty fantastic project IMO. It uses Knex as the query builder so maybe you can just use that directly: https://knexjs.org/. - Source: Hacker News / over 1 year ago
Our backend server had been using AdminJS with Typeorm. But recently, we migrate our server from Typeorm to Knex. It tooks about a week, but after migration, we noticed that there is no adapter that doesn't need an ORM. So I made adminjs-sql project. If you are interested in, checkout adminjs-sql. Contributions are welcome!! Source: over 1 year ago
I am bit new to SQL and using knex.jsI am trying to fetch data by combining two tables, which must be a trivial thing I reckon. Source: over 1 year ago
That, or a query builder like Knex: https://knexjs.org/. Source: almost 2 years ago
By building a demo project, we’ve learned how to build REST endpoints with Knex and PostgreSQL. We started by introducing PostgreSQL and Knex and why you should use them, then we created a blog project for the demonstration. Now that you’ve gotten the knowledge you seek, how would you use a query builder in your next project? Consider learning more about Knex from their official website and take things even further! - Source: dev.to / almost 2 years ago
Now to create the schema and tables we will simply use the knexjs. - Source: dev.to / almost 2 years ago
For using SQL with JavaScript check out knex.js. Source: almost 2 years ago
Knex.js is SQL query builder for PostgreSQL, CockroachDB, MSSQL, MySQL, MariaDB, SQLite3, Better-SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use. -- source. - Source: dev.to / about 2 years ago
I used Node.js with the inclusion of a package called Knex, a SQL query builder for relational databases. Migration scripts are executed using the Knex command line interface. Below is the code as it corresponds to each step of the process:. - Source: dev.to / about 2 years ago
Indeed, Objection can be said to be a relational query builder. Objection is built on top of a SQL query builder, knex. Due to this, all databases supported by Knex are equally supported by Objection.js. They include SQLite3, PostgreSQL, and MySQL. - Source: dev.to / about 2 years ago
This DDL is generated by the Directus database migration scripts, which use Knex.js. I'm not a big fan replaying the life of the datamodel for each deployment - DDL is never cheap, but I understand the agility of it. - Source: dev.to / about 2 years ago
Do you know an article comparing Knex.js to other products?
Suggest a link to a post with product alternatives.
This is an informative page about Knex.js. You can review and discuss the product here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.