Rusqlcipher

https://docs.rs/rusqlcipher/0.14.9/rusqlcipher/
Admin
Rusqlcipher is an ergonomic Rust wrapper for SQLCipher that enables encrypted database access with...
Tokens:1,129
Snippets:14
Trust Score:9.1
Update:5 months ago
Show doc for...
Tokens:
Raw
### Basic rusqlcipher Usage Example

Source: https://docs.rs/rusqlcipher/0.14.9/rusqlcipher

Demonstrates opening an in-memory database, creating a table, inserting data, and querying it using rusqlcipher. Ensure the `rusqlcipher` and `time` crates are included as dependencies.

```rust
extern crate rusqlcipher;
extern crate time;

use time::Timespec;
use rusqlcipher::Connection;

#[derive(Debug)]
struct Person {
    id: i32,
    name: String,
    time_created: Timespec,
    data: Option<Vec<u8>>
}

fn main() {
    let conn = Connection::open_in_memory().unwrap();

    conn.execute("CREATE TABLE person (
                  id              INTEGER PRIMARY KEY,
                  name            TEXT NOT NULL,
                  time_created    TEXT NOT NULL,
                  data            BLOB
                  )", &[]).unwrap();
    let me = Person {
        id: 0,
        name: "Steven".to_string(),
        time_created: time::get_time(),
        data: None
    };
    conn.execute("INSERT INTO person (name, time_created, data)
                  VALUES (?1, ?2, ?3)",
                 &[&me.name, &me.time_created, &me.data]).unwrap();

    let mut stmt = conn.prepare("SELECT id, name, time_created, data FROM person").unwrap();
    let person_iter = stmt.query_map(&[], |row| {
        Person {
            id: row.get(0),
            name: row.get(1),
            time_created: row.get(2),
            data: row.get(3)
        }
    }).unwrap();

    for person in person_iter {
        println!("Found person {:?}", person.unwrap());
    }
}
```

--------------------------------

### Enable Bundled SQLite Build in Cargo.toml

Source: https://docs.rs/rusqlcipher/0.14.9/rusqlcipher

To use the 'bundled' feature for libsqlcipher-sys, which compiles SQLite from source, add this configuration to your Cargo.toml. This is often the simplest solution for build issues.

```toml
[dependencies.rusqlcipher]
version = "0.11.0"
features = ["bundled"]

```

--------------------------------

### Enable Build-time Bindgen Generation

Source: https://docs.rs/rusqlcipher/0.14.9/rusqlcipher

To generate your own SQLite bindings at build time using bindgen, enable the 'buildtime_bindgen' Cargo feature. This requires a recent version of Clang and the SQLite header file to be present.

```rust
buildtime_bindgen
```

--------------------------------

### Select Pre-generated SQLite Bindings

Source: https://docs.rs/rusqlcipher/0.14.9/rusqlcipher

When using libsqlcipher-sys directly, you can select pre-generated bindings for specific SQLite versions using Cargo features. The default is 'min_sqlite_version_3_6_8'.

```rust
min_sqlite_version_3_6_8
min_sqlite_version_3_6_11
min_sqlite_version_3_6_23
min_sqlite_version_3_7_3
min_sqlite_version_3_7_4
```
Tokens:
Raw