Knex.js Reviews and details

Social recommendations and mentions

• efri, the_framework

  Here's the thing that always bugged me - writing database code over and over for different DBs. Like, why can't everything be as smooth as Laravel's Eloquent? That's where Knex comes in - write once, run anywhere (with a bit of config magic)! - Source: dev.to / 3 months ago

• Make Custom Handlebar Helpers in Ghost!

  If you want to make database queries in Ghost to fetch, for example, the current post, it’s possible and not difficult. You can use a library like knex (https://knexjs.org/), which is a clear and fast SQL query builder. Remember that you’ll need handlebars-async-helpers for this. Configure knex properly to connect to Ghost’s database. - Source: dev.to / 4 months ago

• How to use ORMs (Prisma / Drizzle / Knex.js) in a TypeScript backend built with Encore.ts

  In this post, I’ll walk you through how to work with ORMs like Prisma, Drizzle and Knex.js when working with Encore.ts. - Source: dev.to / 5 months ago

• Low-code drag-and-drop tool for building RESTful APIs with in minutes.

  Knex: SQL query builder used in the application to manage sql databases queries in a easier way by letting knex handel all the hassle for us. - Source: dev.to / 10 months ago

• How to create a Node API with Knex and PostgreSQL

  Knex.js is a versatile SQL query builder primarily used with Node.js. It is designed for flexibility, portability, and ease of use across various databases, such as PostgreSQL, CockroachDB, MSSQL, MySQL, MariaDB, SQLite3, Better-SQLite3, Oracle, and Amazon Redshift. - Source: dev.to / 10 months ago

• Build a type-safe and event-driven Uptime Monitor in TypeScript

  Since most of these APIs will be simple "CRUD" (Create/Read/Update/Delete) endpoints, let's build this service using Knex.js, an ORM Library that makes building CRUD endpoints really simple. - Source: dev.to / 11 months ago

• Show HN: I built a back end so simple that it fits in 1 YAML file

  Looks exactly like https://knexjs.org/ but I bet there are query builders / ORMs with same syntax. - Source: Hacker News / 11 months ago

• Create a Blog web app using Adonis.js 6

  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 / about 1 year ago

• Type-safe Data Access in Go using Prisma and sqlc

  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 / over 1 year ago

• Can I create another WordPress that satisfies humanity?

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

• Why SQL is right for Infrastructure Management

  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 2 years ago

• Kysely: TypeScript SQL Query Builder

  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 2 years ago

• Promises, Thenables, & Lazy-evaluation: What, Why, How

  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 2 years ago

• MagLit - Free and Open Source Link Shortener with Privacy, Encryption, Password Protection and more!

  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 2 years ago

• Am I following best practices for express app with mysql database?

  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 2 years ago

• SELECT from MariaDB

  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 2 years ago

• Flyweight: An ORM for SQLite

  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 2 years ago

• New AdminJS adapter that doesn't need an ORM.

  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 2 years ago

• Query a table with a column and use another column on this table to fetch row from another table.

  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 2 years ago

• how common is it to use an ORM?

  That, or a query builder like Knex: https://knexjs.org/. Source: over 2 years ago

• Building REST Endpoints with Knex and PostgreSQL

  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 / over 2 years ago