Hi, https://www.sqlite.org/lockingv3.html#rollback
"When a process wants to change a database file (and it is not in WAL mode), it first records the original unchanged database content in a rollback journal. The rollback journal is an ordinary disk file that is always located in the same directory or folder as the database file and has the same name as the database file with the addition of a -journal suffix. The rollback journal also records the initial size of the database so that if the database file grows it can be truncated back to its original size on a rollback." I got confused about the above statement about the rollback journal. The sentence "The rollback journal ..." appears to be a definition. But it is not. I think that the following can be considered as a definition. Given the above sentence appears in a section named "4.0 The Rollback Journal". I think it should be changed to a definition to avoid confusion. https://www.sqlite.org/tempfiles.html "A rollback journal is a temporary file used to implement atomic commit and rollback capabilities in SQLite." Regarding the choice of the word "journal", the only relevant entry about "journal" in the Oxford dictionary is this. Is "journal" just a fancy way of saying "record file"? Thanks. """ 2 a daily record of news and events of a personal nature; a diary. • Nautical a logbook. • (the Journals) a record of the daily proceedings in the British Houses of Parliament. • (in bookkeeping) a daily record of business transactions with a statement of the accounts to which each is to be debited and credited. """ -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
