Post

How many of us have learned that the hard way? I sure did a few years back.

To be clear though, you can actually have SQLite dbs (treated as regular files) in the app group container. You just can't open them there. I copy to and from as a syncing mechanism between share extension and main app. Works great.

Ryan Ashcraft

@ryanashcraft.com

Interesting solution. When do you do the copy? Are you always copying one to the other, or bidirectionally?

14/5/25, 4:39 pm0 reposts1 like

None of the mitigations worked for me, & I tried everything over a couple of years. When I finally admitted defeat, I implemented this solution in short order, & I haven't thought about it since. There are tradeoffs, but the extension really doesn't need access to gigabtyes of cached emails.(4/4)

Also, I've always used multiple small compartmentalized dbs where others might use tables. This allows for a smallish subset of synced dbs. Copy to shared dir is done in background with backup, vacuum, checkpoint, journal-mode-delete, & then,for good measure, removal of any -wal or -shm files.(3/4)

A full sync from main based on mod times is done periodically (once per day). Individual dbs are copied after relevant updates. I can't recall why I don't sync on app suspend, but I suspect I ran into same issue. (2/4)