Database

Configure the database with Prisma and PostgreSQL.

The project uses Prisma as the database ORM and PostgreSQL as the database.

Database URL

I recommend using Neon for your database hosting who provides a free tier for development. Wathever you can use any other provider or host your database on your own server, for example via Docker.

You need to set the DATABASE_URL environment variable in your .env file.

.env

DATABASE_URL=postgresql://user:password@localhost:5432/database

Local PostgreSQL with Docker

The project includes a Docker Compose configuration for running PostgreSQL locally. You can start the database using:

Terminal

docker-compose up -d postgres

This will start a PostgreSQL container with the following configuration:

Database name: nuxt_saas
Username: postgres
Password: postgres
Port: 5432

Then, set the DATABASE_URL in your .env file as follows:

.env

DATABASE_URL=postgresql://postgres:postgres@localhost:5432/nuxt_saas

Push the schema to the database

After setting the DATABASE_URL environment variable, you can push the schema to the database by running the following command:

Terminal

pnpm run prisma:push

This command will create the tables in the database based on the schema defined in the prisma/schema.prisma file.

Authentification

Configure the authentification with Sidebase Auth.

E-mail

Configure the e-mail sending with Resend.