Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Project Database | Deployment and Database
Next.js 14

Project DatabaseProject Database

For this project, we will use the Postgres database. Let's see how to set it up on Vercel.

Instructions

  1. Click "Continue to Dashboard";
  2. Choose "Storage" from the header tabs;
  3. Create "Postgres (Serverless SQL)";
  4. Accept the terms and conditions;
  5. Name the database and click "Create and Continue";
  6. Click the "Connect" button.

After creating and connecting the database, we must set it up and populate it with data to work with.

Instructions

  1. Visit the ".env.local" tab;
  2. Ensure you have all the necessary data:
    • POSTGRES_URL;
    • POSTGRES_PRISMA_URL;
    • POSTGRES_URL_NON_POOLING;
    • POSTGRES_USER;
    • POSTGRES_HOST;
    • POSTGRES_PASSWORD;
    • POSTGRES_DATABASE.
  3. Copy all the data and navigate to the project;
  4. Find the .env.example file in the project root. Rename it to .env;
  5. Paste the copied data from Vercel;
  6. 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

Course Content

Next.js 14

Project DatabaseProject Database

For this project, we will use the Postgres database. Let's see how to set it up on Vercel.

Instructions

  1. Click "Continue to Dashboard";
  2. Choose "Storage" from the header tabs;
  3. Create "Postgres (Serverless SQL)";
  4. Accept the terms and conditions;
  5. Name the database and click "Create and Continue";
  6. Click the "Connect" button.

After creating and connecting the database, we must set it up and populate it with data to work with.

Instructions

  1. Visit the ".env.local" tab;
  2. Ensure you have all the necessary data:
    • POSTGRES_URL;
    • POSTGRES_PRISMA_URL;
    • POSTGRES_URL_NON_POOLING;
    • POSTGRES_USER;
    • POSTGRES_HOST;
    • POSTGRES_PASSWORD;
    • POSTGRES_DATABASE.
  3. Copy all the data and navigate to the project;
  4. Find the .env.example file in the project root. Rename it to .env;
  5. Paste the copied data from Vercel;
  6. 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
some-alt