|
Update built-in DB engine to SQLite 3.7.0 ( DISQLite3 2.3.0).
Update built-in DB engine to SQLite 3.6.23 ( DISQLite3 2.2.2).
Update built-in DB engine to SQLite 3.6.22 ( DISQLite3 2.2.0).
Update built-in DB engine to SQLite 3.6.21 ( DISQLite3 2.1.2).
Update built-in DB engine to SQLite 3.6.17 ( DISQLite3 2.0.9).
Update built-in DB engine to SQLite 3.6.7 ( DISQLite3 2.0.2).
Fix Vista Open and Save dialog problem.
Fix form scaling problem with large fonts.
Increase splitter size slightly to please high resolution displays.
Update built-in DB engine to SQLite 3.5.8 ( DISQLite3 1.5.8).
Update internal database engine to SQLite 3.5.4 ( DISQLite3 1.5.4).
In the SQL edit, pressing CTRL+RETURN now executes SQL similar to the global F9.
Fix SQL edit keyboard shortcuts CTRL+A (select all) and CTRL+Z (undo).
Update internal database engine to SQLite 3.5.1 CVS 4479, implemented as DISQLite3 1.5.1.
New SQL functions COMPRESS() and UNCOMPRESS().
Update to use SQLite 3.3.17 CVS [4045].
When in table browsing mode, avoid repetitive exceptions if a table is no longer available. Show an error message inside the cell instead.
Drastically cut down the time to open databases with many tables and demanding views.
Improve [ESC] key responsiveness when aborting very long queries.
Reading table data from a locked database no longer results in an error message.
Invalid regular expressions return a proper error message.
Option for caseless REGEXP.
SQL edit control supports inserting tabs via CTRL + ALT + TAB.
Populated grid does not trigger donation button.
Cell editing is now possible in the grid for tables selected from the schema treeview.
Improved performance and reduced memory requirements when displaying tables from the schema treeview.
New options storage format. Previously saved form positions and MRU lists will be lost.
Width of the schema tree columns is now saved.
The internal SQLite library is now 3.3.12, including full text search one ( FTS1) and two ( FTS2).
Encryption support for databases created with the DISQLite3.
Fixed a few bugs and memory leaks.
Updated the internally used DISQLite3 library to the latest version, which corresponds 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.
Updated the internally used DISQLite3 library to the latest version, which corresponds to SQLite3 3.3.5.
Availability of data is no not indicated in the schema treeview if data checking takes too long. This speeds up loading databases with time consuming views.
Fixed problems when running on systems without MMX support.
Updated the internally used DISQLite3 library to the latest version, which corresponds to SQLite3 3.3.3.
Attached databases now show up in the schema tree view, including all their tables, indexes, views and triggers.
New File → Attach Database… menu item.
Attached databases can be easily detached using the schema tree view's context menu.
ALTER TABLE … ADD COLUMN automatically updates the schema tree view. The schema tree view should now automatically adjust to any internal change to the database schema.
Executing an SQL statement which does not return any data now shows all columns on top of an empty result grid. This change was requested by many users who felt confused when the grid was not cleared if no results were returned.
Refreshing the schema treeview no longer displays a SQLITE_SCHEMA error if the database schema has changed outside SQLiteSpy.
The schema treeview automatically refreshes when SQLiteSpy becomes active and the database has changed outside of SQLiteSpy.
If SQL commands executed within SQLiteSpy change the database schema, most of these changes are automatically reflected in the schema treeview.
Refreshing the schema treeview preserves the expanded / collapsed state of existing nodes.
The schema treeview indicates if tables and view contain any data by showing a "+" sign if they do and a "-" sign if they do not.
SQLite error messages are now properly shown for international characters (Cyrillic, Greek) as well.
For multiline text, the data grid shows the first line only plus a small icon indicating that more lines are available. Hints a single-line also and no longer spread across the entire screen. To view the full text, click the cell and scroll the text in the edit below.
Limited width of datagrid columns to prevent infinite widths for very long texts.
Added "Text to Unicode Conversion…" to the Execute Menu. This allows to change text fields of selected tables and columns from the currently used ANSI encoding to Unicode. Non-text data is not converted.
Fixed a year offset bug with the 'localtime' implementation.
Fixed a bug that would crash SQLiteSpy if an invalid database file was passed at the command line.
Updated the internally used DISQLite3 library to the latest SQLite version 3.2.8.
Thanks to all who have reported bugs, suggestions and ideas to SQLiteSpy!
Updated the internally used DISQLite3 library to the latest version.
Updated the internally used DISQLite3 library to the latest version.
Updated the internally used DISQLite3 library to the latest version.
Updated the internally used libraries to the latest versions: DISQLite3, DIRegEx, zlib.
Added syntax highlighting and menu item for the new SQL ANALYZE command.
Fixed a few minor bugs.
New support for REGEXP keywoard, implementing a regular expression syntax compatible to Perl 5.8.
SQLite database engine updated to the latest version.
Bug fixes, mostly related to drag & drop file operations into the SQL editor and tab handling.
products/sqlitespy/history.txt · Last modified: 2010/07/28 17:41 (external edit)
|