Skip to content

Connect to Postgres local vs Vercel Postgres with Kysely

I switched a codebase from local Postgres database to Vercel Postgres, which comes with its own optimized package.

I used this to set up Kysely:

import {
  Kysely,
  PostgresDialect,
} from 'kysely'

import pg from 'pg'

const POSTGRES_URL = //...from env

const dialect = new PostgresDialect({
  pool: new pg.Pool({
    connectionString:
      POSTGRES_URL
    max: 10,
  }),
})

export const db = new Kysely({
  dialect
})

With Vercel Postgres, I used:

import { createKysely } from '@vercel/postgres-kysely'

const POSTGRES_URL = //...from env

export const db = createKysely({
  connectionString: POSTGRES_URL
})

The db now already know how to look up the environment variable POSTGRES_URL


I wrote 21 books to help you become a better developer:

  • HTML Handbook
  • Next.js Pages Router Handbook
  • Alpine.js Handbook
  • HTMX Handbook
  • TypeScript Handbook
  • React Handbook
  • SQL Handbook
  • Git Cheat Sheet
  • Laravel Handbook
  • Express Handbook
  • Swift Handbook
  • Go Handbook
  • PHP Handbook
  • Python Handbook
  • Linux Commands Handbook
  • C Handbook
  • JavaScript Handbook
  • Svelte Handbook
  • CSS Handbook
  • Node.js Handbook
  • Vue Handbook
...download them all now!

Related posts that talk about database: