npm install
Make sure PostgreSQL is installed and running on your system.
Create a new database:
CREATE DATABASE nuxt_base;
Create .env
file from the example:
cp .env.example .env
Update the .env
file with your database credentials:
DATABASE_URL="postgresql://username:password@localhost:5432/nuxt_base"
JWT_SECRET="your-super-secret-jwt-key-here"
JWT_EXPIRES_IN="7d"
NUXT_SECRET_KEY="your-nuxt-secret-key-here"
Manual migration:
# Reset and migrate
npx prisma migrate reset --force
npx prisma migrate dev --name init_postgresql
npx prisma generate
npm run dev
# View database in Prisma Studio
npm run db:studio
# Create new migration
npx prisma migrate dev --name migration_name
# Reset database
npx prisma migrate reset
npm run build
npm run preview
npm run generate