SZLG nyílt napok

The stack

• database: postgresql with prisma ORM
• sveltekit framework

Svelte

Once you've created a project and installed dependencies with npm install (or pnpm install or yarn), start a development server:

npm run dev

# or start the server and open the app in a new browser tab
npm run dev -- --open

Building

To create a production version of your app:

npm run build

Database

Use docker to create a new postgres database.

# Pull the image
docker pull postgres
# Create new instance
docker run -e "POSTGRES_PASSWORD=password" -e "POSTGRES_USER=default" -d -p 5432:5432 postgres

Configure the DATABASE_URL variable in .env for prisma.

# format: `postgresql://[username]:[password]@[host]:[port]/[username|database]?schema=public`
DATABASE_URL="postgresql://default:password@localhost:5432/default?schema=public"

Migrate database with:

npm run db:migrate [name]
# or
npx prisma migrate dev --name [name]

Reset database:

npm run db:reset
# or
prisma migrate reset dev

Other environment variables

# required to send emails
VITE_SENDGRID_API_KEY

# required for recaptcha
PUBLIC_RECAPTCHA_CLIENT_KEY
VITE_RECAPTCHA_SERVER_KEY

# required for signing jwts
VITE_PRIVATE_SECRET

# default admin settings
VITE_ADMIN_MAIL
VITE_ADMIN_PASS