SQLite proper disposal when shutting down the app
I have a question regarding SQLite database and its WAL mode (making changes to separate file and checkpointing it when its enough).
Is it possible to handle "forceful shutdown", like end process from task manager? (i have some API and windows services which are using the database). Or if there is some kind of database setting, that when you lose the last connection, the database gets automatically checkpointed to main file.
Because I can't seem to find a way to do it, but with DB Browser for SQLIte (some kind of SQLIte IDE software, like SSMS for sql), if i end the process, the checkpoint happens, but I dont know how. Any idea what would be the best solution?
I have osme kind of automatic checkpoint on "normal" shutdown, but thats kinda it... I hope you understand what I want to achieve
Is it possible to handle "forceful shutdown", like end process from task manager? (i have some API and windows services which are using the database). Or if there is some kind of database setting, that when you lose the last connection, the database gets automatically checkpointed to main file.
Because I can't seem to find a way to do it, but with DB Browser for SQLIte (some kind of SQLIte IDE software, like SSMS for sql), if i end the process, the checkpoint happens, but I dont know how. Any idea what would be the best solution?
I have osme kind of automatic checkpoint on "normal" shutdown, but thats kinda it... I hope you understand what I want to achieve
