We conclude our series on modern persistence and callbacks by showing how we can call back to Swift from a database trigger. We will take advantage of this by improving the ergonomics of two features in our Reminders application.

Get all the details in our episode from this week:.

This week we show how to invoke Swift code from SQL triggers, which allows you to react to any event in your database. We use this to add throttling to our Reminders app so that you can complete many reminders quickly without them immediately animating away. More info in 🧵

RT @VadimKrutov: @pointfreeco Guys thank you so much. The amount of things I learned during these series is just tremendous. 🙏.

Next week we will push things even *further* by calling Swift code *from* SQLite! We will use these database callbacks to improve the ergonomics of our rewrite of Apple’s Reminders app. See you then!.

This week we show how we can push our app’s validation logic to the *database* using triggers. This ensures data integrity no matter what feature is interacting with the backend database. Learn more:

The best place to validate your app’s data is at the database!. Triggers give you a single, central place to prevent invalid state from ever entering your app’s domain. Learn how in this week’s episode:

RT @pointfreeco: SwiftUI makes it easy to implement validation logic for forms directly in the view. But you know what’s better than that?….

Learn about one of the most powerful ways to enforce data validation in your apps:.

SwiftUI makes it easy to implement validation logic for forms directly in the view. But you know what’s better than that? Enforcing validation directly in the database so that every view shares the same validation logic. SQL triggers make this extremely easy!. Details in the 🧵

We show how to use database triggers to provide global validation logic to our application that will never allow invalid state from ever entering our user's data. 👉

RT @pointfreeco: We just released a significant update of our StructuredQueries library:. • Support for generated columns (which are like c….

We just released a significant update of our StructuredQueries library:. • Support for generated columns (which are like computed properties, but for SQL!).• Table.none, similar to the Rails helper of the same name, for generating “empty” queries. And more!

Our popular “Modern Persistence” series now has a new section specifically about SQL triggers. We've already seen some really great applications of this tool, but we've barely scratched the surface. Find out more 👇

RT @pointfreeco: Big updates to our SQLite+CloudKit private alpha!. Our library now supports foreign key constraints! Protect the integrity….

We've got a massive test suite of thousands of lines of code that test many of the intricate scenarios that come up in synchronizing across devices. • What happens when two devices edit a record at the same time?.• What happens when child records are received before the.

Big updates to our SQLite+CloudKit private alpha!. Our library now supports foreign key constraints! Protect the integrity of your data while distributing it across many devices. And we support more kinds of primary keys, such as UUIDv7 and more!.

Watch this week’s video to learn how: