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

→ Download my free SQL Handbook!

THE VALLEY OF CODE

THE WEB DEVELOPER's MANUAL

You might be interested in those things I do:

  • Learn to code in THE VALLEY OF CODE, your your web development manual
  • Find a ton of Web Development projects to learn modern tech stacks in practice in THE VALLEY OF CODE PRO
  • I wrote 16 books for beginner software developers, DOWNLOAD THEM NOW
  • Every year I organize a hands-on cohort course coding BOOTCAMP to teach you how to build a complex, modern Web Application in practice (next edition February-March-April-May 2024)
  • Learn how to start a solopreneur business on the Internet with SOLO LAB (next edition in 2024)
  • Find me on X

Related posts that talk about database: