README.md

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
• Server-side filtered, paginated and sorted Table in SvelteKit (Part 1/2)
• Server-side filtered, paginated and sorted Table in SvelteKit (Part 2/2)
• SvelteKit TanStack Table edit row (+ custom table components)
• Markdown in SvelteKit with custom Components: mdsvex
• Accessible charts only with CSS? - Charts.css
• Image optimization in SvelteKit with vite-imagetools
• Smooth Page / View Transitions in SvelteKit

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