Summary  
This chapter explains how to configure and connect a PostgreSQL database to your project by setting environment variables and installing the required dependency.  

General domain of usage  
Web application backends

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.

The last step left is to populate the database with data. Let's focus on it in the following chapter.

Learn to build modern, high-performance web applications using Next.js. Set up projects with structured layouts, styling, and routing for seamless navigation. Fetch and display data efficiently while optimizing rendering and performance. Implement advanced features like pagination, CRUD operations, and global search for dynamic web apps. Deploy your Next.js projects and connect them with databases, and add authentication to protect user data.

Let's discuss what you need to learn before diving into the Next.js framework, what to expect from this course, and what you'll build.

We will set up the project, inspect ways to add styling to our app and cover visual aspects such as images, fonts, pages, and layouts.

Learn how to easily create and manage a new view for your app and navigate through all pages seamlessly with an incorporated routing system.

Deploy the Next.js app using GitHub and Vercel accounts. Additionally, establish a database to supply the app with the necessary data.

Consider how to obtain and show data to the user clearly and efficiently.

Discover how to implement modern web features such as pagination, CRUD operations, global search, form validation, and more.

Authentication implementation in Next.js.

Setting Up a Project Database

Instructions

Instructions

In Practice