How can I access to the underlying sqlite3 handle? about rusqlite HOT 9 CLOSED

@trlim : Version 0.0.10 should now enable you to do this:

fn load_my_extension(conn: &SqliteConnection) -> SqliteResult<()> {
     let _guard = try!(SqliteLoadExtensionGuard::new(conn));

     // or use the SELECT version, that's fine too
     conn.load_extension(Path::new("spatialite"), None)
}

but you'll need to add the load_extension feature to the rusqlite dependency in Cargo.toml. Please let me know (reopen this issue or open a new one) if this doesn't work for you.

from rusqlite.

I'm not sure if that is within the scope of this project. Ideally, you'd interact with the connection through native rust calls. If there is functionality only accessible through ffi calls, that should be added to the library.

from rusqlite.

I'm not necessarily opposed to adding an unsafe escape hatch to grab the database handle, but I agree with @marcusklaas - if there's functionality for which you need the handle, we should probably wrap it in the library. What ffi calls do you need to make?

from rusqlite.

To enable extension loading with sqlite3_enable_load_extension().

let mut conn = ...;
unsafe {
  ffi.sqlite3_enable_load_extension(conn.sqlite(), 1);
}
try!(conn.execute("SELECT load_extension('spatialite');", &[]));
unsafe {
  // Disable further loading of extension
  ffi.sqlite3_enable_load_extension(conn.sqlite(), 0);
}

from rusqlite.

Gotcha. I will add that to the library - look for a new version later today. (Will ping here too.)

from rusqlite.

It works! Thank you.

from rusqlite.

In my bindings, I included an unsafe expose method so that clients can use it with the ffi bindings.

I bring this up because my bindings are in most ways subsumed by yours and I'd just as soon get rid of mine if they're not novel.

Is it worth re-opening this issue? (Does github even support that?)

from rusqlite.

@dckc I'm not necessarily opposed to an expose method, but I'd view any uses of it as an indication that rusqlite's coverage of SQLite is insufficient. (I suppose we could put a "please open an issue if you need to use this" in the docs for it.) Are there any client uses of it that you know of that aren't possible with the lib?

from rusqlite.

No, I'm not aware of any actual use of the expose method.

Yes, I agree that use of it indicates that this library should be enhanced.

from rusqlite.