SQLiteData Part 1: Setup, Schemas and Seeding Data

Discover SQLite Data - the robust alternative to Swift Data created by the developers at PointFree. In this comprehensive tutorial series, we'll build a complete gift registry application with CloudKit synchronization that works seamlessly across iPhone, iPad, and Mac.
In Part 1, we lay the groundwork by setting up SQLite Data in your Xcode project and creating our first Person model with a proper database schema. You'll learn how to bootstrap your database, work with migrations, create seed data for SwiftUI previews, and understand the fundamentals of structuring relationships in SQLite.
What you'll learn in this video:

• Setting up SQLite Data from the GitHub repository
• Creating models using the @Table macro
• Bootstrapping your database with proper dependency management
• Writing SQL migrations to create database tables
• Setting up preview data for development
• Viewing your SQLite database with DB Browser

This series is perfect for developers who want more control over their data persistence layer, need CloudKit sync capabilities, or are looking for alternatives to Swift Data. We'll eventually cover one-to-many and many-to-many relationships, CloudKit synchronization, and even sharing features.

Full Series Playlist: https://www.youtube.com/playlist?list=PLBn01m5Vbs4CYoNYe55G1kijxeNza9SMe

If you want to support my work, you can buy me a coffee :)
https://ko-fi.com/stewartlynch/

My Newsletter
https://stewartlynch.kit.com

Channel Listing Mac App (Free)
https://stewartlynch.gumroad.com/l/obsjz

Channel Listing Web App 
https://stewartlynch.github.io/YouTube/

Table of Contents: 
0:00  Introduction
2:32 Entity Relationship Diagram - What we are building
4:00 The Person Model
7:00  Bootstrapping the Database
9:43 Database Migration
16:32 Viewing the Database
21:07 Seed Data for Previews
25:30 Fetching and Displaying Data

Starter Project: https://github.com/StewartLynch/SQLite-Data-Gift-Register

Completed Source Code: https://github.com/StewartLynch/SQLite-Data-Gift-Register/tree/Part1Completed

References mentioned in video: 
Point-Free Site: https://www.pointfree.co

SQLiteData Info: https://www.pointfree.co/blog/posts/184-sqlitedata-1-0-an-alternative-to-swiftdata-with-cloudkit-sync-and-sharing

SQLiteData Documentation: https://swiftpackageindex.com/pointfreeco/sqlite-data/main/documentation/sqlitedata

SQLiteData Package: https://github.com/pointfreeco/sqlite-data

DBBrowser for SQLite: https://sqlitebrowser.org

Seed Data Gist: https://gist.github.com/StewartLynch/ae1ec1b103042ba0789e9bb58e58bc10
Recommended Resources: 
Big Mountain Studio Books 
AI Mastery in SwiftUI
https://www.bigmountainstudio.com/ai-mastery/77jt8
SwiftUI Views Mastery
https://www.bigmountainstudio.com/advanced-views/77jt8
Advanced SwiftUI Views Mastery 
   https://www.bigmountainstudio.com/advanced-views/77jt8
SwiftUI Animations Mastery
https://www.bigmountainstudio.com/animations/77jt8
SwiftData Mastery in SwiftUI 
   https://www.bigmountainstudio.com/swiftdata/77jt8 
Combine Mastery in SwiftUI 
https://www.bigmountainstudio.com/combine/77jt8
SwiftUI 5 Book Bundle 
   https://www.bigmountainstudio.com/book-bundle/77jt8

Видео SQLiteData Part 1: Setup, Schemas and Seeding Data канала Stewart Lynch