One of the most difficult parts of distributing your user's data across multiple devices is handling when devices have different versions of the schema. Our SQLiteData library handles this seamlessly behind the scenes without you having to think about it. Quick demo here 👇

SQLiteData now lets you define your own custom aggregate functions in Swift. Simply add the @‌DatabaseFunction macro to a function that operates on a sequence of values: www.pointfree.co/blog/posts/1...

It is positively addicting to watch data flowing from a device in a test vehicle to a device on my desk in real-time. Outstanding job on this implementation. I wish I had a job because I would surely be in line for a huge raise for adding this amazing feature.

Watched this new episode and had CloudKit synchronization up and running in about 10 minutes. I previously had converted all my integer IDs to UUIDs so other than removing a unique constraint, it compiled and started syncing right away.

How are conflicts handled in our SQLite+iCloud synchronization tools? We use a “last edit wins” strategy on a per-field basis. This means if you edit the title of a reminder on one device and the notes on another, it will all merge cleanly.

Adding iCloud synchronization to your app can introduce hidden complexity. It may seem like your app isn't sending data to or receiving data from iCloud. That's why our SyncEngine logs detailed messages, so you know exactly what is happening under the hood.

This tip is just one of many from this week’s video. Watch today: www.pointfree.co/episodes/ep3...

Did you know you can bind a SwiftUI text field to a URL? The simplest way is with a custom computed get/set property, which allows you to derive a binding via dynamic member lookup:

Would you believe that adding iCloud sync to an app can be as simple as adding a single line of code? It’s true! The following video shows how: www.pointfree.co/episodes/ep3...

The “SyncEngine” seamlessly synchronizes data to and from iCloud, resolves conflicts when records are edited and deleted concurrently from many devices, and can even synchronized records across different app and schema versions. Watch how: www.pointfree.co/episodes/ep3...

SQLiteData 1.1 introduces powerful new domain modeling tools that put you in control of the structure of your model types. Instead of describing your table as a flat struct with a property per column, you can nest groups of columns into structs (and even enums!) of their own.

Have you wanted to know what it takes to build an app using modern persistence techniques? This means using structs and enums instead of classes, bringing SQLite to the forefront instead of abstracting it away, and multi-device synchronization that just works. Well… pointfree.co/pricing

We are finally putting the “modern” in our “Modern Persistence” series by showing what it takes to start synchronizing your user’s data to all of their devices. Follow along here: www.pointfree.co/collections/...

SQLiteData offers seamless iCloud sync, but only if your schema is designed with synchronization in mind. If not, you could have 100s of lines of migration code ahead of you. Luckily version 1.1 brings a brand new tool to automate this work in a single statement:

To synchronize a SQLite database to CloudKit each table must have a globally unique primary key (e.g. auto-incrementing ints do not work). It can be quite the slog to migrate a database to meet these requirements, but on Point-Free we don't shy away from this kind of real world messiness!

We went above and beyond with our SQLite+CloudKit sync tools by supporting foreign key constraints. This allows you to embrace data integrity in an integrity hostile environment (i.e. distributed schema).

How easy is it to add iCloud sync to an app? A single line? Hundreds? Depends on how your database schema is designed! We get our hands dirty and show that even in the messiest of situations there is a clear path forward, and we can even make it quite nice. www.pointfree.co/episodes/ep3...

I held off adding CloudKit support, now it pays off in spades with having the experts putting me in the fast lane to getting this done. I’m so lucky I should go buy a lottery ticket.

How do you take an existing app that was not built with iCloud sync in mind and prepare it for synchronization? Luckily you don’t have to fly in the dark! We have pages and pages of documentation at hand, which we refer to throughout our walkthrough: www.pointfree.co/episodes/ep3...

How easy is it to add iCloud sync to an app? A single line? Hundreds? Depends on how your database schema is designed! We get our hands dirty and show that even in the messiest of situations there is a clear path forward, and we can even make it quite nice. www.pointfree.co/episodes/ep3...

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.

SQLiteData, the alternative to SwiftData, keeps getting better and better! We have released some brand new features: Column groups and model “inheritance”. These tools allow you to better model your domains while still playing nicely with SQLite. www.pointfree.co/blog/posts/1...

We uncovered a small bug with assets not being updated correctly in our CloudKit tools. But thanks to our recreation of CloudKit databases and containers for testing purposes we were able to write a failing test and fix the problem: github.com/pointfreeco/...

No new episode this week, but next week we take our “Modern Persistence” series to the next level. In the meantime, we will have several fun announcements to make throughout the week, and you can catch up on our SQL mega series here: www.pointfree.co/collections/...

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.

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.

This is just a lovely api, turning swift strongly typed APIs into safe SQL queries: swiftpackageindex.com/pointfreeco/...

This week we finished our series on “Modern Search”, where we demonstrate how to use SQLite full-text search to its full potential for adding complex and advanced search functionality to an app. Check out the full series today! 👉 www.pointfree.co/collections/...

