Database caching for Tauri - Diesel and SQLite

[rsteaburdea]

Describe the bug

I am trying to build a small app with Tauri and SQLite database with Diesel ORM and every time I start the app with yarn tauri dev it will bring the first data from the migration script of the database (diesel migration run). Even if I remove the database it will bring the same data. It feels like the data is cached somehow. Even if I update the migration script with more entries or update the database manually, the new data won't appear.

For Cargo.toml I have this dependencies:

[dependencies]
serde_json = "1.0"
serde = { version = "1.0", features = ["derive"] }
tauri = { version = "1.2.4", features = ["shell-open"] }
diesel = { version = "2.0.0", features = ["sqlite", "returning_clauses_for_sqlite_3_35"] }
libsqlite3-sys = { version = "0.25.2", features = ["bundled"] }
diesel_migrations = {version = "2.0.0", features = ["sqlite"] }
remove_dir_all = "0.8.2"

The method that I am using to select the data is this:

#[derive(Identifiable, Queryable, Serialize, Deserialize, AsChangeset)]
#[serde(rename_all = "camelCase")]
#[diesel(table_name = pwn_contracts)]
pub struct Contract {
    pub id: i32,
    pub name: String,
}

pub fn contract_list(db_path: String) -> Vec<Contract> {
    let mut connection = establish_connection(&db_path);
    pwn_contracts::dsl::pwn_contracts
        .select(pwn_contracts::all_columns)
        .load::<Contract>(&mut connection)
        .expect("Loading contracts failed")
}

The establish_connection method looks like this:

pub fn establish_connection(path: &str) -> SqliteConnection {
    SqliteConnection::establish(path).unwrap_or_else(|_| panic!("Error connecting to database"))
}

I've tried also with this:

pub fn establish_connection(path: &str) -> SqliteConnection {
    SqliteConnection::establish(&format!("sqlite://{}?cache=none", path)).unwrap_or_else(|_| panic!("Error connecting to database"))
}

But I get some error.

Is this a bug or am I doing something wrong?

Also there is a topic on stackoverflow that you can find it here.

Reproduction

No response

Expected behavior

No response

Platform and versions

Environment
  › OS: Mac OS 13.3.1 X64
  › Node.js: 18.16.0
  › npm: 9.6.4
  › pnpm: 8.2.0
  › yarn: 1.22.19
  › rustup: 1.25.2
  › rustc: 1.68.2
  › cargo: 1.68.2
  › Rust toolchain: stable-aarch64-apple-darwin

Packages
  › @tauri-apps/cli [NPM]: 1.2.3
  › @tauri-apps/api [NPM]: 1.2.0
  › tauri [RUST]: 1.2.4,
  › tauri-build [RUST]: 1.2.1,
  › tao [RUST]: 0.15.8,
  › wry [RUST]: 0.23.4,

App
  › build-type: bundle
  › CSP: unset
  › distDir: ../dist/pownshop-tauri
  › devPath: http://localhost:1420/
  › framework: Angular
  › bundler: Webpack

App directory structure
  ├─ dist
  ├─ .angular
  ├─ node_modules
  ├─ src-tauri
  ├─ .vscode
  └─ src

Stack trace

No response

Additional context

No response

[rsteaburdea]

It was a problem with a database path and the topic is much related with diesel and rust rather than tauri.
It created the database at this path: /Users/My Username/Library/Application Support/com.tauri.dev/pownshop.sqlite3 and not the one that I tried to use in the project.
Since it's not a topic related with tauri I will close and find a resolution in my stackoverflow post.