Spotted this MPP for Sqlite by <@U0B98KWF4> <https...

# multiplatform

[louiscad]

Spotted this MPP for Sqlite by @yigit https://github.com/yigit/kotlin-sqlite-bindings
Makes me think about @Dominaezzz project https://github.com/Dominaezzz/kotlin-sqlite

Maybe a joint effort can be done, or at least sharing some inspiration?

[gabin]

Does that mean that library like Room could be possible to use on other platforms ?

[louiscad]

Library like Room: There's already SqlDelight doing it with https://github.com/touchlab/SQLiter

SqlDelight is a different approach though: You write the SQL, it generates most of the Kotlin, while Room lets you write some of the Kotlin, and generates the implementation with SQL queries.

[louiscad]

Also, @gabin : https://twitter.com/yigitboyar/status/1266169846691028993?s=21

[gabin]

wow, sounds promising

[kpgalligan]

SQLiter uses a different approach. Early on I figured directly linking to C++ would be a supported option, but it’s not really. SQLiter links to the Kotlin/Native runtime directly. It works fine, but is more of a support hassle. The library itself isn’t very user friendly, but it’s not really designed that way. Using cinterop has been on the maybe list for a while. To discuss.

[Dominaezzz]

I've been planning JVM bindings for a while but haven't gotten around to it.

[kpgalligan]

Same

[kpgalligan]

Android won’t let you bind to it’s sqlite, so the incentive wasn’t super high.

[kpgalligan]

You’d need to ship a different sqlite version