How do I create a new database using Diesel?

user_612829 0
Viewed 3328

Is it possible to create a new database in Rust using Diesel? I can't find anything in the documentation. I am specifically interested in SQLite.

rust-diesel rust sqlite database
2 Answers

TBH, I didn't really search in the documentation but, on the Cargo.toml side, you need :

[dependencies]
diesel = { version = "1.4.3", features = ["sqlite"] }

Inside you .env file, you can specify the path to the database file like :

DATABASE_URL=mydb.sqlite3

If you follow the "Getting Started" guide, then, you just need to use SqliteConnection instead of PgConnection :

use diesel::sqlite::SqliteConnection;

// ...

pub fn establish_connection() -> SqliteConnection {
    // ...
}
user_26639590
user_66210080
Related