Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Impara Populating the Database with Initial Data | Deploying a Next.js App and Setting Up a Database
Next.js 14 Mastery for Building Modern Web Apps

bookPopulating the Database with Initial Data

Let's add some initial data to the database.

Look for the file named seed.js in the scripts folder of the project. This script contains instructions for creating and seeding tables for invoices, sellers, users, and income.

Don't worry if you don't fully understand the code details. In essence, the script uses SQL to create the tables and populates them with data from the placeholder-data.js file.

To proceed, add the following line to your scripts in the package.json file:

To proceed, we need to access the terminal and execute the following command: npm run seed.

We should see the following messages in the terminal, indicating that the data was successfully populated.

Database Testing

Navigate to the "Query" tab to execute the SQL request. Let's attempt to run the following query.

We should get the following result:

In Practice

Tutto è chiaro?

Come possiamo migliorarlo?

Grazie per i tuoi commenti!

Sezione 4. Capitolo 4

Chieda ad AI

expand

Chieda ad AI

ChatGPT

Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione

Awesome!

Completion rate improved to 2.08

bookPopulating the Database with Initial Data

Scorri per mostrare il menu

Let's add some initial data to the database.

Look for the file named seed.js in the scripts folder of the project. This script contains instructions for creating and seeding tables for invoices, sellers, users, and income.

Don't worry if you don't fully understand the code details. In essence, the script uses SQL to create the tables and populates them with data from the placeholder-data.js file.

To proceed, add the following line to your scripts in the package.json file:

To proceed, we need to access the terminal and execute the following command: npm run seed.

We should see the following messages in the terminal, indicating that the data was successfully populated.

Database Testing

Navigate to the "Query" tab to execute the SQL request. Let's attempt to run the following query.

We should get the following result:

In Practice

Tutto è chiaro?

Come possiamo migliorarlo?

Grazie per i tuoi commenti!

Sezione 4. Capitolo 4
some-alt