Use SQLite In A Tauri App

NOTE: This does not at all feel like the best way to do things. I tried using: `tauri::PathResolver`` but couldn't figure out how to get it to work.

Also, bascially don't use these notes yet, there still a work in progress, but I'm trying to get othet stuff working too

Create a new Tauri App

`cargo create-tauri-app`

Fill out the stuff

cd into the new direcory

Do:

npm add https://github.com/tauri-apps/tauri-plugin-sql#v1

Might need to do `npm install`` here, but it doesn't look like it on first blush

Add this to `src-tauri/Cargo.toml``

Code

// NOTE: THis isn't necessary, I don't think
// but 
[dependencies.tauri-plugin-sql]
git = "https://github.com/tauri-apps/plugins-workspace"
branch = "v1"
features = ["sqlite"]

Add `.plugin(tauri_plugin_sql::Builder::default().build())`` to the tauri setup in `src-tauri/src/main.rs`` like:

Code

#![cfg_attr(not(debug_assertions), windows_subsystem = "windows")]

use dirs;
use rusqlite::{params, Connection, Result};
use std::fs;
use std::path::PathBuf;

fn init_db() {
    if !db_path().exists() {
        match create_db() {
            Ok(_) => println!("Created Database"),
            Err(e) => println!("{}", e),
        }
    } else {
        println!("Database already exists");
    }
}

fn create_db() -> Result<()> {
    println!("Creating database");
    let db_path = db_path();
    let db_dir = db_path.parent().unwrap();
    if !db_dir.exists() {
        fs::create_dir_all(db_dir).unwrap();
    }
    let conn = Connection::open(db_path.to_str().unwrap())?;
    conn.execute(
        "CREATE TABLE widget (
            id INTEGER PRIMARY KEY,
            item TEXT NOT NULL
        )",
        (),
    )?;
    conn.execute("INSERT INTO widget (item) VALUES (?1)", params!["alfa"])?;
    conn.execute("INSERT INTO widget (item) VALUES (?1)", params!["bravo"])?;
    Ok(())
}

#[tauri::command]
fn db_path() -> PathBuf {
    let home_dir = dirs::home_dir().unwrap();
    PathBuf::from(
        home_dir.to_str().unwrap().to_string() + "/.config/sqlite_tauri_test/database.sqlite",
    )
}

fn main() {
    tauri::Builder::default()
        .setup(|_app| {
            init_db();
            Ok(())
        })
        .plugin(tauri_plugin_sql::Builder::default().build())
        .run(tauri::generate_context!())
        .expect("error while running tauri application");
}

Use SQLite In A Tauri App

Code

Code

References