Back to results
prisma/nextjs-prisma-postgres-demo(opens in a new tab)
Language: TypeScript
- stars
- 81
- watchers
- 0
- forks
- 29
- open issues
- 1
- Last updated
- 03/06/2025
gem-hunterLanguage: TypeScript
This example demonstrates how to build a full-stack web application using Next.js, Prisma Client, and Prisma Postgres.
TL;DR: Prisma Postgres is a new kind of Postgres database that's optimized for developer productivity. It offers instant provisioning, built-in connection pooling, edge caching, and seamless integration with Prisma ORM.
If you just want to run the app locally, rename .env.example to .env and fill in the values.
Go to the Console and create a new Prisma Postgres instance. Use the DATABASE_URL value from the new instance to fill out the .env file.
Go to the GitHub Developer Settings and create a new OAuth app.
For the required fields:
http://localhost:3000/api/auth/callback/githubAfter creating the app, you'll be redirected to the app's page. Copy the Client ID and Client Secret values and use them to fill out AUTH_GITHUB_ID and AUTH_GITHUB_SECRET in the .env file.
Run npx auth secret --copy to generate a new AUTH_SECRET value. Fill out the .env file with the new value.
Install npm dependencies:
npm install
Run the following command to create your database. This also creates the needed tables that are defined in prisma/schema.prisma:
npx prisma migrate dev --name init
When npx prisma migrate dev is executed against a newly created database, seeding is also triggered. The seed file in prisma/seed.ts will be executed and your database will be populated with the sample data.
If you switched to Prisma Postgres in the previous step, you need to trigger seeding manually (because Prisma Postgres already created an empty database instance for you, so seeding isn't triggered):
npx prisma db seed
npm run dev
The server is now running on http://localhost:3000.
Logged out view:
Logged in view:
Here are some ways to learn more and expand upon this example: