hmmm, looks like getting sqldelight w/ encryption ...

# multiplatform

[Kris Wong]

hmmm, looks like getting sqldelight w/ encryption is going to be a challenge for K/N. anyone tried this?

[basher]

you mean linking a custom sqlite?

[Kris Wong]

sqlcipher, specifically

[basher]

a compile-time option?

[basher]

well in any case, if you need to link a custom sqlite, i know how to do that

[Kris Wong]

are you suggesting that's the solution?

[Kris Wong]

i'm not sure what other changes will be required on the native side. i haven't looked into it yet.

[basher]

oh sqlcipher is a replacement

[Kris Wong]

in theory the APIs are identical so it could be a drop in replacement

[basher]

yeah so linking custom sqlite it what you want

[basher]

in your sqldelight block in build.gradle, add linkSqlite = false

[basher]

then you'll have to update linker flags to link sqlcipher

[basher]

getting the linker flags right is the hard part

[basher]

and it varies based on how you distribute on the iOS side

[Kris Wong]

oh, it's static. i'd need to link library into the iOS app anyway. which means it may even be possible to just use sqlcipher instead.

[Kris Wong]

i'd think the exported symbols would match up. i guess i'll find out.

[Kris Wong]

gah. they don't match perfectly because you have to specify the key to the open function

[basher]

Could you build the library with an extra open function that calls the sqlcipher one passing the key hard-coded?

[kpgalligan]

It’s doable. Just need to sort out the details and write it up. I actually did this with j2objc and our custom driver

[kpgalligan]

Also looks like at least one person uses it: https://github.com/touchlab/SQLiter/pull/16

[Kris Wong]

i think the original sqldelight can be forked in a minimal touch way that makes it easy to pull in upstream changes

[basher]

Sqldecipher

[Kris Wong]

lolz

[kpgalligan]

Do you need a work of sqldelight, though?

[basher]

You shouldn't if you can stub in that open function

[Kris Wong]

well, I see it's actually using SQLiter for the native implementation, so still digging there