I've written an iPad app for personal budgeting using SwiftUI. I started this app many years ago before SwiftData and even before CoreData. The app uses an SQLite database using FMDB as the api to support database activities and all of the data manipulation language is my own SQL.

I'm a retired software developer and the last 11 years of my career I was in an IBM WebSphere (Java) and Oracle DB environment. So I had experience with this kind of development.

I've started working on the iPhone version of the app and am currently working on the UI changes needed. As of this writing it will be a separate app in XCode with the underlying database code in common.

Of course I'd like to sync the data across both applications. I've seen, read, and watched articles on using CloudKit with SwiftData and CoreData, but I haven't been able to gleen if this is doable with my own version of an SQLite db.

I'd appreciate any info you can give me on if this is possible and where I should begin.