How do I use sqlx and rustqlite in the same project workspace?

[matthiasdebernardini]

I am using sqlx for postgres support in my project that is already using rusqlite.

They both depend on libsqlite3-sys, however for the postgres project I don't need sqlite since that is being covered by rustqlite.

I only need postgres support. Is there a way to disable sqlite from sqlx completely? Or is there a way to "trick" sqlx to link to a version of sqlite that it will not use?

We can't use sqlite from sqlx because we want to offer our users a non-async version of storing their data. So rusqlite offers that.

sqlx = { version = "0.7.4", features = [ "runtime-tokio-rustls", "postgres", "json"] }

rusqlite = { version = "0.31.0", features = ["bundled"] }

error: failed to select a version for `libsqlite3-sys`.
    ... required by package `sqlx-sqlite v0.7.4`
    ... which satisfies dependency `sqlx-sqlite = "=0.7.4"` of package `sqlx v0.7.4`
    ... which satisfies dependency `sqlx = "^0.7.4"` of package `bdk_postgres v0.1.0 (/Users/matthiasdebernardini/Projects/bdk/crates/postgres)`
versions that meet the requirements `^0.27.0` are: 0.27.0

the package `libsqlite3-sys` links to the native library `sqlite3`, but it conflicts with a previous package which links to `sqlite3` as well:
package `libsqlite3-sys v0.28.0`
    ... which satisfies dependency `libsqlite3-sys = "^0.28.0"` of package `rusqlite v0.31.0`
    ... which satisfies dependency `rusqlite = "^0.31.0"` of package `bdk_sqlite v0.2.0 (/Users/matthiasdebernardini/Projects/bdk/crates/sqlite)`
    ... which satisfies path dependency `bdk_sqlite` (locked to 0.2.0) of package `wallet_esplora_async v0.2.0 (/Users/matthiasdebernardini/Projects/bdk/example-crates/wallet_esplora_async)`
Only one package in the dependency graph may specify the same links value. This helps ensure that only one copy of a native library is linked in the final binary. Try to adjust your dependencies so that only one package uses the `links = "sqlite3"` value. For more information, see https://doc.rust-lang.org/cargo/reference/resolver.html#links.

failed to select a version for `libsqlite3-sys` which could resolve this conflict

I tried this approach,
#2772

sqlx = { version = "0.7.4", features = [ "runtime-tokio-rustls", "postgres", "json"], default-features = false}

but that did not solve it (I did cargo clean prior to compiling)

Any help is appreciated, I'm unsure how to continue with maintaining version of rustqlite 31 and sqlx 0.7.4

Thanks

[kirildi]

Same problem here !! And I found this post from somewhere...
I tried some version combination. May be try sqlx 0.7.3 and rusqlite 0.30.0 if works for you, until is fixed in some new versions

[matthiasdebernardini]

that's what I had to do, I actually just ended up making a separate crate that was not a module in the workspace - for now its ok though

[izissise]

I have the same problem.
Setting sqlx to 0.7.3 and rusqlite to 0.30 works.
Is there another workaround that would allow staying on latest?

[dxramax]

Thanks, you saved me a lot of time

[fdietze]

rusqlite 0.32.1 and sqlx 0.8.6 is a recent working combination.

[harmic]

This PR seems to relax the libsqlite3-sys version requirements which should hopefully make it easier to combine with rusqlite. It's merged but not released yet, from what I can see.

[abonander]

It's available in 0.9.0-alpha.1.