Noticed different behavior in a couple of text fields with number formatters. On one I could type an aperture (e.g. 5.6) and it only finalizes the formatting on submit. The other is greedy and tries to format as you type, so that 5.6 ends up as f/56.

I tracked it down to different flows for handling selection. The misbehaving one has a direct database query in the view, so I think when the model changes the view invalidates, and the text field formats

#SwiftUI #GRDB

Fixed the build of GRDB on Linux and now trying to fix the failing tests. More than 400 tests are failing so it was difficult to see which tests were, but luckily I found:

https://github.com/cpisciotta/xcbeautify

#swift #swiftlang #linux #grdb #sqlite

🚀 I've just shipped #GRDB v7.6.1, that fixes a race condition introduced three days ago in v7.6.0: Please upgrade!

Version 7.6 makes it possible to access Task locals from async database accesses. This improves GRDB integration with toolings that rely of Task locals. For example, your tests can now use the #‍expect macro from within an async database access.

New blog post: Caveats Using Read-only SQLite Databases from the App Bundle

https://twocentstudios.com/2025/06/07/sql-databases-bundle/

A quick debugging story where I learned some new things about SQLite's journal mode while building an database export/import feature for Eki Live.

TLDR:

- Journal mode is embedded in the sqlite database file itself.
- The `backup` command changes the journal mode of the target database to match the source database.
- Check the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode;"`.
- Change the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode=DELETE;"`.

#sqlite #grdb

Just loving the SharingGRDB framework! The @pointfreeco guys really modernized swift persistence: https://github.com/pointfreeco/sharing-grdb

#swift #swiftlang #grdb #sqlite #persistence #iOSDev