What's new in SQLiteData: Database views! We now provide powerful, type-safe and schema-safe tools for creating, querying and updating database views in SQLite. It's the perfect tool to share database logic with many parts of your app! www.pointfree.co/blog/posts/1...

These 35 lines of code power full-text search in our Reminders app rewrite, and they pack a punch! 🏷️We tokenize tag 📍and term proximity 🏅Results are ranked 🖍️and matches are highlighted! Watch us build it all from scratch in our series on “Modern Search” in Swift: www.pointfree.co/collections/...

Another important tool we use in SQLiteData 1.0 is the battle-tested GRDB (by @groue.bsky.social) for querying and observing changes to the underlying SQLite database. Any app using GRDB can start syncing their database to CloudKit with just a few lines of code! github.com/groue/GRDB.s...

SwiftUI’s searchable tools provide built-in support for tokenization, which allows us to expose advanced full-text search functionality in a way that is friendly to the user. Learn how to leverage these tools in this week’s episode: www.pointfree.co/episodes/ep3...

Another foundational tool we use to build SQLiteData is CKSyncEngine from CloudKit. In fact, we use two! One for the private database and one for the shared database. This gives us everything we need to batch+send changes to CloudKit, as well as observe changes from CloudKit.

The thrilling conclusion to our ”Modern Search” series is here! We round things out by diving into FTS5’s query syntax language. We’ll learn how it works and use it to introduce SwiftUI search tokens that can refine a query by term proximity and tags. 👉 www.pointfree.co/episodes/ep3...

One of the most important tools we use to build SQLiteData 1.0 is triggers. They allow us to observe all changes to your tables in order to synchronize to CloudKit. The triggers are very complex, but thanks to our type-safe and schema-safe query tools we are able to write these without fear!

We are happy to see our SQLiteData 1.0 release resonating with folks! 🌟 Check out our CloudKit-friendly, SQLite alternative to SwiftData today: github.com/pointfreeco/...

Supporting CloudKit sync for SQLite is a daunting task. There are edge cases and nuances to be aware of, and the risk of introducing subtle bugs that cause data loss is very real. Here’s the most important technique we used to build this feature 🧵 www.pointfree.co/blog/posts/1...

It's hard to measure the amount of time we put into the release of SQLiteData 1.0. We've been working on this since April, with hundreds of hours of development, hundreds of hours of debugging. github.com/pointfreeco/...

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

We're taking a break from episodes next week because we have a big announcement (👀), but then the week after that we will have the thrilling conclusion to our ”Modern Search” series of episodes. Until then, catch up on all the action here: www.pointfree.co/collections/...

The reviews are in for our “Modern Search” series, covering everything you need to know to be effective with full-text search. And we have one big episode left in the series. 😯 www.pointfree.co/collections/...

SQLite's full-text search module provides 'snippet' and 'highlight' functions for bolding the search matches and focusing in on just the matches of a large document. In the screenshot below, the leading characters of the notes are trimmed because the search terms match at the end. 🤯

Apple’s not the only one with a big upcoming release! Transparent CloudKit synchronization is the product of many months, many pull requests, and issues and feedback from many beta testers. We couldn’t be more excited to share it with everyone! github.com/pointfreeco/...

SQLite’s full-text search capabilities come with many bells and whistles, including support for highlighting search term matches in your UI, as well as generating snippets for where matches appear in a larger corpus. Let's explore each of these tools in-depth. 👉 www.pointfree.co/episodes/ep3...

We have shown how to create a virtual table for a full-text search index and how to fine-tune search queries using advanced tools. Next we show now to improve the UX of our app by highlighting and making snippets of our documents that focus on matched search terms. www.pointfree.co/collections/...

We can customize how full-text search weighs your data to fine-tune searches. For example, we can make matches in the title of a reminder count for more than matches in the notes, and make notes count for more than matches in the tags. Learn how: www.pointfree.co/episodes/ep3...

Calling Swift functions from SQLite is incredibly powerful, and we've just made it easier than ever with a brand new @‌DatabaseFunction macro. Get all the details here: www.pointfree.co/blog/posts/1...

This week is where full-text search really shines. It sorts matches by relevancy based on many factors, such as frequency and position of matches, document length, and more. We get access to all of that with just one simple SQL clause: ORDER BY rank 🤯 www.pointfree.co/episodes/ep3...

Let’s take advantage of the superpowers of full-text search, starting with relevancy. We will explore the ranking algorithm of SQLite’s FTS5 module, see how documents are scored, and how we can tweak the scores based on the column containing a match. www.pointfree.co/episodes/ep3...

Next week we explore how to fine-tune some of the more advanced aspects of full-text searching, such as results ranking. This will allow us to scores matches in a reminder's title a little higher than in its notes or tags. Until then, catch up here: www.pointfree.co/episodes/ep3...