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,
});
And the Postgres.js version which goesl ike this:
import postgres from 'postgres';
import { drizzle } from 'drizzle-orm/postgres-js';
const client = postgres(process.env.DATABASE_URL as string, { max: 10 });
export const db = drizzle(client, {
schema: schema,
logger: true,
});
Is there a difference between these two methods? If so, which one is the better option?