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: • SQLite Data 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/SQLit... Completed Source Code: https://github.com/StewartLynch/SQLit... References mentioned in video: Point-Free Site: https://www.pointfree.co SQLiteData Info: https://www.pointfree.co/blog/posts/1... SQLiteData Documentation: https://swiftpackageindex.com/pointfr... SQLiteData Package: https://github.com/pointfreeco/sqlite... DBBrowser for SQLite: https://sqlitebrowser.org Seed Data Gist: https://gist.github.com/StewartLynch/... Recommended Resources: Big Mountain Studio Books AI Mastery in SwiftUI https://www.bigmountainstudio.com/ai-... SwiftUI Views Mastery https://www.bigmountainstudio.com/adv... Advanced SwiftUI Views Mastery https://www.bigmountainstudio.com/adv... SwiftUI Animations Mastery https://www.bigmountainstudio.com/ani... SwiftData Mastery in SwiftUI https://www.bigmountainstudio.com/swi... Combine Mastery in SwiftUI https://www.bigmountainstudio.com/com... SwiftUI 5 Book Bundle https://www.bigmountainstudio.com/boo...

SQLiteData Part 2 - CRUD Operations

SQLiteData Part 3 Observable Models and Dynamic Sorts and Searches

building million dollar saas live... vibecoding

Trump Attends NBA Finals, Cries Election Fraud in California & Storms Out of Interview

Nick Chapsas Is Right About Clean Architecture (Mostly)

Russian drones attack CNN 14x at Ukraine's 'Road of Life'

Malloc is NOT Magic: Let's Build it to Learn What's Inside!

Creator of C++: Bell Labs, Negative Overhead Abstraction, Mistakes | Bjarne Stroustrup

Tips for C Programming

Palantir and Switzerland – Between Data and Power | Reporter | SRF

Bambu Lab's AGPL Problem Just Got Worse

🚗 BYD : The biggest SCAM of the car industry ?

The Crystal That Could Destroy All Medicine

Why Everyone Is Excited About HTML In Canvas

99% of Developers Don't Get PostgreSQL

Building the PERFECT Linux PC with Linus Torvalds

How Netflix Uses Java - 2026 Edition

How Rockstar fit an entire city into PlayStation 2 memory

