In case you're new to this group, please understand that I'm experienced with SQLite and I understand how it works and how it uses journal files.
Can someone explain to me -- or point at a web page which does -- why a separate journal file is needed. Why can't the information which SQLite stores in a journal file be put in the database file ? Given how SQLite structures its database files this would presumably mean that the main database would have journal pages as well as table and index pages. Or that there would be 'stable' table and index pages and 'journal' table and index pages. Simon.
