Connect to Postgres in a long-running node server

Hi, I'm using drizzle ORM and my backend is a long-running (not serverless) node server. How should I connect? This is how I currently do it, where

DATABASE_URL

DATABASE_URL

uses port

and no query parameters:

import { drizzle } from 'drizzle-orm/node-postgres'
import { Pool } from 'pg'
import { env } from '../../shared/env'

const pool = new Pool({ connectionString: env.DATABASE_URL })

export const db = drizzle(pool, {
    schema: { ... }
})

import { drizzle } from 'drizzle-orm/node-postgres'
import { Pool } from 'pg'
import { env } from '../../shared/env'

const pool = new Pool({ connectionString: env.DATABASE_URL })

export const db = drizzle(pool, {
    schema: { ... }
})

However, I see that the drizzle example does this instead (where

DATABASE_URL

DATABASE_URL

is on port

with no query parameters:

import { drizzle } from 'drizzle-orm/postgres-js'
import postgres from 'postgres'

const client = postgres(process.env.DATABASE_URL, { prepare: false })
const db = drizzle(client);

import { drizzle } from 'drizzle-orm/postgres-js'
import postgres from 'postgres'

const client = postgres(process.env.DATABASE_URL, { prepare: false })
const db = drizzle(client);

What is the optimal way to connect to the database in a non-serverless environment?

Connect to Postgres in a long-running node server

Hi, I'm using drizzle ORM and my backend is a long-running (not serverless) node server. How should I connect? This is how I currently do it, where

DATABASE_URL

DATABASE_URL

uses port

and no query parameters:

import { drizzle } from 'drizzle-orm/node-postgres'
import { Pool } from 'pg'
import { env } from '../../shared/env'

const pool = new Pool({ connectionString: env.DATABASE_URL })

export const db = drizzle(pool, {
    schema: { ... }
})

import { drizzle } from 'drizzle-orm/node-postgres'
import { Pool } from 'pg'
import { env } from '../../shared/env'

const pool = new Pool({ connectionString: env.DATABASE_URL })

export const db = drizzle(pool, {
    schema: { ... }
})

However, I see that the drizzle example does this instead (where

DATABASE_URL

DATABASE_URL

is on port

with no query parameters:

import { drizzle } from 'drizzle-orm/postgres-js'
import postgres from 'postgres'

const client = postgres(process.env.DATABASE_URL, { prepare: false })
const db = drizzle(client);

import { drizzle } from 'drizzle-orm/postgres-js'
import postgres from 'postgres'

const client = postgres(process.env.DATABASE_URL, { prepare: false })
const db = drizzle(client);

What is the optimal way to connect to the database in a non-serverless environment?

Connect to Postgres in a long-running node server

Similar Threads

Connect to Postgres in a long-running node server

Similar Threads

Similar Threads

Similar Threads