I know there is an example of sqlcipher in the kampkitsqlcipher github, but I can't find any examples of working with sqlcipher for ios there. Anybody experience with making calls sqlite3_open in multiplatform?

We generally use sqldelight to make db calls, but use sqlcipher rather than link with

-lsqlite3

on iOS. Sqliter (https://github.com/touchlab/SQLiter) manages the low level sqlite calls, and will work linked to either sqlite or sqlcipher. So, short answer, we have experience with it. Any particular questions?

Ah I see. We are using sqldelight on multiplatform already and right now we are implementing sqlcipher so we can handle migration of the db

Hmm. Migrating sounds maybe tricky. Also apparently my notifications are off as I didn't see this. Anyway, if you find anything interesting let me know. I'm doing a general rethink on sql stuff as I'm going to be digging around the sqldelight driver with an eye towards the new memory model, so might be a good time for anything else interesting.

Yeah, the logic for Android is done so I have something to follow, but the tricky part is translating that to ios, the pointers etc make it a bit tricky and trying to work with the file system. It's also a lot of hassle having to debug it since I need to build it without sqlcipher, then build again with sqlcipher. also need to change settings in the build.gradle because right now its being build differently to our current implementation for ios so its tricky for sure