This gives you the benefits of “single-table inheritance” for SQLite tables without the pain of actual class inheritance! 😂 It lets you fully use Swift's powerful domain modeling tools for you database, such as structs and enums.

Our most recent library, SQLiteData, embodies this principle. It pre-supposes: what if I don't want to massively refactor my codebase just because at some point I need to write a bit of code outside of a SwiftUI view 🤪 github.com/pointfreeco/...

Tired of the “To MVVM or not to MVVM” discussions that plague our community? Us too 😅 That’s why we build tools that work in SwiftUI views, @‌Observable models, UIKit, AppKit, Linux, and more! You should build your app in the way that makes the most sense for you and your team.

It’s finally here: SQLiteData 1.0: a fast, lightweight replacement for SwiftData with full CloudKit support. www.pointfree.co/blog/posts/1...

SwiftData offers a promise of simple persistence with easy synchronization. We feel it currently falls short of that goal, but in the fullness of time it may achieve it. But, for the present, we are working on tools that achieve SwiftData's promise, and honestly a lot more.

Next week: We are hosting a live stream where we will preview some fantastic new features coming to our SQLite persistence library, including CloudKit sync and sharing, and answer your questions! Submit your questions *today* 👇 www.pointfree.co/blog/posts/1...

That's right. You can have the best of both worlds. You get unfettered access to SQLite, a fantastic technology that has stood the test of time, while behind the scenes every change is synchronized across devices using CloudKit. Seems almost too good to be true!

We've had a major breakthrough in the most requested feature of our SwiftData alternative: SharingGRDB. More details coming soon... 👀

We finish the lists feature of our Apple's Reminders app rebuild. We introduce advanced queries including counts and custom data types. And we show how “drafts” allow us to create and update lists using the same view while keeping the domain as precise as possible. www.pointfree.co/episodes/ep3...

Announcing a toolkit that provides a SwiftData-like experience to SQLite: SharingGRDB with StructuredQueries. www.pointfree.co/blog/posts/1...

Don't miss out on our exciting series that designs this SQL building library from scratch! We explore many advanced topics of Swift along the way, as well as a crash course in SQL and databases! www.pointfree.co/collections/...

This query is traversing a recursive one-to-many relationship in SQL (Category belongs to parent Category) to print out the hierarchy of categories. Why do this work in application code when SQL can knock it out efficiently in just a few lines??

We add sorting to our SQL builder, which will give us a powerful, succinct syntax for controlling the order of results. We will start small but build up to parameter packs and even a custom result builder to get the most flexibility out of our API. www.pointfree.co/episodes/ep3...

Even in a Swift query builder scares you, there is nothing stopping you from writing raw SQL with a static description of your database schema!

Some have expressed skepticism over using our upcoming query builder vs. writing raw SQL. Well our library lets you pick your poison! Both options are schema-safe and safe from SQL injection, but one is further type-safe and guaranteed to generate valid SQL:

We now have a type-safe syntax for generating SELECT statements using key paths, but we can do better. Let’s introduce a more advanced syntax that leverages variadic generics and supports more complex query expressions. www.pointfree.co/episodes/ep3...

While building our SQL building library we have created a state-of-the-art testing tool that allows us to simultaneously snapshot the SQL generated by the library, and the results fetched from the database.

Imagine a SQL building library for which it is easy to define query fragment helpers that can be pieced together in all kinds of interesting ways. That is exactly what we are building, and this week we give a sneak peek of the library: www.pointfree.co/episodes/ep3...

A tricky part to domain modeling with SQLite is how to handle auto incrementing primary keys. You are forced to use optional IDs, but that leaks complexity throughout your app and complicates Identifiable conformances. Our @Table macro handily fixes this by generating a Draft type with no ID.

Swift 6.1 brings meta type key paths to the language, and that unlocks a new level of composability in our SQL building library. You can chain together multiple static helpers to build complex queries. Watch us do this live in this week's episode: 👉 www.pointfree.co/episodes/ep3...

This is an incredibly powerful library that simply would not have been possible to build in Swift from a year ago. We are very excited to dive deep into this in our next series of episodes!

Watch us live code a complex query to fetch all reminders that are high priority, or flagged, or has the tag "#kids" associated with it. This requires a complex subquery that is not easily accomplishable in SwiftData. Get all the details here: www.pointfree.co/clips/105827...

Our livestream is now up! • We discuss advanced uses of our Sharing library: Firebase and Wasm • We release a brand new library: SharingGRDB, an alternative to SwiftData • We preview a new library: StructuredQueries • And we answer dozens of viewer questions! 👉 www.pointfree.co/episodes/ep3...

In today's livestream we announced a brand new open source library: SharingGRDB. It's an alternative to SwiftData that gives you direct access to SQLite, works in UIKit, @​Observable models and SwiftUI views. Oh, and it back deploys to iOS 13 😲 www.pointfree.co/blog/posts/1...

Reminder that we are going live in a few hours! We'll be discussing: 🤯 Advanced topics of our new Sharing library 🎉 Announcing a brand new open source library 👀 Sneak peek at our next episode series 🙋 Questions from our viewers www.pointfree.co/live

Our tools make it possible to execute multiple SQL queries in a single DB transaction, and then use that data directly in a SwiftUI view. This is more efficient and makes it possible to group related state together.

