Skip to content

Set up Lucia Auth for local Postgres DB vs Vercel Postgres

New Course Coming Soon:

Get Really Good at Git

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

I used this to connect Lucia Auth:

import { postgres as postgresAdapter } from '@lucia-auth/adapter-postgresql'
import postgres from 'postgres'

const POSTGRES_URL = //..lookup from env variables

const postgresDatabase = postgres(POSTGRES_URL)

const auth = lucia({
  adapter: postgresAdapter(
    postgresDatabase,
    dbConfig
  ),
	//...
})

With Vercel Postgres, I used:

import { pg } from '@lucia-auth/adapter-postgresql'
import { db } from '@vercel/postgres'

const auth = lucia({
  adapter: pg(db, dbConfig),
	//...
})

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

Are you intimidated by Git? Can’t figure out merge vs rebase? Are you afraid of screwing up something any time you have to do something in Git? Do you rely on ChatGPT or random people’s answer on StackOverflow to fix your problems? Your coworkers are tired of explaining Git to you all the time? Git is something we all need to use, but few of us really master it. I created this course to improve your Git (and GitHub) knowledge at a radical level. A course that helps you feel less frustrated with Git. Launching Summer 2024. Join the waiting list!
→ Read my SQL Tutorial on The Valley of Code

Here is how can I help you: