Hi guys, do you know if it possible to use encryption with sqldelight?

I do not think that SQLDelight has encryption itself. Usually, the encryption is in the SQLite implementation (e.g., SQLCipher, SEE). Somebody would need to create SQLDelight drivers for that SQLite implementation. In the specific case of Android,

AndroidSqliteDriver

uses the Jetpack

androidx.sqlite

API, so you should be able to use it with SQLCipher for Android by supplying your own

SupportSQLiteOpenHelper

or

SupportSQLiteOpenHelper.Factory

to the

AndroidSqliteDriver

constructor.

There's an exemple there: https://github.com/commonsguy/cwac-saferoom

Thanks @Mark Murphy and @mbonnin

Note that SafeRoom is no longer necessary. The current version of SQLCipher for Android supports the

androidx.sqlite

API directly.

For native, we have a ticket to create a sample using sqlcipher and sqldelight on ios. Possible, but may need some effort to make “simple”