Courses /
Next.js 14
Project Database
For this project, we will use the Postgres database. Let's see how to set it up on Vercel.
Instructions
- Click "Continue to Dashboard";
- Choose "Storage" from the header tabs;
- Create "Postgres (Serverless SQL)";
- Accept the terms and conditions;
- Name the database and click "Create and Continue";
- Click the "Connect" button.
After creating and connecting the database, we must set it up and populate it with data to work with.
Instructions
- Visit the ".env.local" tab;
- Ensure you have all the necessary data:
POSTGRES_URL
;POSTGRES_PRISMA_URL
;POSTGRES_URL_NON_POOLING
;POSTGRES_USER
;POSTGRES_HOST
;POSTGRES_PASSWORD
;POSTGRES_DATABASE
.
- Copy all the data and navigate to the project;
- Find the
.env.example
file in the project root. Rename it to.env
; - Paste the copied data from Vercel;
- Finally, open the terminal and run
npm i @vercel/postgres
to install Vercel Postgres.
Check your
.gitignore
file and ensure that it includes .env
to avoid exposing your database secrets when you push changes to GitHub.
The last step left is to populate the database with data. Let's focus on it in the following chapter.
In Practice
Everything was clear?
Section 4. Chapter 3
Course Content
Next.js 14
4. Deployment and Database
Next.js 14
Project Database
For this project, we will use the Postgres database. Let's see how to set it up on Vercel.
Instructions
- Click "Continue to Dashboard";
- Choose "Storage" from the header tabs;
- Create "Postgres (Serverless SQL)";
- Accept the terms and conditions;
- Name the database and click "Create and Continue";
- Click the "Connect" button.
After creating and connecting the database, we must set it up and populate it with data to work with.
Instructions
- Visit the ".env.local" tab;
- Ensure you have all the necessary data:
POSTGRES_URL
;POSTGRES_PRISMA_URL
;POSTGRES_URL_NON_POOLING
;POSTGRES_USER
;POSTGRES_HOST
;POSTGRES_PASSWORD
;POSTGRES_DATABASE
.
- Copy all the data and navigate to the project;
- Find the
.env.example
file in the project root. Rename it to.env
; - Paste the copied data from Vercel;
- Finally, open the terminal and run
npm i @vercel/postgres
to install Vercel Postgres.
Check your
.gitignore
file and ensure that it includes .env
to avoid exposing your database secrets when you push changes to GitHub.
The last step left is to populate the database with data. Let's focus on it in the following chapter.
In Practice
Everything was clear?
Section 4. Chapter 3