SQLCipher Static Link seems to fail with some targets

[insipx]

Describe the bug

Troubleshooted sqlcipher a little bit here

using the pkg-config crate, tried to ensure sqlcipher library static link existed at runtime. it seems for some targets, sqlcipher won't compile, so won't be statically linked and instead falls back to linking dynamically with a system library.

Needs to be looked into more

One idea I had is to cross-compile for android/iOS with nix, this way we can ensure the SQLCipher library exists on the system and for the correct target at compile time, so that they may be bundled together.

Ultimately we need some way to ensure that when SQLCipher is bundled/vendored by the rust package manager (or really any other native library), it is being correctly included in xmtp-android/swift

Expected behavior

No response

Steps to reproduce the bug

No response