How can I save my database to a user file when usi...
# squarelibrariesa
adte
06/10/2023, 1:21 PMHow can I save my database to a user file when using SQLDelight?
I plan to have the working database saved inside AppData folder (for crash recovery etc.) and when the user requests it, copy the database to the save path to implement save operation.
s
saket
06/10/2023, 3:07 PMI'm afk but there is a database folder inside
context.filesDira
adte
06/10/2023, 3:15 PMThanks! Sorry, I meant on desktop. e.g. on Windows I'm not sure I can copy the db file while it's being used. I know SQLite has a backup API that can be used for that but I read that SQLDelight doesn't support it
s
saket
06/10/2023, 3:16 PMiteresting, i'm not very familiar with this. can you share more details about the backup api?
a
adte
06/10/2023, 3:17 PMadte
06/10/2023, 3:17 PMOh, there's also
VACUUM INTOr
Rohan Maity
06/14/2023, 12:31 PMThis is only available from 3.27 version. Not sure whether SqlDelight uses sqlite 3.27
18 Views