gwenn

@dcecile you could use [prepare_cached](https://docs.rs/rusqlite/latest/rusqlite/struct.Connection.html#method.prepare_cached).

In some cases, you may want something like: https://github.com/rusqlite/rusqlite/pull/1462/files#diff-78b809409e82349255ba39304c86c49a3c08f164a57567e43451e62f52569aa9R9-R14 Or https://github.com/rusqlite/rusqlite/pull/1462/files#diff-c595ea0bc5c6bee5e8dfc649ad92279225e2e9a354b8f4d355fbaf4012ebe1e8R6-R12 Alternative `sqlite` crate provides a [CursorWithOwnership](https://docs.rs/sqlite/0.34.0/sqlite/struct.CursorWithOwnership.html#)

The original issue is that you cannot have a `Store` **without** lifetime.

I mean that your _pseudo_ code is not a good example for the original issue because of this: ```rust impl Store // no lifetime ``` The original issue is about...

Rust can use the fact that `Transaction` [impl Deref](https://docs.rs/rusqlite/latest/rusqlite/struct.Transaction.html#impl-Deref-for-Transaction%3C'_%3E) See https://play.rust-lang.org/?version=stable&mode=debug&edition=2021&gist=4b666825635d3798177566e7b0b024ed

Would you mind closing this issue ?

You should not try to guess [sqlite3_version](http://sqlite.org/c3ref/libversion.html). Which is not (easily) comparable. Hence the use of `sqlite3_libversion_number`.

> @gwenn i'm not "guessing" it for comparison reason, just formatting it for ease-of reading. Much better than simply print raw number i think For me, https://github.com/rusqlite/rusqlite/pull/1422/files#diff-068438172230084847676a638395a6ee9914094c2cb2d76f2c5de07f0d136ad4R285 tries to guess...

> However, the current implementation expects an OwnedData argument to deserialize(), assuming the input data is a result of the serialize() function. The only constraint is: https://github.com/rusqlite/rusqlite/blob/6176b11a3008d749cf501ff5d3782935e5348af3/src/serialize.rs#L25-L27 If you can't...

https://github.com/launchbadge/sqlx/pull/2759