Rustic bindings for sqlite3
Rust
Clone or download
dckc OBSOLETE in favor of jgallagher/rusqlite
Thanks, everybody, for the feedback and contributions. It's been fun!

@PeterReid and others, you are of course welcome to continue to maintain your forks, but I'm content that jgallagher/rusqlite subsumes the functionality here so I no longer intend to maintain mine.

cc @jgallagher @theduke

fixes #46
Latest commit b0dc7d6 Jan 6, 2017

README.md

Rust-Sqlite3

Rustic bindings for sqlite3. OBSOLETE in favor of jgallagher/rusqlite

Copyright (c) 2014-2017 Dan Connolly and contributors

Share and enjoy. LICENSE: MIT.

Documentation, Status

View the documentation online

Three layers of API are provided:

  • mod ffi provides exhaustive, though unsafe, bindgen bindings for libsqlite.h
  • mod core provides a minimal safe interface to the basic sqlite3 API
  • mod types provides ToSql/FromSql traits, and the library provides convenient query() and update() APIs.

The API design is perhaps stabilizing, though testing is uneven and I have not used the library beyond trivial integration tests.

Build Status

TODO

  • another thorough read-through of the sqlite API intro, with unit tests to match; especially...
    • unit testing other than the happy-paths
  • ToSql/FromSql can now be implemented by clients, but the types module probably doesn't hit the 80% mark yet; e.g. it's missing uint and &[u8].
  • investigate test coverage tools for rust
  • basic benchmarking

Motivation and Acknowledgements

I was looking into sandstorm, a personal cloud platform with an architecture based on the wonderful capability security paradigm, and I found a rust application, acronymy, that uses the native API rather than the traditional POSIX environment.

I started poring over the code and followed the dependency link to linuxfood's rustsqlite. I started working on a memory safety issue etc. but soon found a number of large-scale API design issues that I wasn't sure how to approach with the upstream developers. I was also inspired by FromSql, ToSql and such from sfackler's rust-postgres API.

So I started from scratch, using bindgen, Result (sum types) etc.