I’ve got a SQLite database hooked up to my app with rusqlite. I have a bunch of tauri::command functions that involve interfacing with this database. Currently, I execute all statements on a single rusqlite::Connection (wrapped in a parking_lot::Mutex) and use tauri::State to manage it. Is this better than simply creating a new database connection for each command invocation? What are the advantages and disadvantages? Thanks!
#Managing SQLite connections in Tauri
spark mantle
sharp elk
Basically this: https://sqlite.org/forum/forumpost/3a1a61d7802a3a9a
idk if the performance would actually be noticeable, especially if compared to the performance hit from the IPC