ORM Benchmark #62
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: ORM Benchmark | |
on: | |
push: | |
branches: | |
- main | |
schedule: | |
- cron: '0 0 * * 1' | |
workflow_dispatch: | |
permissions: write-all | |
jobs: | |
bench: | |
name: Bench | |
strategy: | |
fail-fast: true | |
runs-on: ubuntu-latest | |
services: | |
mysql: | |
image: mysql:8 | |
env: | |
MYSQL_ALLOW_EMPTY_PASSWORD: yes | |
MYSQL_DATABASE: mysqltest | |
MYSQL_USER: mysqltest | |
MYSQL_PASSWORD: mysqltest | |
ports: | |
- 3306:3306 | |
options: >- | |
--health-cmd="mysqladmin ping" | |
--health-interval=10s | |
--health-timeout=5s | |
--health-retries=5 | |
postgres: | |
image: postgres:16 | |
env: | |
POSTGRES_PASSWORD: postgres | |
ports: | |
- 5432:5432 | |
options: >- | |
--health-cmd pg_isready | |
--health-interval 10s | |
--health-timeout 5s | |
--health-retries 5 | |
steps: | |
- name: MySQL - Verify mysqltest DB exists | |
run: mysql --host 0.0.0.0 --port 3306 -umysqltest -pmysqltest -e "SHOW DATABASES LIKE 'mysqltest'" | |
- name: MySQL - Using the old mysql_native_password to support mysql db connector | |
run: mysql --host 0.0.0.0 --port 3306 -uroot -e "ALTER USER 'mysqltest' IDENTIFIED WITH mysql_native_password BY 'mysqltest'; FLUSH PRIVILEGES" | |
- uses: actions/checkout@v4 | |
with: | |
persist-credentials: true | |
ref: ${{ github.head_ref }} | |
- name: Setup Node.js environment | |
uses: actions/[email protected] | |
with: | |
node-version: 22 | |
- name: Install required global packages | |
run: npm i -g bun npm-check-updates | |
- name: Update & install packages | |
run: | | |
ncu -u | |
bun i | |
- name: Setup Databases | |
run: bun --bun run src/setup | |
env: | |
PG_HOST: 0.0.0.0 | |
MYSQL_HOST: 0.0.0.0 | |
- name: Test | |
run: | | |
bun prisma generate --schema=./prisma/schema.postgres.prisma > /dev/null | |
bun --bun test | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: DEFAULT | |
PG_HOST: 0.0.0.0 | |
MYSQL_HOST: 0.0.0.0 | |
- name: Bun Prisma Generate MySQL Schema | |
run: bun prisma generate --schema=./prisma/schema.mysql.prisma > /dev/null | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: DEFAULT | |
MYSQL_HOST: 0.0.0.0 | |
- name: Bun MySQL ORMs benchmark using DEFAULT connections | |
run: bun --bun run mysql.bench.ts > ./results/bun-mysql-default.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: DEFAULT | |
MYSQL_HOST: 0.0.0.0 | |
- name: Bun MySQL ORMs benchmark using MAX connections | |
run: bun --bun run mysql.bench.ts > ./results/bun-mysql-max.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: MAX | |
MYSQL_HOST: 0.0.0.0 | |
- name: Bun MySQL ORMs benchmark using CPU_COUNT as max connections | |
run: bun --bun run mysql.bench.ts > ./results/bun-mysql-cpu-count.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: CPU_COUNT | |
MYSQL_HOST: 0.0.0.0 | |
- name: Bun MySQL ORMs benchmark using only a single connection | |
run: bun --bun run mysql.bench.ts > ./results/bun-mysql-single.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: 1 | |
MYSQL_HOST: 0.0.0.0 | |
- name: Bun Prisma Generate Postgres Schema | |
run: bun prisma generate --schema=./prisma/schema.postgres.prisma > /dev/null | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: DEFAULT | |
PG_HOST: 0.0.0.0 | |
- name: Bun Postgres ORMs benchmark using DEFAULT connections | |
run: bun --bun run postgres.bench.ts > ./results/bun-postgres-default.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: DEFAULT | |
PG_HOST: 0.0.0.0 | |
- name: Bun Postgres ORMs benchmark using MAX connections | |
run: bun --bun run postgres.bench.ts > ./results/bun-postgres-max.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: MAX | |
PG_HOST: 0.0.0.0 | |
- name: Bun Postgres ORMs benchmark using CPU_COUNT as max connections | |
run: bun --bun run postgres.bench.ts > ./results/bun-postgres-cpu-count.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: CPU_COUNT | |
PG_HOST: 0.0.0.0 | |
- name: Bun Postgres ORMs benchmark using only a single connection | |
run: bun --bun run postgres.bench.ts > ./results/bun-postgres-single.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: 1 | |
PG_HOST: 0.0.0.0 | |
- name: Node Prisma Generate MySQL Schema | |
run: npx prisma generate --schema=./prisma/schema.mysql.prisma > /dev/null | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: DEFAULT | |
MYSQL_HOST: 0.0.0.0 | |
- name: Node MySQL ORMs benchmark using DEFAULT connections | |
run: node --no-deprecation --import ./loader.mjs mysql.bench.ts > ./results/node-mysql-default.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: DEFAULT | |
MYSQL_HOST: 0.0.0.0 | |
- name: Node MySQL ORMs benchmark using MAX connections | |
run: node --no-deprecation --import ./loader.mjs mysql.bench.ts > ./results/node-mysql-max.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: MAX | |
MYSQL_HOST: 0.0.0.0 | |
- name: Node MySQL ORMs benchmark using CPU_COUNT as max connections | |
run: node --no-deprecation --import ./loader.mjs mysql.bench.ts > ./results/node-mysql-cpu-count.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: CPU_COUNT | |
MYSQL_HOST: 0.0.0.0 | |
- name: Node MySQL ORMs benchmark using only a single connection | |
run: node --no-deprecation --import ./loader.mjs mysql.bench.ts > ./results/node-mysql-single.txt | |
env: | |
DATABASE_URL: mysql://mysqltest:[email protected]:3306/mysqltest | |
MAX_CONNECTION: 1 | |
MYSQL_HOST: 0.0.0.0 | |
- name: Node Prisma Generate Postgres Schema | |
run: npx prisma generate --schema=./prisma/schema.postgres.prisma > /dev/null | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: DEFAULT | |
PG_HOST: 0.0.0.0 | |
- name: Node Postgres ORMs benchmark using DEFAULT connections | |
run: node --no-deprecation --import ./loader.mjs postgres.bench.ts > ./results/node-postgres-default.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: DEFAULT | |
PG_HOST: 0.0.0.0 | |
- name: Node Postgres ORMs benchmark using MAX connections | |
run: node --no-deprecation --import ./loader.mjs postgres.bench.ts > ./results/node-postgres-max.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: MAX | |
PG_HOST: 0.0.0.0 | |
- name: Node Postgres ORMs benchmark using CPU_COUNT as max connections | |
run: node --no-deprecation --import ./loader.mjs postgres.bench.ts > ./results/node-postgres-cpu-count.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: CPU_COUNT | |
PG_HOST: 0.0.0.0 | |
- name: Node Postgres ORMs benchmark using only a single connection | |
run: node --no-deprecation --import ./loader.mjs postgres.bench.ts > ./results/node-postgres-single.txt | |
env: | |
DATABASE_URL: postgres://postgres:[email protected]:5432/postgres | |
MAX_CONNECTION: 1 | |
PG_HOST: 0.0.0.0 | |
- name: Commit changes | |
uses: EndBug/add-and-commit@v9 | |
with: | |
default_author: github_actions |