This week we finished an amazing series showing how to build a SwiftData alternative using simple SQLite. And the best part? All of these tools work going all the way back to iOS 13! 🤯 👉 www.pointfree.co/collections/...

We now have several features using SQLite via a simple property wrapper that offers the same ergonomics as SwiftData’s @‌Query macro, and it automatically keeps the view in sync with the database. Let's now see how to handle dynamic queries! 👉 www.pointfree.co/episodes/ep3...

Mark your calendars! Point-Free is hosting a live stream on Feb 14, 9am PST / 5pm GMT. We'll discuss our Sharing library as a modern persistence toolkit, a sneak peek at a new library we are working on, and we will take questions from our viewers! The Q&A is already open: www.pointfree.co/live

7 years ago today we launched Point-Free! What have been some of your favorite episodes, open source libraries, or moments since we launched? www.pointfree.co/blog/posts/1...

Learn about these advanced techniques in this week's episode: www.pointfree.co/episodes/ep3...

SQL is a powerful language and it's a bummer to put any abstraction over it that prevents access to all of its features. We are building tools that allow you to embrace a bit of abstraction where needed, but you always have access to all of SQL.

With just a bit of work you can switch from using JSON to persist your app's state to using a powerful SQLite database. Queries will define how your feature's access state, and they will automatically update if the database changes. 👉 www.pointfree.co/episodes/ep3...

Some say that trying to use Swift Data outside of a view (such as an @Observable model) is "fighting the framework". But the fact that @Query does not work outside of views is only a limitation of Swift Data, and an unneeded one. We build a tool similar to @Query, but it can be used anywhere!

By the end of this series we will have built a suite of tools that provide a lot of the functionality of Swift Data, except the tools can be used anywhere (@Observable models, UIKit, SwiftUI, ...) and are cross-platform (Windows, Wasm, ...). It will be incredible to see!

📢 Announcing: Swift Sharing 2 The latest release of our popular open source library includes better support for Swift concurrency and error handling! www.pointfree.co/blog/posts/1...

No new episode this week as we prepare for our next series (it's a doozy!), but we are excited to announce that our 4-part series “Tour of Sharing” is free for all to watch. Learn the basics of our new Swift Sharing library today! www.pointfree.co/blog/posts/1...

We’re ending the year with one last sale: 🎁 25% off your first year! Unlock access to hundreds of episodes on advanced Swift topics, as well as everything we have planned for next year. Don’t miss this chance to level up your skills! www.pointfree.co/blog/posts/1...

We’re running a 25% discount through the end of the year! Don’t miss out on everything we have planned for 2025. There have been rumors that we are working on tools that might replace your need for Swift Data and are cross-platform 😲. 🎁 www.pointfree.co/discounts/eo... 🎁

We released 4 brand new open source projects this year, 2 of which were first incubated inside the Composable Architecture and then later extracted. Find out more of what we accomplished in our 2024 Year-in-review: www.pointfree.co/blog/posts/1...

This is an overview of the topics we covered in 2024, and if we only covered half of these it would still have been a great year. @Observable, lightweight state sharing and persistence tools, UIKit, cross-platform Swift, Equatable/Hashable, SQLite, and more! www.pointfree.co/blog/posts/1...

To celebrate the holiday season and all we’ve done this year, we’re also offering new subscribers a gift: 🎁 25% off your first year of Point-Free: www.pointfree.co/discounts/eo...

You can also persist state to the file system with our @Shared property wrapper. Here we have an array of strings in a model such that any changes to it are saved to disk, and any changes on disk are synchronized to the state. Learn more in our Tour of Sharing: www.pointfree.co/episodes/ep3...

SwiftUI’s @‍AppStorage property wrapper is wonderful, but it’s only meant to be used in SwiftUI views. The @‍Shared property wrapper, however, can be used anywhere: views, models, view controllers…your imagination is the limit! See it all work in this week’s episode: www.pointfree.co/episodes/ep3...

@Shared, unlike @AppStorage, can be used anywhere, not just SwiftUI views! And it has some extra bells and whistles that make it easier to write maintainable Xcode previews and avoid potential bugs around “string-ly” typed keys and default values. Learn how: www.pointfree.co/episodes/ep3...

I may have misunderstood your original comment. When you say you want non-observable references in the environment, you are opening yourself up to this problem: gist.github.com/mbrandonw/ec... Changes to the class do not cause the view to update, and it's because the class is not observable.

We also have a demo of how to use '@Shared' with SQLite via GRDB. You can hold onto state in your features that is secretly backed by a SQL query, and changes to the database will automatically update the view: github.com/pointfreeco/...

Today's the last day to take advantage of our Cyber Monday sale! Get 30% off the next year of your Point-Free subscription, and explore advanced topics in Swift and SwiftUI with us! www.pointfree.co/blog/posts/1...

Thousands of developers are already using our Sharing library because these tools were originally released as part of the Composable Architecture over 6 months ago. During that time we have gathered important feedback that helped us make the tools what they are today!

“Sharing” is a brand new Swift library for sharing state throughout your application and to external systems like user defaults, the file system, and more. We tour the library starting with a comparison to a tool that inspired its design: SwiftUI’s @‍AppStorage. 👉 www.pointfree.co/episodes/ep3...