Database

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.

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:

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:

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:

pnpm run prisma:push

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