Kysely vs Drizzle

This project compares two popular TypeScript SQL query builders: Kysely and Drizzle.

Schema

The project uses a simple schema for demonstration purposes, you can find it's initialisation scripts in init.sql.

The schema is composed of products, categories, customers, orders, and order-items.

Getting Started

1. Clone the repository:

git clone https://github.com/your-username/kysely-vs-drizzle.git
cd kysely-vs-drizzle

2. Install dependencies:

make install

3. To run the project tests

make test

4. To start the db

make start-db

The Project Structure

The repository part for Knex, Kysely, and Drizzle is structured as follows:

src/
├── knex/
├── kysely/
└── drizzle/

Each directory contains the respective implementation of the SQL query builder, with tests and example queries.