Does SQLite do any file editing when you close a database ?
I know that the SQLite "_open()" calls are fakes. The file is not really opened until the first operation which needs to access it.
However, triggered by another post to this forum I’m not curious about "_close()" calls. I used to think that SQLite did clear-up work when you closed a file. For example, truncating or deleting a journal file. But it seems that these operations are done at the end of transactions, not when the file is closed.
Can anyone point out anything that’s done to files when you close a database ?