SQLiteManager Changelog

What's new in SQLiteManager 4.8.3

Mar 20, 2019
  • Improved parsing of sql create table statements.
  • Improved HexViewer for BLOB fields.
  • Updated built-in CubeSQL plugin.
  • Added the ability to customize row height.
  • Fixed a crash issue related to BLOB fields.
  • Several other internal enhancements and fixes.

New in SQLiteManager 4.8.0 (Oct 22, 2018)

  • Updated underline sqlite engine to the latest 3.25.2 version
  • Added 64bit support
  • Added Mojave support

New in SQLiteManager 4.6.8 (Dec 3, 2016)

  • Fix for WITH queries.
  • Updated FTC.
  • Fix a crash issue.
  • Improved HiDPI support.
  • Several other internal enhancements and fixes.

New in SQLiteManager 4.6.5 (Sep 21, 2016)

  • Performance enhancements.
  • Updated FTC to the latest 3.1.6 version.
  • Fixed an issue in HexEdit mode.
  • Fixed a parsing issue that could lead to a wrong constraint table type.
  • On Mac windows positions and size associated to each local database are now preserved.
  • If database contains some data then default to Data tab on open.
  • Various fixes and improvements.

New in SQLiteManager 4.6.0 (Jul 19, 2016)

  • Improved SQL parser engine.
  • Improved support for SQLCipher encrypted databases.
  • Improved support for Windows 8 and Windows 10.
  • Updated sqlite to the latest 3.13.0 version.
  • Updated SQLCipher engine to the latest 3.4.0 version.
  • Other improvements and fixes.

New in SQLiteManager 4.4.0 (Aug 12, 2015)

  • Added support for SQLCipher encrypted databases.
  • Fixed clustered primary keys in Table design.
  • Updated sqlite to the latest 3.8.11.1 version.
  • Greatly improved performance.
  • Fixed a delay issues while typing in the SQL pane.
  • Added a preference to disable syntax highlight in SQL pane.
  • Some RecordEditor improvements.
  • Better error reporting.
  • Fixed some issue in the Dump command.
  • Restored ALT/CRTL + RETURN shortcut in SQL pane.
  • Several issues fixed and other improvements.

New in SQLiteManager 4.3.5 (Oct 28, 2014)

  • Improved SQLCipher support.
  • Updated sqlite to the latest 3.8.7 version.
  • Fixed a delay issues while typing in the SQL pane.
  • Added a preference to disable syntax highlight in SQL pane.
  • Some RecordEditor improvements.
  • Better error reporting.
  • Fixed some issue in the Dump command.

New in SQLiteManager 4.3.3 (Sep 8, 2014)

  • Improved SQLCipher support.
  • Fixed some printing issues.
  • Fixed issue with dump command and encrypted databases.
  • Fixed issue with add/change/remove encryption commands.

New in SQLiteManager 4.3.0 (Jul 7, 2014)

  • Added support for SQLChiper encrypted databases.
  • Fixed clustered primary keys in Table design.
  • Several issues fixed.
  • Other improvements.

New in SQLiteManager 4.2.11 (May 9, 2014)

  • Several issues fixed.

New in SQLiteManager 4.2.10 (May 7, 2014)

  • Restored ALT/CRTL + RETURN shortcut in SQL pane.

New in SQLiteManager 4.2.9.1 (Apr 30, 2014)

  • Small issues fixed.
  • Minor improvements.

New in SQLiteManager 4.2.9 (Apr 16, 2014)

  • Added Export query in SQL pane.
  • Fixed a Foreign Key issue in some custom alter table commands.
  • Fixed some CSV import issues.
  • Updated underline text engine.
  • Updated sqlite to the latest 3.8.4.3 version.
  • Other small issues has been fixed.
  • A lot of other improvements.

New in SQLiteManager 4.2.7 (Oct 25, 2013)

  • Added Hex display for BLOB when no image representation can be derived.
  • Fixed an SQL Data export issue with cubeSQL.
  • Other small issues has been fixed.

New in SQLiteManager 4.2.6 (Aug 5, 2013)

  • Improved speed in InfiniteListBox.
  • Tables are now correctly altered in cubeSQL.
  • Fixed an issue with Inline Data Editor.
  • Other small issues has been fixed.

New in SQLiteManager 4.2.5 (Jul 29, 2013)

  • Restored sort by column header.
  • Fixed an issue with columns filters.
  • Better escape when importing.
  • Improved column escape algorithm.
  • ESC key now close popover panel.
  • A lot of small bugs has been fixed.

