Point-Free Videos

🔒 We add a geofence to the `Trip` model and explore advanced features of SQLite, including JSONB and `json_each`, which allow us to efficiently store and query this data. And we will show that not all bundles of data need to be JSON: we are free to group our database columns among as many data types as we like.

🔒 We explore how encoding data to JSON does not hinder our ability to query it from SQLite's powerful tools. We can filter, sort, and even _section_ results by location data stored as JSON in a table column, and all with type safe and schema safe guarantees at compile time.

🔒 SwiftData has a brand new `sectionBy` API, for grouping the results of a `@Query` into sections. So what is SQLiteData's solution to this problem? Well it turns out SQLiteData's tools supported sectioning from day one, and much more. We'll show just how far these tools can take use before introducing an ergonomic API to match SwiftData's.

🔒 We compare SwiftData's new features with SQLiteData, starting with a domain modeling exercise. We will rewrite the Trips `@Model` classes into simple `@Table` structs, and we will explore how the `Draft` type can power a single form for both creating and updating trips.