SvelteKit 1.0 with SQLite Tutorial

Code: https://github.com/phartenfeller/sveltekit-1.0-sqlite-demo-app/tree/tut-1-sqlite
Sample Database: https://www.sqlitetutorial.net/sqlite-sample-database/

Follow me:
Twitter: https://twitter.com/phartenfeller
Mastodon: https://mastodon.social/@phartenfeller
Blog: https://hartenfeller.dev/blog

Support me:
https://www.buymeacoffee.com/hartenfeller
https://paypal.me/phartenfeller

In this tutorial we will build a small music app with Svelte Kit 1.0 and SQLite. I go into detail on how to setup the database connection, how we can load the data on the server and consume it in the frontend. We will create custom routes for each album and make it editable via a form. I go into detail about error pages and last show how we can create an API-Endpoint with Svelte Kit that we can consume from the frontend.

Timestamps:
0:00 Intro
01:10 Setup SvelteKit Project
03:34 Setup SQLite DB Conneciton
13:31 Load Data from the Server
17:31 Improve Page Markup and Styles
20:43 Create Route for Albums
28:51 Error Handling
32:35 Update Album / SvelteKit Form Actions
40:07 Server-Side Search with API-Endpoint