New in SQLiteManager 4.2.1 (Jul 25, 2013)

  • Sandbox related issues fixed.
  • Added support for hex encryption keys.
  • Fixed a random MacOS crash on startup.
  • Fixed duplicated filters issue in Data pane.
  • Improved Export performance.
  • Improved Bug/Crash reporter.
  • Several bugs fixed.
  • Various performance improvements.

New in SQLiteManager 4.2.0 (Jul 15, 2013)

  • Added support for Application ID in Database Settings.
  • dded Lua examples (query and save to a file).
  • Improved performance when opening databases with a large numbers of tables/triggers/views.
  • Windows version now close properly when document is closed.
  • Tabs are now preserved in Lua scripts.
  • Updated sqlite to the latest 3.7.17 version.
  • Various bugs has been fixed in this version.
  • Various performance improvements.
  • Some other minor features added.

New in SQLiteManager 4.1.0 (Apr 9, 2013)

  • Fixed a vertical scrollbar issue.
  • Fixed an import issue into a new table where first row was not properly converted to column names.
  • Fixed an issue with new rows in Record Editor.
  • Updated sqlite to the latest 3.7.16.1 version.
  • Added UNICODE61 tokenizer.
  • MacOS X version now requires 10.7 or higher.

New in SQLiteManager 4.0.9 (Mar 9, 2013)

  • Fixed a random MacOS crash on startup.
  • Fixed duplicated filters issue in Data pane.

New in SQLiteManager 4.0.8 (Mar 7, 2013)

  • Added support for hex encryption keys.
  • Several bugs fixed.
  • Improved Export performance.
  • Improved Bug/Crash reporter.
  • Various performance improvements.

New in SQLiteManager 4.0.7 (Feb 21, 2013)

  • Fixed some Import related issues.

New in SQLiteManager 4.0.6 (Feb 19, 2013)

  • Fixed a startup crash bug for MacOS X 10.6.x and 10.7.x

New in SQLiteManager 4.0.5 (Feb 19, 2013)

  • SQLiteManager is now Retina ready.
  • Fixed a small Create Encrypted Database issue.
  • Fixed all Import related bugs.
  • Improved Export sql handling.
  • Fixed a Design pane resize issue.
  • Fixed several issues related to Data and SQL panes.
  • Fixed minor issues related to the Log pane.
  • Added tooltips for all custom buttons.
  • Data can now be sorted in the Data pane.
  • Added vertical scrollbar to source listbox.
  • SQL paste command now by default strip off style information.
  • A lot of more others fixes and improvements.

New in SQLiteManager 4.0.1 (Dec 13, 2012)

  • Application has been rewritten from scratch.

New in SQLiteManager 3.9.5 (May 16, 2012)

  • Fixed foreign key issues in the table editor

New in SQLiteManager 3.9.1 (May 9, 2012)

  • Fixed an issue related to UTF-16 encoded databases.

New in SQLiteManager 3.9.0 (Apr 12, 2012)

  • Fixed an ALTER TABLE bug that could result in an empty table
  • Fixed a cubeSQL bug that could result in not committed sql statements
  • Upgraded sqlite to the latest 3.7.11 version

New in SQLiteManager 3.8.5 (Dec 16, 2011)

  • Numeric values in numeric columns are now correctly inserted as numbers
  • Fixed an issue related to ALTER TABLE and self referencing columns
  • Updated HexEngine in Record Editor
  • Added the possibility to change columns order during Index creation
  • Fixed an issue related to comments in SQL statements
  • Fixed an issue related to the ALTER TABLE command and cubeSQL
  • Fixed some issues in the Record Editor
  • Fixed UPDATE OF trigger creation
  • REAL (SQL) Server is now supported using the new cubeSQL plugin
  • Updated sqlite to the latest 3.7.8 version
  • Improved documentation
  • Others small changes and optimizations

New in SQLiteManager 3.8.0 (Jun 28, 2011)

  • Updated sqlite to version 3.7.6.3
  • Added native cubeSQL server support
  • Improved reserved tables and columns names handling
  • Added a new preference to hide/show full database paths
  • Improved SQL import/export capabilities
  • Improved Triggers support
  • Improved Table Editor with full foreign keys support
  • Rewritten Record Editor with much improved usability
  • Improved BLOB Preview (double click on a BLOB now opens the Preview panel)
  • Fixed a flick issue on Windows
  • Fixed an issue related to .shm and .wal files
  • RSReports has been updated to the latest 2010.2.2 version
  • Scripts and Plugins on Mac are now located inside user/Library/Application Support/SQLiteManager, on Windows XP are located in /user/Application Data/SQLiteManager and in Windows 7 are located inside /user/AppData/Roaming/SQLiteManager
  • A lot of other small fixes and optimizations

