Issue with newest rusqlite version

[MarkusWendorf]

There's a version issue with sqlite when used with rusqlite:

[package]
name = "rust-issue"
version = "0.1.0"
edition = "2021"

[dependencies]
refinery = { version = "0.8.14", features = ["rusqlite"] }
rusqlite = "0.32.1"

Errors with:

error: failed to select a version for `libsqlite3-sys`.
    ... required by package `rusqlite v0.23.0`
    ... which satisfies dependency `rusqlite = ">=0.23, <=0.31"` of package `refinery-core v0.8.14`
    ... which satisfies dependency `refinery-core = "^0.8.14"` (locked to 0.8.14) of package `refinery v0.8.14`
    ... which satisfies dependency `refinery = "^0.8.14"` (locked to 0.8.14) of package `rust-issue v0.1.0 (/Users/markuswendorf/Documents/projects/rust-issue)`
versions that meet the requirements `^0.18.0` are: 0.18.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.30.1`
    ... which satisfies dependency `libsqlite3-sys = "^0.30.1"` (locked to 0.30.1) of package `rusqlite v0.32.1`
    ... which satisfies dependency `rusqlite = "^0.32.1"` (locked to 0.32.1) of package `rust-issue v0.1.0 (/Users/markuswendorf/Documents/projects/rust-issue)`
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

Downgrading rusqlite to 0.31.0 works for now.

Thank you

[ignatz]

Note that the version issue is fixed at head, however refinery hasn't seen any new release in a while. I would also expect rusqlite to update eventually. There "newest" release is also pretty stale (e.g. oldish sqlite3 version).

[CliffHan]

same problem, hope we could get a new version which fix this dependency version problem

[tmpfs]

Same issue here. I can use patch.crates.io and point to HEAD but this is a blocker for me releasing my crates, would really appreciate a release with a rusqlite version bump please 🙏