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

# multiplatform

[ciriti]

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

[Mark Murphy]

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.

[mbonnin]

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

[mbonnin]

(from https://github.com/cashapp/sqldelight/issues/1353#issuecomment-498248643-

[ciriti]

Thanks @Mark Murphy and @mbonnin

[Mark Murphy]

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

[kpgalligan]

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”