SQLite 
The package provides an interface to SQLite.
Example
Open a connection, create a table, and insert some rows:
let connection = sqlite::open(":memory:").unwrap();
connection
.execute(
"
CREATE TABLE users (name TEXT, age INTEGER);
INSERT INTO users VALUES ('Alice', 42);
INSERT INTO users VALUES ('Bob', 69);
",
)
.unwrap();
Select some rows and process them one by one as plain text:
connection
.iterate("SELECT * FROM users WHERE age > 50", |pairs| {
for &(column, value) in pairs.iter() {
println!("{} = {}", column, value.unwrap());
}
true
})
.unwrap();
The same query using a prepared statement, which is much more efficient than the previous technique:
use sqlite::State;
let mut statement = connection
.prepare("SELECT * FROM users WHERE age > ?")
.unwrap();
statement.bind(1, 50).unwrap();
while let State::Row = statement.next().unwrap() {
println!("name = {}", statement.read::<String>(0).unwrap());
println!("age = {}", statement.read::<i64>(1).unwrap());
}
The same query using a cursor, which is a wrapper around a prepared statement providing the notion of row and featuring all-at-once binding:
use sqlite::Value;
let mut cursor = connection
.prepare("SELECT * FROM users WHERE age > ?")
.unwrap()
.into_cursor();
cursor.bind(&[Value::Integer(50)]).unwrap();
while let Some(row) = cursor.next().unwrap() {
println!("name = {}", row[0].as_string().unwrap());
println!("age = {}", row[1].as_integer().unwrap());
}
Contribution
Your contribution is highly appreciated. Do not hesitate to open an issue or a pull request. Note that any contribution submitted for inclusion in the project will be licensed according to the terms given in LICENSE.md.
7.6k Dec 31, 2022
1.9k Jan 5, 2023
952 Jan 5, 2023
27 Nov 22, 2022
309 Dec 20, 2022
20 Jan 2, 2023
45 Nov 16, 2022
14 Dec 5, 2022
516 Jan 2, 2023
10 Nov 13, 2022
36 Dec 7, 2022
5 Sep 23, 2022
11 Sep 3, 2022
33 Dec 16, 2022
1.1k Dec 28, 2022
0 Dec 19, 2022
3 Jan 7, 2023