ORM Benchmarks for Orange, Drizzle and Prisma

This guide explains how to run the project with Postgres using the Remote - Containers extension in Visual Studio Code. The benchmarks will run in the github action as well. The benchmark numbers are from the latest run in github actions.

Latest benchmarking

Orange: 3.747s
Drizzle: 4.005s
Prisma: 9.067s

Prerequisites

• Docker must be installed on your machine.
• Visual Studio Code (VS Code) must be installed.
• The Remote - Containers extension should be installed in VS Code.

Steps to Run

The github action will always run remotely on push.
But you can also run it locally with the following steps:

1. Start Docker: Make sure Docker is running on your machine.

2. Open Project in VS Code:

   • Open your project folder in VS Code.

3. Reopen in Container:

   • Press F1 to open the command palette.
   • Type and select "Remote-Containers: Reopen in Container".
   • VS Code will build the container based on your configuration files. This may take a few minutes.

4. Running benchmarks:

   • Develop within the container. All defined extensions and settings in devcontainer.json will be available.
   • npm install
   • npm run init to init database
   • npm run drizzle
   • npm run orange
   • npm run prisma
   • npm run mikroorm (Not working yet)

Note

Always use the "Reopen in Container" option in VS Code to work within the Docker container environment for consistency and reproducibility.

Happy Testing!