On Tue, 20 Jun 2006 15:34:21 +0200, Ralf Junker wrote: >SQLiteSpy 1.5.4 is released. Changes include:
>* Updated to SQLite3 3.3.6. >* The schema tree view did not automatically reflect if a table was emptied or >initial records were being added. >* The default text encoding for newly generated database files is now UTF-8. >* Fixed a nasty bug which could cause the syntax highlighting to freeze the >application. >SQLiteSpy is a Freeware SQLite3 database manager for Win32. It is available >for download from http://www.yunqa.de/delphi/sqlitespy/. Your program looks quite nice and seems to do what is needed. Thanks for developing it. Here are a couple of points I have discovered after a few minutes of use: 1. SQLiteSpy is able to read and work with database files formatted by versions of Sqlite earlier than 3.3.6 but it also appears to change the database format rather than leave it as it was found. I use php version 5.1.4 including Sqlite version 3.2.8. There is a database format change in later versions of Sqlite that means php is NOT able to read these later versions. My intention is to use SQLiteSpy as a data administration tool outside of php but that is not possible until their versions are synchronised. 2. After executing some sql against a database, the result set is displayed. If the database is closed after that, the result set stays on the screen when it might be less confusing if it disappeared as the database was closed. Regards, Chris
