SQLite Forum

classic save possibility
Login
Is there any possibility to achieve in sqlite the classic Save functionality. I mean such a scenario: create a new file - new database, file edition - "write" transactions, close the application with classic question "save the changes to disk" - what then ?. Additionally, it is possible to save at any time by explicitly running the Save option. Note! I wants to avoid closing/reopening all connections because its hard in my case. I'm thinking about using WAL file with manual checkpoints control where checkpoint act as Save. Is this possible. If yes - pros and cons. Thanks