Bun SQL is insane.

[Scooter1337]

Postgres.JS (Which is already fast!) with drizzle

user@MacBook-Pro mono % wrk -c 100 -d 10 -t 8 http://localhost:3000/v1/venue/019438e1-f042-7624-b969-859dfc51ead3
Running 10s test @ http://localhost:3000/v1/venue/019438e1-f042-7624-b969-859dfc51ead3
  8 threads and 100 connections
  Thread Stats   Avg      Stdev     Max   +/- Stdev
    Latency    18.56ms    2.81ms  67.03ms   90.34%
    Req/Sec   649.94     50.69   727.00     85.88%
  51815 requests in 10.01s, 26.29MB read
Requests/sec:   5173.88
Transfer/sec:      2.62MB

Bun.SQL with drizzle

user@MacBook-Pro mono @ wrk -c 100 -d 10 -t 8 http://localhost:3000/v1/venue/019438e1-f042-7624-b969-859dfc51ead3
  8 threads and 100 connections
  Thread Stats   Avg      Stdev     Max   +/- Stdev
    Latency     4.04ms    1.32ms  26.14ms   76.58%
    Req/Sec     3.00k   225.39     5.02k    89.18%
  239915 requests in 10.10s, 121.72MB read
Requests/sec:  23744.04
Transfer/sec:     12.05MB

Both ran in development mode.

This is insane!

[kravetsone]

Can share the code?

[Scooter1337]

I went from

import { drizzle, PostgresJsQueryResultHKT } from "drizzle-orm/postgres-js";
import postgres from "postgres";
import * as defaultSchema from "./schema/default.schema";
import * as organizationSchema from "./schema/organization.schema";
import * as authSchema from "./schema/auth.schema";

const schema = { ...defaultSchema, ...organizationSchema, ...authSchema };

const client = postgres(process.env.DATABASE_URL as string);
export const Db = drizzle(client, { schema });

export type DB = typeof Db;

to

import { drizzle } from "drizzle-orm/bun-sql";
import * as defaultSchema from "./schema/default.schema";
import * as organizationSchema from "./schema/organization.schema";
import * as authSchema from "./schema/auth.schema";

const schema = { ...defaultSchema, ...organizationSchema, ...authSchema };

export const Db = drizzle(process.env.DATABASE_URL as string, { schema });

export type DB = typeof Db;

Passing in the SQL object to the client didn't work for some reason, might change it back to that once it's fixed.

[kravetsone]

and all works properly?

The results are too beautiful to believe))

[Scooter1337]

and all works properly?

The results are too beautiful to believe))

Sadly, no, drizzle-team/drizzle-orm#4021

Some queries return strings instead of objects :(, but the query I benchmarked above fully works.