Joshua Nussbaum/Database apps with SvelteKit

  • $49

Database apps with SvelteKit

  • Course
  • 34 Lessons

Data is a critical part of every application. When it comes to SvelteKit, Prisma is a great option. This course will teach: - The basics of Prisma. - How to define models and migrate your database. - How to deploy your app to the cloud. - How to query and filter data. - Working with relationships: 1-to-1, 1-to-many, and many-to-many. - How to create and validate forms. - All examples using SvelteKit!

Contents

Welcome

Welcome
Preview

Links

Code

Introduction

What is Prisma?
Preview
Project setup
Preview
Defining models
Preview
Centralizing the client
Seeding the database

CRUD

Create
Read
Update
Delete
Upsert

Forms and validation

Validating the schema
Extracting a form helper
Creating a re-usable validation function

Searching, sorting and paging

Searching and filtering
Sorting data
Paging data

Relationships

Defining relationship schemas
Linking related records
Adding UI for related models
Querying related data

Transactions

Performing operations atomically
Atomically executing a function

Aggregation

Counting, averaging, and summing
Grouping data

Deployment

Switching to database migrations
Deploying to Vercel
Migrating with branches

Bonus: Advanced features

Generators
Extensions
Middleware

Links

Bonus: Cheatsheet
Source code