Hello C.Peachment, >It appears that VACUUM is not the only SQL command to cause >this behaviour. I had done a number of INSERT and UPDATE >commands before closing the database and attempting to use >it with PHP. The VACUUM command was not used.
I am surprised to read this. I would be interested if you could reproduce this so I can see if SQLiteSpy is the evil or if it is an issue SQLite. If you can, please contact me via e-mail. >For the moment, my situation is not unique since other users of >PHP will face it too. The pragma legacy_file_format=on >instruction should solve the problem. Any possibility that it could >be set as a configuration parameter for SQLiteSpy to avoid the >need to issue the pragma command each time SQLiteSpy is >used? Sure, I will think about that. >I have searched the documentation for this pragma but without >success. Is this a case of "Star Wars : Use the source, Luke?" :-) Quite true. This has come up in the mailing list already, but maybe a SQLite documentation bug report would push it to success? Regards, Ralf
