General Tauri question that is bothering me.

[wheat scaffold]

I am using diesel sqlite as my database.

1. Should i keep the app database in AppData directory or within the application?
2. what is the recommended way? and where does the db get store when the app is compiled and installed.
3. And if i want to encrypt the full database.sqlite in AppData directory, how can i do it ?

[fading nexus]

use AppData if you want keep the db file unchanged when update, put in the app will be replaced by the new one in update process.

[wheat scaffold]

@fading nexus cool understood.

any idea any recommendation on the 3rd point?

[dense bluff]

1. Use local AppData
2. Using local AppData. It gets recreated for each user. If you place it elsewhere you may run into write permission issues
3. Not sure if you can encrypt the entire thing, I so seldom use sqlite, but you can at least encrypt each sensitive record in there individually. Otherwise you'll need some manner of adapter for Diesel to handle an encrypted database file

[wheat scaffold]

thanks @dense bluff