I first learned about Knex.js from a technical interview, it was the first time I used another abstraction to interact with the database besides ORM Sequelize.js, which I learned during my study at…

JSPlainEnglish's platform is a resource for JavaScript developers, offering insights into JavaScript fundamentals, modern web development techniques, and JavaScript frameworks. Through articles, tutorials, and code snippets, JSPlainEnglish offers insights into JavaScript language features, ES6 syntax, and functional programming concepts. Readers can learn about building interactive web applications, working with JavaScript libraries, and optimizing frontend performance to create engaging user experiences.

JavaScript in Plain English

Knex.js is a thin abstraction that sits on top of the database driver for relational databases. It supports transactions, connection pooling, streaming queries, a thorough test suite, and the ability to run in the browser. Knex can be used in both Node.Js and the browser, limited only by WebSQL’s constraints.

Use SQL Query Builder Knex.js with Node.js and Express.js

Step 1. Install Knex.js and migration CLI

Step 5. Update the database using migration CLI

Step 6. Application configuration and session store