A modern programming language that makes developers happier.

kotlinlang

Hi guys!

I’m using `SQLDelight` in Android and iOS with `kotlin-multiplatform` and looking for a way to somehow encrypt the underlying database file.
Has anyone here done something like this before?

I don’t have much experience with `SQLite`, but as I’ve noticed there are ways to encrypt the stored data with `SQLCipher` but apart from this old issue I couldn’t find any clues how I could integrate it with `SQLDelight`: <https://github.com/square/sqldelight/issues/566>

Also I’m thinking that maybe in my use-case it wouldn’t be too important to encrypt every row, it’s enough if I could just secure the database file. By somehow making sure that only the database driver can open the file. Or maybe loading it in memory from an encrypted file and storing it back after a transaction is finished.
I don’t know if that makes sense, I’m just looking for the easiest way to provide some security for the database.