Knex as query builder alternative in Express - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Knex in the context of Express applications?

Knex is a flexible SQL query builder for Node.js that helps you write database queries using JavaScript instead of raw SQL strings. It works well with Express to manage database operations cleanly.

beginner

How does Knex improve writing database queries compared to raw SQL?

Knex lets you build queries step-by-step using JavaScript methods, which reduces errors, improves readability, and helps avoid SQL injection by automatically escaping inputs.

beginner

Show a simple example of selecting all rows from a 'users' table using Knex.

knex('users').select('*').then(rows => { console.log(rows); }); // This code fetches all users and logs them.

intermediate

What are some benefits of using Knex over an ORM in Express?

Knex offers more control over SQL queries, is lighter weight, and lets you write raw SQL when needed. It’s good when you want flexibility without the complexity of a full ORM.

intermediate

How does Knex handle different database types?

Knex supports multiple databases like PostgreSQL, MySQL, SQLite, and MSSQL by using different client configurations, so you can switch databases without changing your query code much.

What does Knex primarily help you do in an Express app?

A Build SQL queries using JavaScript methods

B Create HTML templates

C Manage user sessions

D Handle HTTP routing

Knex is a query builder that helps write SQL queries in JavaScript.

Which of these is a benefit of using Knex over raw SQL strings?

A Manages user authentication

B Automatically creates database tables

C Automatically escapes inputs to prevent SQL injection

D Generates frontend UI components

Knex escapes inputs to help prevent SQL injection attacks.

How do you select all rows from a 'products' table using Knex?

A knex('products').select('*')

B Both A and B

C knex.query('SELECT * FROM products')

D knex.select('*').from('products')

Both knex('products').select('*') and knex.select('*').from('products') work.

Knex supports which of the following databases?

A PostgreSQL

B MySQL

C SQLite

D All of the above

Knex supports PostgreSQL, MySQL, SQLite, and more.

Compared to an ORM, Knex is best described as:

A A lightweight query builder with more control

B A full database migration tool

C A frontend framework

D A user authentication library

Knex is a lightweight query builder offering more control than ORMs.

Explain how Knex helps you write database queries in an Express app and why it might be preferred over raw SQL.

Think about how writing queries in code can be safer and clearer.

Describe the advantages of using Knex when working with multiple database types in your Express project.

Consider how Knex handles different SQL dialects.