Svelte Kit 1.0 + SQLite Demo App

Code from following YouTube tutorials:

• SvelteKit 1.0 with SQLite Tutorial
• Authentication and Authorization in SvelteKit 1 with SQLite
• Build and run SvelteKit Apps with Docker
• AG-Grid in SvelteKit for Spreadsheet like data editing
• Installable SvelteKit App with Web App Manifest
• Lazy Loading for slowly loading pages in SvelteKit
• Upload, Store and Retrieve Images in SvelteKit (with SQLite)
• Generate a PDF with pdfmake (from SvelteKit)
• Interactive Tables in SvelteKit with TanStack Table
• Export Table to XLSX and CSV with exceljs
• MailCrab: Mock Mailserver for development

Full Playlist: SvelteKit

Run locally

• Install with yarn or npm yarn install or npm install
  • You might need to delete supportedArchitectures in the .yarnrc.yml file if you are not on an M1 Mac
• Start with yarn dev or npm run dev
• Username and Password for login is philipp

Docker

Build and Run App

Build Container:

docker build -t sveltekit-sqlite-img .

Run Container:

docker run -d -p 3000:3000 \
  --mount type=bind,source="$(pwd)"/data/,target=/app/data/ \
  --rm --name sveltekit-sqlite \
  sveltekit-sqlite-img

MailCrab

docker run --rm -p 1080:1080 -p 1025:1025 marlonb/mailcrab:latest

More info: https://github.com/tweedegolf/mailcrab