Softpedia >Windows >Internet >Servers >Database Utils >SQLiteSpy >  Changelog

SQLiteSpy Changelog

What's new in SQLiteSpy 1.9.24

Apr 17, 2024
  • Update the built-in database engine to SQLite 3.45.3, DISQLite3 v5.48.3.

New in SQLiteSpy 1.9.23 (Mar 18, 2024)

  • Update the built-in database engine to SQLite 3.45.2, DISQLite3 v5.48.2.
  • Fix: The schema treeview did not show generated columns.
  • Fix: If a table's pimary key column name contained parameter characters ('?', ':', '@', or '$'), a double click on the schema treeview failed to display the table or showed “0 - deleted” instead of the actual row data.

New in SQLiteSpy 1.9.22 (Mar 1, 2024)

  • Update the built-in database engine to SQLite 3.45.1, DISQLite3 v5.48.1.

New in SQLiteSpy 1.9.14 (Feb 5, 2020)

  • The download package now contains SQLiteSpy.exe Win32 as well as Win64 executables.
  • Update built-in DISQLite3 engine to SQLite 3.31.1.
  • Add the BLOBIO SQL function extension. Example:
  • CREATE TABLE t(a blob);
  • INSERT INTO t VALUES (x'01020304');
  • SELECT readblob('main', 't', 'a', 1, 0, 4);
  • Add the DBDATA virtual table extension. Examples:
  • SELECT * FROM sqlite_dbdata();
  • SELECT * FROM sqlite_dbptr();
  • Add the FOSSILDELTA SQL function extension. Example:
  • SELECT delta_apply(x'0102', delta_create(x'0102', x'0304'));
  • Add the URIFUNCS SQL functions extension. Examples:
  • select sqlite3_filename_database('main');
  • select sqlite3_filename_journal('main');
  • select sqlite3_filename_wal('main');
  • Add the UUID SQL functions extension. Examples:
  • SELECT uuid();
  • SELECT uuid_str(uuid());
  • SELECT uuid_blob(uuid());
  • Add redo to SQL edit.
  • Automatic column widths of result grid take column caption into account.

New in SQLiteSpy 1.9.13 (Mar 1, 2019)

  • Update built-in DISQLite3 engine to SQLite 3.27.2.
  • Add the PREFIXES extension:
  • prefixes() table-valued SQL function.
  • Example: SELECT prefixes('abcdefg');
  • prefix_length() SQL function.
  • Example: SELECT prefix_length('abcdxxx', 'abcyy'); yields 3.
  • Add the IsoWeek() and IsoWeekYear() SQL functions. Right now, they accept a date in exactly YYYY-MM-DD string format only.
  • SELECT IsoWeek('2019-01-01');
  • SELECT IsoWeekYear('2019-01-01');
  • Add the SQLAR extension.
  • Add the ZIPFILE extension.
  • Pull syntax highlighter keywords and function names from SQLite3.
  • Fix an AV when trying to edit a table with no result rows.

New in SQLiteSpy 1.9.12 (Jan 3, 2018)

  • Update built-in DISQLite3 engine to SQLite 3.21.0.
  • Add the CSV extension.
  • Example: CREATE VIRTUAL TABLE t1 USING csv(filename='thefile.csv');
  • Add the DBPAGE extension.
  • Example: SELECT data FROM sqlite_dbpage('main');
  • Add the CHECKFREELIST SQL function.
  • Example: SELECT checkfreelist('main');
  • Add the SHA3 extension.
  • Example: SELECT sha3('abc', 256);
  • Add the SHA1 extension.
  • Example: SELECT sha1('abc');
  • New menu item and SHIFT+F9 shortcut for EXPLAIN QUERY PLAN SQL.
  • Improve updating the SQL status in case of errors.

New in SQLiteSpy 1.9.11 (Sep 20, 2017)

  • Update built-in DISQLite3 engine to SQLite 3.13.0.
  • Add the JSON extension.
  • Example: SELECT json_extract('{“a”:2,“c”:[4,5,{“f”:7}]}', '$.c[2].f');
  • Add the Session extension.
  • Example: SELECT * FROM generate_series(0,100,5);

New in SQLiteSpy 1.9.8 (Aug 22, 2014)

  • Update built-in DISQLite3 engine to SQLite 3.8.6.
  • Attached database: Double clicking a table node did not work. Fixed.
  • New MediaMonkey.dll extension which adds the IUNICODE collation sequence needed to open MediaMonkey databases.

