Question related to using SQL db (lmk if there is a better channel):
I added a SQLite database to my app. What's the best pattern to recover data e.g. if the computer has a power loss.
In-memory database would be lost right? Should I create a working database in a temporary folder and then load/save that database to the user's document folder when user wants to save? thanks