DT
Drizzle Team•2w ago
MrIzzat

Which JavaScript library that works alongside Drizzle ORM is better for pooling, pg.js or postgresjs

I'm working on a JavaScript/TypeScript backend project using drizzle and PostgreSQL where I came across pooling for the first time. I found there are several ways to integrate pooling with drizzle ORM but they each rely on different libraries. There is the pg/node-postgres method which goes like this: 
import { drizzle } from 'drizzle-orm/node-postgres';
import { Pool } from 'pg';

const pool = new Pool({
  connectionString: process.env.DATABASE_URL as string,
    max: 10
})

export const db = drizzle(pool, {
  schema: schema,
  logger: true,
});
import { drizzle } from 'drizzle-orm/node-postgres';
import { Pool } from 'pg';

const pool = new Pool({
  connectionString: process.env.DATABASE_URL as string,
    max: 10
})

export const db = drizzle(pool, {
  schema: schema,
  logger: true,
});
And the Postgres.js version which goes like this: 
import postgres from 'postgres';
import { drizzle } from 'drizzle-orm/postgres-js';

const pool = postgres(process.env.DATABASE_URL as string, { max: 10 });
export const db = drizzle(pool, {
  schema: schema,
  logger: true,
});
import postgres from 'postgres';
import { drizzle } from 'drizzle-orm/postgres-js';

const pool = postgres(process.env.DATABASE_URL as string, { max: 10 });
export const db = drizzle(pool, {
  schema: schema,
  logger: true,
});
Is there a difference in performance between these two methods? If so, which one is the better option? Note the project uses TypeScript
1 Reply
MrIzzat
MrIzzatOP•2w ago
Bump

Did you find this page helpful?