New in SQLiteSpy 1.9.7 (Apr 30, 2014)

  • Update built-in DISQLite3 engine to SQLite 3.8.4.3
  • Open database by drag and dropping on the schema treeview
  • Respect decimal point option when editing floating point numbers
  • More stable scrolling through huge numbers of rows / columns
  • Fix display of table / column names which represent SQLite keywords

New in SQLiteSpy 1.9.6 (Sep 6, 2013)

  • Implement the SQLite 3.8.0.2 bug fixes.

New in SQLiteSpy 1.9.5 (Aug 31, 2013)

  • Implement the SQLite 3.8.0.1 bug fixes.

New in SQLiteSpy 1.9.4 (Aug 29, 2013)

  • Update built-in DISQLite3 engine to SQLite 3.8.0
  • In table browsing mode, order results by ROWID
  • Fix error when scrolling a table with many result columns
  • Stay responsive in case of SQLite errors

New in SQLiteSpy 1.9.3 (Apr 12, 2013)

  • Update built-in DISQLite3 engine to pre SQLite 4.2.0.
  • Add SQLite's spellfix virtual table.
  • New file menu items to create, open or attach a database with URI parameters.
  • Improve [ESC] key responsiveness for multiple, small SQL statements like INSERT.
  • Option to specify the data type in cell editor.
  • Handle tables dropped after displayed the grid editor.
  • Auto-calculate column widths from the record texts of initially displayed records.
  • Ctrl+PgUp/PgDn] navigate between result tabs.
  • Shift+F10] opens the context menu in the schema treeview.

New in SQLiteSpy 1.9.1 (Jul 29, 2011)

  • Update built-in DISQLite3 engine to pre SQLite 3.7.8.
  • Add YuStemmer language stemming to the FTS4 unicode tokenizer.
  • Add the fuzzer and wholenumber virtual tables.
  • If a database file can not be opened, fall back to the :memory: database

New in SQLiteSpy 1.9.0 (Mar 3, 2011)

  • Support for loadable extensions compiled with "fastcall" (C++ Builder) or "register" (Delphi) calling conventions.
  • Update built-in DB engine to pre SQLite 3.7.6 (DISQLite3 2.3.4).
  • On database close, open an in-memory database (:memory:).

New in SQLiteSpy 1.8.16 (Sep 1, 2010)

  • Update built-in DB engine to SQLite 3.7.2 (DISQLite3 2.3.1).
  • Print some sqlite3_stmt_status() performance counters to the status bar.
  • Faster processing of large SQL scripts.
  • Fix table mode browsing (double clicking on a table name) for tables which use some of the INTEGER PRIMARY KEY aliases as column names. Output a warning if the table can not be browsed because all three names (ROWID, OID, or _ROWID_) are in use by the table. This sould be very rare, however.

New in SQLiteSpy 1.8.15 (Aug 6, 2010)

  • Update built-in DB engine to SQLite 3.7.0.1 (DISQLite3 2.3.0.1). This fixes a potential database corruption problem that can result if the same database file is alternately written by SQLite version 3.7.0 and SQLite 3.6.23.1 or earlier. Upgrading is highly recommended.

New in SQLiteSpy 1.8.14 (Jul 29, 2010)

  • Update built-in DB engine to SQLite 3.7.0

New in SQLiteSpy 1.8.13 (Apr 15, 2010)

  • Update built-in DB engine to SQLite 3.6.23

New in SQLiteSpy 1.8.12 (Mar 19, 2010)

  • Update built-in DB engine to SQLite 3.6.22

New in SQLiteSpy 1.8.11 (Mar 19, 2010)

  • Update built-in DB engine to SQLite 3.6.21

New in SQLiteSpy 1.8.10 (Aug 28, 2009)

  • Update built-in DB engine to SQLite 3.6.17

New in SQLiteSpy 1.8.8 (Mar 12, 2009)

  • Update built-in DB engine to SQLite 3.6.10 (DISQLite3 2.0.3).
  • Fix an access violation when pressing ESC if no database is open.

New in SQLiteSpy 1.8.7 (Jan 28, 2009)

  • Update built-in DB engine to SQLite 3.6.7 (DISQLite3 2.0.2).

New in SQLiteSpy 1.8.1 (Aug 22, 2008)

  • Update built-in DB engine to SQLite 3.6.1 (DISQLite3 1.6.1).
  • Schema treeview: Show triggers even if the trigger table name case differs from the original table name case.