Hi everyone, I’m looking for an official or community-supported solution for implementing an encryp...

# multiplatform

[ptsiogas]

Hi everyone,

I’m looking for an official or community-supported solution for implementing an encrypted database in a KMM project that works on both Android and iOS, ideally using shared/common code.
From what I’ve seen, SQLDelight appears to support this to some extent, but I haven’t been able to find any up-to-date or complete guides for setting it up across both platforms, especially with encryption.
If anyone has recommendations, working examples, or best practices for this setup, I’d really appreciate it!

Thanks in advance!

[R Suman Radhakrishnan]

Please check this. I used SQLDelight for encryption and decryption in CMP. It seem to works in my case.

RoomEncryptionDecryption (1).zip

[ptsiogas]

Will check, thanks a lot

[Chrimaeon]

FYI https://blog.jetbrains.com/kotlin/2023/07/update-on-the-name-of-kotlin-multiplatform/

[jw]

Encryption happens below SQL Delight, so it doesn't really know (or care) whether or not you are using an encrypted DB.

[ptsiogas]

Thanks @jw! That makes sense, I understand that SQLDelight itself is agnostic to the underlying SQLite implementation, including encryption.
That said, would it be feasible (or reasonable) for SQLDelight to offer a built-in way to configure encrypted drivers?
Right now, it feels like there’s a bit of a gap between what SQLDelight generates and how encrypted drivers need to be wired up manually, especially on iOS.

Disclaimer: I’m bringing this up specifically because SQLDelight is the #1 go-to solution for database implementation in Kotlin Multiplatform projects, and it’d be amazing if it could also help standardize encryption workflows across platforms.

[eygraber]

I haven't done it on ios yet, but on Android it is relatively simple to wrap around SqlCipher. I've been meaning to make a library for this for a while now, but I haven't had the spare time.

[jw]

I would not count on SQLDelight offering anything in this space.

[ptsiogas]

Thanks again to everyone who shared insights earlier.

We ended up building a solution using Room and SQLCipher. In the article below you can find instructions and a working example.

In case it helps others exploring the same path, here’s the write-up and example repo:
https://desquared.notion.site/Encrypted-Room-Database-in-Kotlin-Multiplatform-KMP-for-Android-iOS-25b9aac7b816801b9067c627602335c6

Always open to feedback or ideas to improve it.