How to Use SQLite with Rust

Use the diesel crate with the sqlite and libsqlite3-sys/bundled features to embed SQLite directly into your Rust binary without external dependencies. Add diesel = { version = "2.2", features = ["sqlite", "libsqlite3-sys/bundled"] } to your Cargo.toml and run cargo build to compile the database engine alongside your application.

[dependencies]
diesel = { version = "2.2", features = ["sqlite", "libsqlite3-sys/bundled"] }

This configuration ensures SQLite is compiled as part of the build process, matching the setup used in the diesel test suite where features: Some(&["sqlite", "libsqlite3-sys/bundled"]) is specified.

Using SQLite with Rust lets your program include a full database inside itself, so you don't need to install anything else on the computer running your code. It's like baking the database engine directly into your application so it works out of the box. You use this when you want a portable app that manages its own data without relying on external server software.