Project 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.

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

In Practice