Sveltekit 1.0 Sqlite Demo App

screenshot of Sveltekit 1.0 Sqlite Demo App
svelte
vite

My demo app of various SvelteKit experiments from my YouTube series.

Overview:

The Svelte Kit 1.0 + SQLite Demo AppCode is a collection of code snippets and tutorials that showcase various features and functionalities of Svelte Kit 1.0 using SQLite as the database. These tutorials cover a range of topics including authentication and authorization, Docker integration, lazy loading, image handling, PDF generation, interactive tables, server-side filtering, pagination and sorting, markdown support, image optimization, smooth page transitions, and more.

Features:

  • SvelteKit 1.0 with SQLite Tutorial: A tutorial on integrating SQLite with Svelte Kit 1.0.
  • Authentication and Authorization in SvelteKit 1 with SQLite: Explains how to implement authentication and authorization in Svelte Kit using SQLite.
  • Build and run SvelteKit Apps with Docker: Guides on building and running SvelteKit apps within Docker containers.
  • AG-Grid in SvelteKit for Spreadsheet like data editing: Demonstrates how to use AG-Grid to create spreadsheet-like data editing capabilities in SvelteKit.
  • Installable SvelteKit App with Web App Manifest: Shows how to create an installable SvelteKit app with a web app manifest.
  • Lazy Loading for slowly loading pages in SvelteKit: Explains how to implement lazy loading for slowly loading pages in SvelteKit.
  • Upload, Store and Retrieve Images in SvelteKit (with SQLite): Shows how to handle image uploads, storage, and retrieval in SvelteKit using SQLite.
  • Generate a PDF with pdfmake (from SvelteKit): Guides on generating PDF documents using pdfmake in SvelteKit.
  • Interactive Tables in SvelteKit with TanStack Table: Demonstrates how to create interactive tables using TanStack Table in SvelteKit.
  • Export Table to XLSX and CSV with exceljs: Shows how to export tables to XLSX and CSV formats using exceljs in SvelteKit.
  • MailCrab: Mock Mailserver for development: Introduces MailCrab, a mock mail server for development purposes.
  • Server-side filtered, paginated and sorted Table in SvelteKit (Part 1/2): Explains how to implement server-side filtering, pagination, and sorting for tables in SvelteKit (Part 1/2).
  • Server-side filtered, paginated and sorted Table in SvelteKit (Part 2/2): Continuation of the previous tutorial, covering the remaining aspects of server-side filtering, pagination, and sorting for tables in SvelteKit (Part 2/2).
  • SvelteKit TanStack Table edit row (+ custom table components): Demonstrates how to edit rows in a table using TanStack Table in SvelteKit, along with custom table components.
  • Markdown in SvelteKit with custom Components: mdsvex: Explains how to use markdown in SvelteKit with custom components using mdsvex.
  • Accessible charts only with CSS? - Charts.css: Discusses the possibility of creating accessible charts using only CSS, with a focus on Charts.css.
svelte
Svelte

Svelte is a modern front-end framework that compiles your code at build time, resulting in smaller and faster applications. It uses a reactive approach to update the DOM, allowing for high performance and a smoother user experience.

vite
Vite

Vite is a build tool that aims to provide a faster and leaner development experience for modern web projects

eslint
Eslint

ESLint is a linter for JavaScript that analyzes code to detect and report on potential problems and errors, as well as enforce consistent code style and best practices, helping developers to write cleaner, more maintainable code.

typescript
Typescript

TypeScript is a superset of JavaScript, providing optional static typing, classes, interfaces, and other features that help developers write more maintainable and scalable code. TypeScript's static typing system can catch errors at compile-time, making it easier to build and maintain large applications.