Core Data support

[chbeer]

Using something like this on Kotlin side:

• Room
• NexusData
• ORM Lite
• Green DAO

[marcprux]

We do currently have SkipSQL for low-level access to SQLite databases, along with some sample apps like DataBake that demonstrates how the library can be used in an app.

We don't currently have any higher-level ORM solution. We are considering the best approach. Porting all of Core Data is unlikely for various reasons (such as assumption of an Objective-C environment), but implementing SwiftData has been considered, or else a third party solution like GRDB.swift. Those Android libraries you mention are also good suggestions as well – Room is clearly popular, and has many nice features.

We would be interested in hearing the feedback and insights of the community into what features and levels of abstraction they would like to see. Every ORM is a series of trade-offs, as the Skip development teams is acutely aware: we created the original OpenJPA project ages ago. So please do use this thread to let us know what you would like, and what you would not like, to see in any dual-platform ORM solution we might eventually bring to Skip.

[aehlke]

But if that's too much work because there's no 1:1 analog (although I bet there are if you constrain models with some data type limitations etc) on Android/elsewhere, it would also be great to have GRDB rather than have to adopt SkipSQL which is a new lib that few have experience with yet. But SwiftData would really be ideal as it's clearly the future (though it's going to take years to mature)

[marcprux]

Both GRDB.swift and SQLite.swift are excellent projects, and they could probably be adapted to work on top of SkipSQL with a bit of effort. Interested has been expressed, but we haven't yet seen any community initiative towards this.

[aehlke]

I see you've integrated SQlite.swift - nice to see progress there. Unfortunately it's lacking things that GRDB has such as iCloud sync via CKSyncEngine (via Harmony), and change notifications. Its original author recommends GRDB these days, and performance-wise it's the furthest behind GRDB and Lighter-swift

[marcprux]

Agreed that SQLite.swift and GRDB are different levels. The SQLite.swift module exists as part of swift-sqlite primarily as a conduit to the native SQLite C build.

We don't have concrete plans yet to work on GRDB, but the native Swift toolchain side might ease the process of getting it working.

[aehlke]

Thank you for the update I realized that's why after reading the code. Telegraphing what more productionized DB you might pick first helps with starting projects early before it lands, understanding plans and roadmaps change continuously with the work... Understood there's nothing to update on that but very interested in following updates on whatever tool you choose first (more so than any particular one)