Files
Ankur Datta 92a9d2840d Add Prisma ORM example to Next.js examples (#75290)
- A Next.js starter app using [Prisma
Postgres](https://www.prisma.io/postgres) and Prisma ORM

This PR adds a new example demonstrating how to integrate Prisma ORM
with a Next.js application. The example includes:

- Setup instructions for Prisma Postgres
- Example models and queries
- Basic CRUD operations using Prisma

---------

Co-authored-by: Nikolas <nikolas.burk@gmail.com>
Co-authored-by: Alex Martin <alex.martin@vercel.com>
Co-authored-by: JJ Kasper <jj@jjsweb.site>
2025-07-15 08:48:35 -07:00

188 lines
7.7 KiB
TypeScript
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
export default function SetupPage() {
return (
<div className="min-h-screen bg-gray-100 flex flex-col items-center py-12 px-6">
<div className="max-w-3xl w-full bg-white p-8 rounded-lg shadow-md border border-gray-300 overflow-y-auto h-[90vh]">
<div className="max-w-3xl bg-white p-8 rounded-lg shadow-md border border-gray-300">
<h1 className="text-3xl font-bold text-gray-900 mb-6">
🛠️ Prisma Postgres Setup Guide
</h1>
<p className="text-gray-700">
Congratulations, you just deployed the Next.js + Prisma Postgres
starter template 🎉
</p>
<p className="text-gray-700 mt-2">
To make the app work, you need to connect it to a database.
</p>
{/* Step 1 */}
<div className="mt-6">
<h2 className="text-2xl font-semibold text-gray-900">
1. Create a Prisma Postgres instance
</h2>
<p className="text-gray-700 mt-2">
Create a new Prisma Postgres database instance:
</p>
<ol className="list-decimal pl-6 mt-2 space-y-1 text-gray-700">
<li>
Go to{" "}
<a
href="https://console.prisma.io"
className="text-blue-600 hover:underline"
target="_blank"
rel="noreferrer"
>
Prisma Console
</a>
.
</li>
<li>
Click <strong>New project</strong> to create a new project.
</li>
<li>
Enter a name for your project in the <strong>Name</strong>{" "}
field.
</li>
<li>
Inside the <strong>Prisma Postgres</strong> section, click{" "}
<strong>Get started</strong>.
</li>
<li>
Choose a region close to your location from the{" "}
<strong>Region</strong> dropdown.
</li>
<li>
Click <strong>Create project</strong> to set up your database.
</li>
</ol>
</div>
{/* Step 2 */}
<div className="mt-6">
<h2 className="text-2xl font-semibold text-gray-900">
2. Add the Prisma integration token to Netlify
</h2>
<p className="text-gray-700 mt-2">
When you created the site with this template, you already
installed the{" "}
<a
href="https://app.netlify.com/extensions/prisma-postgres"
className="text-blue-600 hover:underline"
target="_blank"
rel="noreferrer"
>
Prisma Postgres extension
</a>{" "}
in your Netlify account. Next, you need to copy Prisma&apos;s
integration token into the extension in your Neltify Dashboard:
</p>
<ol className="list-decimal pl-6 mt-2 space-y-1 text-gray-700">
<li>
In the{" "}
<a
href="https://console.prisma.io"
className="text-blue-600 hover:underline"
target="_blank"
rel="noreferrer"
>
Prisma Console
</a>
, navigate to the root of your Workspace and click the{" "}
<strong>Integrations</strong> tab in the left-hand sidenav.
</li>
<li>
In the <strong>Configure Team settings</strong> section, click
the <strong>Generate integration token</strong> button.
</li>
<li>
Copy the generated token, you now need to add it to the
team-level extension configuration in your Netlify account as
described in the next step.
</li>
<li>
In your Netlify account, click the <strong>Extensions</strong>{" "}
tab in the left-hand sidenav and navigate to the installed{" "}
<strong>Prisma Postgres</strong> extension. Then find the text
field for the <strong>Integration token</strong>, paste the
token from the previous step into it and click{" "}
<strong>Save</strong>.
</li>
</ol>
</div>
{/* Step 3 */}
<div className="mt-6">
<h2 className="text-2xl font-semibold text-gray-900">
3. Connect Netlify site with Prisma Postgres instance
</h2>
<p className="text-gray-700 mt-2">
In this step, you will connect your Netlify site with the Prisma
Postgres instance you just created:
</p>
<ol className="list-decimal pl-6 mt-2 space-y-1 text-gray-700">
<li>
In your Netlify Dashboard, click on the <strong>Sites</strong>{" "}
item in the left-hand sidenav and click on the site that was
deployed with this template.
</li>
<li>
In the <strong>Extensions</strong> section, click on{" "}
<strong>Prisma Postgres</strong>.
</li>
<li>
Find the <strong>Project</strong> dropdown and select the one
project created in <strong>Step 1</strong> before.
</li>
<li>
In the next two dropdowns for{" "}
<strong>Production environment</strong> and{" "}
<strong>Preview environment</strong> select{" "}
<strong>Development</strong>. Then click <strong>Save</strong>.
(At this stage, you can theoretically connect different database
instances to the different environments in Netlify. For the
purpose of this demo, we are just connecting both environments
to the <strong>Development</strong> database in Prisma Console).
</li>
</ol>
</div>
{/* Step 4 */}
<div className="mt-6">
<h2 className="text-2xl font-semibold text-gray-900">
4. Re-deploy the site in Netlify
</h2>
<p className="text-gray-700 mt-2">
Your site is now fully configured to load data from the Prisma
Postgres database you just created, the last thing you need to do
is re-deploy the site via the Netlify Dashboard.
</p>
<ol className="list-decimal pl-6 mt-2 space-y-1 text-gray-700">
<li>
In your Netlify Dashboard, click on the <strong>Sites</strong>{" "}
item in the left-hand sidenav and click on the site that was
deployed with this template.
</li>
<li>
Find the <strong>Project</strong> dropdown and select the one
project created in <strong>Step 1</strong> before.
</li>
<li>
Click on the <strong>Deploys</strong> tab on the left, click the{" "}
<strong>Trigger deploy</strong> button, and finally click{" "}
<strong>Clear cache and deploy site</strong>.
</li>
</ol>
<p className="text-gray-700 mt-2">
{" "}
Once the deployment is ready, you can click on{" "}
<strong>Open production deploy</strong> and use the app by
creating users and posts via the UI 🎉
</p>
</div>
</div>
</div>
</div>
);
}