ORM Benchmark #16
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: | |
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:15 | |
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: false | |
- name: Setup Node.js environment | |
uses: actions/[email protected] | |
with: | |
node-version: 20 | |
- 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 MySQL ORMs benchmark using DEFAULT connections | |
run: | | |
bun prisma generate --schema=./prisma/schema.mysql.prisma > /dev/null | |
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 Postgres ORMs benchmark using DEFAULT connections | |
run: | | |
bun prisma generate --schema=./prisma/schema.postgres.prisma > /dev/null | |
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 MySQL ORMs benchmark using DEFAULT connections | |
run: | | |
npx prisma generate --schema=./prisma/schema.mysql.prisma > /dev/null | |
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 Postgres ORMs benchmark using DEFAULT connections | |
run: | | |
npx prisma generate --schema=./prisma/schema.postgres.prisma > /dev/null | |
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 | |
run: | | |
git config --local user.email "[email protected]" | |
git config --local user.name "masfahru" | |
git add -A | |
git commit -m "🚀 Update Benchmark" | |
- name: GitHub Push | |
uses: ad-m/[email protected] | |
with: | |
branch: ${{ github.ref }} | |
directory: "." | |
github_token: ${{ secrets.GITHUB_TOKEN }} | |