Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Setting Up a Project Database | Deploying a Next.js App and Setting Up a Database
Next.js 14 Mastery for Building Modern Web Apps
course content

Course Content

Next.js 14 Mastery for Building Modern Web Apps

Next.js 14 Mastery for Building Modern Web Apps

1. Introduction to Next.js
Welcome to the CourseProject OverviewCourse PrerequisitesHow This Course Is Structured
2. Setting Up a Next.js Project
Setting Up the Next.js Project Understanding the Project File and Folder StructureStyling Approaches in Next.jsAdding the Global CSS FileUsing Tailwind CSS for StylingWorking with CSS ModulesApplying Styles ConditionallyAdding Custom Google FontsChallenge: Implementing a Custom Google FontHandling Images in Next.js
3. Building Pages and Layouts in Next.js
How Next.js Routing WorksChallenge: Creating a New PageBuilding a Common Layout ComponentOptimizing Navigation in Next.jsCreating and Managing Active Links
4. Deploying a Next.js App and Setting Up a Database
Setting Up GitHub and Vercel AccountsDeploying the Next.js App to VercelSetting Up a Project DatabasePopulating the Database with Initial Data
5. Fetching and Displaying Data in Next.js
How to Fetch Data in Next.jsWorking with the Dashboard PageChallenge: Retrieving and Displaying DataDynamic vs. Static Rendering in Next.jsUnderstanding LoadersImplementing Specific Part LoadersChallenge: Create a Skeleton LoaderOptimizing Loaders with Component Grouping
6. Advanced Next.js Features and Optimizations
Building the Invoices PageDeveloping the Search FunctionalityAdding Pagination to a Next.js AppUsing Server Actions in Next.jsCreating a New Item in the DatabaseUpdating an Item in the DatabaseDeleting an Item in the DatabaseChallenge: Implementing Form Validation
7. Implementing Authentication in Next.js
Understanding AuthenticationSetting Up the Login RouteUsing NextAuth.js for AuthenticationConfiguring Authentication and Protecting RoutesHashing Passwords and Managing CredentialsImplementing Sign-In FunctionalityConnecting the UI with Authentication LogicImplementing Logout FunctionalityFinal Thoughts and Next Steps

book
Setting Up a 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

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 4. Chapter 3
We're sorry to hear that something went wrong. What happened?
some-alt