New in SQLiteManager 3.7.0 (Jan 26, 2011)

  • Fixed a bug that occurs when multiple rows was selected in the Manage panel
  • Added the ability to search for NULL values in the Manage panel
  • SQLite databases can now be saved with a .db extension
  • Fixed small issues related to editing fields in inline mode
  • Other small fixes and optimizations

New in SQLiteManager 3.6.6 (Dec 13, 2010)

  • Fixed a crash bug in record edit feature.

New in SQLiteManager 3.6.5 (Dec 10, 2010)

  • Fixed some cosmetic issues
  • Fixed a small issue related to the Manage panel
  • Updated analyzer utilities
  • Other small fixes

New in SQLiteManager 3.6.0 (Dec 6, 2010)

  • Updated SQLite to version 3.7.3 with WAL support
  • Added support for full path in the Recent menu
  • Added some sanity checks
  • Fixed an import from mySQL sql bug
  • Fixed all Foreign Keys related bugs in the Table editor
  • Fixed some issues related to the Manage panel
  • A lot of other small fixes and optimizations

New in SQLiteManager 3.5.1 (Aug 26, 2010)

  • SQLite database files are now correctly associated on Mac
  • Fixed some cosmetic Win32 issues
  • Fixed an issue while computing purchase date from the serial number
  • Fixed an issue related to some reserved table names in the Manage tab
  • Other small fixes
  • Relaxed some demo limitations

New in SQLiteManager 3.5.0 (Jul 20, 2010)

  • Added a new detailed analyzer feature
  • Added Foreign Key support
  • Added a Copy RecordSet new menu item
  • Added Views to the Export dialog
  • Brand new CREATE/ALTER table dialog
  • Improved the importer engine
  • Improved the exporter engine
  • Improved display of BLOB images
  • Improved NULL values handling
  • Improved handling of table names that contains special characters
  • Improved both the Manage and SQL panel
  • Fixed a Win32 Edit Table menu issue
  • Fixed a couple of minor Win32 related issues
  • Fixed a case insensitive bug in inline editing
  • Fixed a bug that occurs while updating a row that contains BLOB columns
  • Fixed some issues related to BOOLEAN values
  • Fixed an issue that occurs while editing values with an sqlite 2 database
  • Fixed the incorrect Database Seems Encrypted message
  • Fixed an issue related to the RSReport engine
  • Fixed an issue related to saved SQL commands
  • Updated sqlite to the latest 3.6.23.1 version
  • Updated DoD ListBox to version 2.3
  • Updated User's Manual and RBScript Manual
  • Updated Language Reference
  • Updated SQLite3ProfessionalPlugin to version 3.9
  • Updated RSReport engine to version 2010.2.1
  • A lot of other small fixes and optimizations

New in SQLiteManager 3.1.0 (Aug 18, 2009)

  • Fixed a COMMIT issue in the Record Editor.
  • Views now work correctly in the Manage panel.
  • Fixed an annoying bug on Windows that could lead to have multiple instance of the app running in background.
  • Updated sqlite library to the latest 3.6.17 version.
  • Other small fixes and optimizations.

New in SQLiteManager 3.0.5 (Aug 6, 2009)

  • Fixed an obscure bug in the csv import engine.
  • Changed the way the Wizard dialog behaves on Windows in order to fix a lot of related issues.

New in SQLiteManager 3.0.4 (Jul 28, 2009)

  • Keyboard equivalent for Script Manager is now associated to the Y key instead of the H key.
  • Fixed an issue that incorrectly reported that a database with zero length was recognized as encrypted.
  • Fixed an issue related to the reset of the scrolling position after each query.
  • Fixed a potential crash on Windows that occurred in the password dialogs.
  • Added support for the special : character in table names.
  • Syntax highlight is now automatically disabled if an editfield contains more than 1024 characters.

New in SQLiteManager 3.0.3 (Jul 8, 2009)

  • Fixed a crash bug in the Manage Listbox.
  • Fixed an issue related to the horizontal scrollbar in the Manage and SQL Listboxes.

New in SQLiteManager 3.0.2 (Jul 4, 2009)

  • Fixed an incorrect serial number related message.
  • Fixed a [INDEX] issue in the report generator.
  • Fixed a possible "Out Of Bounds" exception in the Manage Panel.
  • Improved error handling in the CSV import engine.
  • Added a new update engine.

New in SQLiteManager 3.0.1 (Jul 3, 2009)

  • Adds a new Chart panel to visualize data (Line, Bar, Pie, Venn, Scatter, Radar, Map, and QR Code).
  • A new record editor.
  • A table editor with full support for altering existing tables.
  • A CSV import engine with support for multi-gigabyte files.
  • An improved export engine.
  • Interface improvements and other updates.