Use Prisma Postgres with Bun - BunDocumentation Index
Fetch the complete documentation index at: /docs/llms.txt
Use this file to discover all available pages before exploring further.
Skip to main contentBun home pageCreate a new project
First, create a directory and initialize it with bun init.terminalmkdir prisma-postgres-app cd prisma-postgres-app bun init2
Install Prisma dependencies
Then install the Prisma CLI (prisma), Prisma Client (@prisma/client), and the accelerate extension as dependencies.terminalbun add -d prisma bun add @prisma/client @prisma/extension-accelerate3
Initialize Prisma with PostgreSQL
We’ll use the Prisma CLI with bunx to initialize our schema and migration directory. We’ll be using PostgreSQL as our database.terminalbunx --bun prisma init --dbThis creates a basic schema. We need to update it to use the new Rust-free client with Bun optimization. Open prisma/schema.prisma and modify the generator block, then add a User model.prisma/schema.prisma
generator client {
provider = "prisma-client"
output = "./generated"
engineType = "client"
runtime = "bun"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model User {
id Int @id @default(autoincrement())
email String @unique
name String?
}
4Configure database connection
Set up your Postgres database URL in the .env file..envDATABASE_URL="postgresql:http://username:password@localhost:5432/mydb?schema=public"5
Create and run database migration
Then generate and run initial migration.This will generate a .sql migration file in prisma/migrations, and execute the migration against your Postgres database.terminalbunx --bun prisma migrate dev --name init
Environment variables loaded from .env Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "mydb", schema "public" at "localhost:5432" Applying migration `20250114141233_init` The following migration(s) have been created and applied from new schema changes: prisma/migrations/ └─ 20250114141233_init/ └─ migration.sql Your database is now in sync with your schema. ✔ Generated Prisma Client (6.17.1) to ./generated in 18ms6
Generate Prisma Client
As indicated in the output, Prisma re-generates our Prisma client whenever we execute a new migration. The client provides a fully typed API for reading and writing from our database. You can manually re-generate the client with the Prisma CLI.terminalbunx --bun prisma generate7
Initialize Prisma Client with Accelerate
Now we need to create a Prisma client instance. Create a new file prisma/db.ts to initialize the PrismaClient with the Postgres adapter.prisma/db.tsimport { PrismaClient } from "./generated/client";
import { withAccelerate } from '@prisma/extension-accelerate'
export const prisma = new PrismaClient().$extends(withAccelerate())
8Create a test script
Let’s write a script to create a new user, then count the number of users in the database.index.tsimport { prisma } from "./prisma/db";
// create a new user
await prisma.user.create({
data: {
name: "John Dough",
email: `john-${Math.random()}@example.com`,
},
});
// count the number of users
const count = await prisma.user.count();
console.log(`There are ${count} users in the database.`);
9Run and test the application
Let’s run this script with bun run. Each time we run it, a new user is created.terminalbun run index.ts
There are 1 users in the database.terminal
bun run index.ts
There are 2 users in the database.terminal
bun run index.ts
There are 3 users in the database.That’s it! Now that you’ve set up Prisma Postgres using Bun, we recommend referring to the official Prisma Postgres docs as you continue to develop your application.
Was this page helpful?
Use Prisma Postgres with Bun - Bun,AI智能索引,全网链接索引,智能导航,网页索引
- Use Prisma Postgres with Bun - Bun - 提供全网公开链接智能索引服务，快速访问目标内容，支持分类筛选和智能导航