Softpedia >Windows >Internet >Servers >Database Utils >SQLite Maestro >  Changelog

SQLite Maestro Changelog

What's new in SQLite Maestro 21.5.0.1

May 5, 2021
  • New feature highlights:
  • SQLite Maestro has been successfully tested with the recent SQLite versions. The latest available library (3.35.5) is now included into the installation package.
  • Added new database encryption algorithms. From now you can encrypt your database using the following encryption algorithms: ChaCha20, AES128, AES256, SQLCipher and RC4 (thanks to SQLite3 Multiple Ciphers project).
  • The "Manage database encryption" window has been updated. Now it is possible to specify the encryption algorithm for a database.
  • Note: In the previous versions of the software the AES128 encryption algorithm was used to encrypt databases.
  • Support for generated columns has been added (SQLite 3.31). Values of such columns are automatically computed based on a predefined expression. Both stored and virtual columns are supported.
  • To create a generated column, just provide the generation expression in the Formula edit box.
  • In Data Grids and Data Input Forms generated columns are marked by a green calculator.
  • Support for renaming (SQLite 3.25) and dropping (SQLite 3.35) columns using ALTER TABLE statement has been implemented. Previously, to implement such operations it was required to create a new table with the updated structure, copy data from the original table to the new table, drop the original table and then rename the new table to the name of the original table. Now, it is done with a single command.
  • Starting with this version TRUE and FALSE default values are recognized in a data grid. TRUE and FALSE constants has been added also to the list of predefined default values of boolean fields.
  • The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.

New in SQLite Maestro 16.11.0.5 (Aug 7, 2017)

  • New feature highlights:
  • SQLite Maestro has been successfully tested with the recent SQLite versions. The latest available library (3.15) is now included into the installation package (thanks to the wxSQLite3 team).
  • Support for the FTS5 extension has been implemented. FTS5 currently provides the best possible support for full-text search operations and includes various fixes and solutions for problems that could not be fixed in FTS4 without sacrificing backwards compatibility.
  • Support for indexes on expressions has been added. Such indexes are useful to obtain fast access to tables based on the results of computations.
  • Data Import features:
  • Starting from this version it is possible to import empty values as empty strings (while previous versions always imported such values as NULLs).
  • Default Data Import settings can now be set up in the Program Options dialog.
  • Data Export: now it becomes possible to add current timestamp to the output file name.
  • From now on it becomes possible to execute custom SQL scripts in all database connections established by the software.
  • Support for Adobe Reader DC has been added to BLOB Editor. Also the editor window now saves its size and position between times it is opened (for each table).
  • Support for a number of new encryption algorithms has been added to Data Grid. Now it is possible to encrypt the value of a text column, for example, by SHA512 or Haval224 algorithm with a couple of mouse clicks.
  • Data Input Form: controls containing values of primary and foreign key columns are now marked with the 'gold key' and 'silver key' images accordingly. Controls containing values of required (NOT NULL) columns are marked with a red asterisk.
  • Data Grid: To reset all grid settings to defaults, open the Data tab when holding the Ctrl key.

New in SQLite Maestro 15.1.0.4 (Aug 3, 2015)

  • The latest available library (3.8.7.4) is now included into the installation package.
  • Support for user authentication and management has been implemented (SQLite 3.8.7+). It is now possible to create new users, edit existing ones as well as remove users.
  • You can connect to a database in read-only mode. The appropriate option can be found at the Connection tab in the Database Profile Properties window.
  • Algorithm of generating SQL script for table recreation has been improved: now trigger definitions are placed after the data insertion statements.
  • SQL Formatter now understands SELECT statements containing the COLLATE clause.
  • It is possible to select a tab color for windows that belong to a certain database. This could help you to distinguish windows with the same caption but a different parent database (such as SQL Editor) with ease.
  • A warning message appears on creating a table without a primary key.
  • Data Export: from now on it becomes possible to specify caption, width, and alignment for output columns (when applicable).

New in SQLite Maestro 12.11.0.1 (Nov 26, 2012)

  • Server management extensions:
  • SQLite Maestro has been successfully tested with the recent SQLite versions. The latest available library (3.7.14.1) is now included into the installation package (special thanks to the wxSQLite3 team).
  • Support for some advanced FTS4 options has been added. Also all full-text search tables are now marked with a special image in the Explorer tree to improve the usability.
  • Support for the XML data type has been implemented. The values of this data type now can be inserted/updated in a modal editor with the XML syntax highlighting.
  • Support for binary stored GUIDs has been added. To instruct SQLite Maestro how to interpret values of the GUID data type, select the appropriate option in the Edit Database Profile dialog.
  • Starting from this version the Get SQL Dump tool by default generates multi-insert statements for SQLite 3.7.11 and higher.
  • All the missing SQLite functions and pragmas have been added to the Code Completion list that can be invoked by pressing Ctrl+Space in any editor.
  • The .sqlite file extension has been added to the Select Database dialog.
  • Interface improvements:
  • This version comes with Report Designer, a simple-to-use and elegant tool to prepare data for reading, viewing, and printing in a polished look.
  • Use this tool to create database reports using drag-and-drop functionality and rich formatting options. To invoke the window, use the Main Menu | Tools | Report Designer menu item.
  • The Start Page has been redesigned in order to provide quick access to recently connected database profiles and display the latest company news.
  • SQL Editor features
  • Now on executing several statements from a single editor tab, the corresponding result tab is marked with an appropriate image.
  • Starting from this version you can copy the selected text from any editor to Clipboard as a ready-to-use string written in one of the following programming languages: C#, C++, Delphi (Object Pascal), and Java. This feature is accessible in the Export section of the editor area popup menu.
  • Database Explorer: now it is possible to assign a custom color to a certain database profile. For example, you can mark development and production databases in different colors in order to prevent casual metadata or data changes in the production. The desired color can be selected at the Options tab in the Edit Database Profile dialog.
  • Check editor: an ability of editing check condition in a separate window has been added.
  • Hints for foreign key columns now include the name of the parent table.
  • Drag-n-drop from Windows Explorer to SQL Editor and SQL Script Editor has been added. Now to open a file in one of these editors, just drag it at Windows Explorer and drop at the editor area.
  • The performance of SQL Script Editor has been significantly increased especially on large script editing. In addition to this the name of the file loaded to the editor area is now displayed at the right bottom corner of the window.
  • Script Runner has been slightly changed in appearance and performance
  • Now the name of the database the script to be run on is displayed at the top of the window, the name of the script file may be quoted, and the script files in the UTF-8 encoding may optionally start with a byte order mark.
  • Starting with this version it's possible to execute archived scripts directly from .zip files. The tool unpacks zip archives to temporary files by itself for further executing.
  • Data Grid features
  • Now it is possible to display images directly in the grid. To enable/disable this view mode or change the image fitting, use the Manage inline images item of the column popup menu.
  • Multi-column lookup editors become available. Such editors modify values of several columns in the record simultaneously in order to guarantee referential integrity.
  • Data Input Form has been significantly improved. Now it simplifies the input of data with lookup menus for columns linked with foreign keys and a calculator for DECIMAL columns.
  • Now the headers of primary and foreign key columns are marked with the 'gold key' and 'silver key' images accordingly. The existence of any column marked with a gold key in the dataset means that you can modify/delete the records of this dataset without risk of updating/deleting several records at a time.
  • Data Import features
  • From now on it is possible to import data from CSV files that contain multi-line strings.
  • A possibility of setting the correspondence between source and target columns by column name has been implemented (previous versions allow you to set such a correspondence only by column index).
  • Data Export: now it is possible to specify decimal and thousand separators for the generated files (when applicable).
  • The progress windows are redesigned in the modern style and become more informative.
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

New in SQLite Maestro 12.1.0.1 (Jan 30, 2012)

  • Server management extensions:
  • SQLite Maestro has been successfully tested with the latest SQLite versions. The latest available library (3.7.10) is now included into the installation package.
  • Starting with this version our software supports SQLite Online Backups. The copy operation is processed incrementally, so the source database does not need to be locked for the duration of the copy, only for the brief periods of time when it is actually being read from. This allows other database users to continue uninterrupted while a backup of an online database is made. To invoke the wizard, use the Main Menu | Tools | Backup Database menu item.
  • Interface improvements:
  • The Change password dialog has been renamed to Manage encryption to better reflect its functionality and has been redesigned for more understandability. Now the database encryption management is simple and easy in access.
  • The SQL editor component has been dramatically improved (applied to SQL Editor, SQL Script Editor, and editors of objects containing SQL bodies such as views, stored procedures, and triggers):
  • Unicode support has been implemented. Starting with this version you can view and edit queries and scripts containing string literals in almost any possible language including, for example, Russian, Chinese and Japanese.
  • Also it becomes possible to load/save files in different encodings. If you try to save an SQL script containing non-locale characters to a file in an incompatible encoding, a warning about a potential loss of data will be issued.
  • Text change markers are now at your disposal. Yellow markers show changed but unsaved lines of code, and green markers show changes in this session that have been saved.
  • Now the application allows you to use Code snippets, segments of reusable code that you can copy into the editor. To insert a snippet into the edited text, use the corresponding item of the popup menu or Ctrl+J shortcut.
  • The code folding appearance has been updated. In particular, the new version introduces support for fold signs as well as improved look and feel of the folding margin and hints.
  • Table Editor features:
  • Another way of index creating has been implemented. Now you can create a new index directly from the Fields tab of the table editor. To add an index, select column(s) the new index to consist of and use the Create index on columns... command.
  • Foreign key references i.e. foreign keys created in other tables and referencing for columns of the current one, are now displayed well.
  • The Execute at cursor command has been added to SQL Editor (available in the Navigation bar or with Ctrl+F9 shortcut). Use this command to execute statements the cursor is over without selecting them.
  • Database Designer features:
  • Now you can view all columns included in a foreign key by selecting the relation based on the foreign key.
  • All print options are now preserved between sessions.
  • Visual Query Builder: the Create view from SQL link has been added to the Navigation panel. This feature allows you to create a view based on a SELECT query prepared within the builder as quickly as possible.
  • BLOB Viewer: starting with this version it's possible to view or edit BLOB data as PDF document.
  • Prepared database reports now run fine on UNIX systems.
  • Table Editor Options: starting with this version it's possible to allow the application to open details at the Data tab automatically.
  • A Spanish translation is now included into the installation package. Other available languages are English, German, French and Italian.
  • Data Import: now each time you start the wizard to import data to a table it stores all the options as them were set on the previous session of working with this table.

New in SQLite Maestro 11.3.0.1 (Mar 21, 2011)

  • Server management extensions:
  • SQLite Maestro has been successfully tested with the latest SQLite server versions. The latest available server library (3.7.5) is now included into the installation package.
  • Support for SQLite full-text search extension modules has been implemented (both FTS3 and FTS4 are supported). These extensions allow users to create special tables with a built-in full-text index (also known as FTS tables). The full-text index allows the user to efficiently query the database for all rows that contain one or more words, even if the table contains many large documents.
  • To display the FTS "shadow" tables (%_content, %_segdir, etc), turn on the Show system tables option in the Edit Database Profile dialog.
  • Now it's allowed to generate updatable views for your tables automatically. Moreover, the Insert, Update, and Delete operations can be enabled or disabled at your choice. It is possible to create a view for a single table or for several tables at once (even for all the tables in the database). To accomplish these tasks, use the popup menu of the corresponding node at the Explorer tree and the Main Menu | Object | Generate updatable views accordingly.
  • Interface improvements:
  • Table Editor features an ability to upload files as BLOBs into a table. The file names must contain the information on the record they need to be placed to: the files need to be named in the same manner and their names have to include content of one or several table columns that can uniquely identify each row.
  • Data Import: starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. Let's look through some details of the new feature:
  • To import data in this way, you have to specify a connection string and select appropriate identifier quote characters to escape improper symbols and blanks in object names according to the source database (for example, double quotes for Oracle and PostgreSQL, backticks for MySQL, or square brackets for SQL Server and MS Access).
  • Another thing to note is that this kind of import completely supports BLOBs (if they are supported by the ODBC driver / OLE DB provider used).
  • Application Options: now it's possible to specify default directories for data export/import/extract/etc to be used on database profiles creating.
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

New in SQLite Maestro 10.5.0.1 (Jun 1, 2010)

  • Support for native foreign keys has been added (SQLite 3.6.19 and higher). To enable/disable this feature, use the corresponding option within the Create Database Profiles or Edit Database Profile window. This option also affects the automatic creation of referential integrity triggers: they are NOT created if it is turned ON and vice versa.
  • Table Editor: a possibility of importing data from Clipboard has been implemented. It is supposed that columns within the data block are separated by the tabulation symbol, records are separated by newlines and the first line of the data block contains column headers.
  • The same data format is supported by a lot of other applications, so it is easy to use this feature to quickly copy data from MS Excel, another SQLite table or view, or even from a data set from a different DBMS especially if it is opened with an appropriate our product.
  • The Update Existing Records option has been added to the Data Import wizard. If this option is turned ON, the records will be either updated or inserted.
  • Data Analysis tool features the following things:
  • Starting with this version it is possible to use a wide spectrum of aggregate functions such as maximum, minimum, average value, etc. for subtotals (the only available function for the previous versions was sum of values).
  • A possibility of sorting data by summary columns has been added. This means, for example, the product you'll see first is not the one which starts with an A or Z, but rather the one that has the most or least sales.
  • You can also specify the number of top rows that are displayed to view, for example, only a specific number of best-selling or worst-selling products for each year, month, customer, etc. This will help you to concentrate on only the most important information and avoid being overload with a lot of superfluous data.
  • The Script Runner window can now be invoked directly from the Tools menu. Also the productivity of this tool has been significantly improved.
  • Data Grid: the Clone current record command has been added to the popup menu. Use it to add a new record which is substantially similar to an existing one.
  • BLOB editor: starting with this version it is possible to select a BLOB column to edit directly within the editor window.
  • The Case Insensitive option has been added to data grid filter settings (ON by default).
  • Starting with this version SQLite Maestro allows you to store your databases in the folders containing locale characters and/or use such characters in the database file names.

New in SQLite Maestro 9.10.0.1 (Oct 16, 2009)

  • Server management extensions:
  • Starting with this version SQLite Maestro allows you to specify SQLite extensions that are loaded automatically on connect to a database (SQLite 3.3.6 and higher). These extensions can contain such useful things as new SQL functions and collating sequences. Learn more about SQLite extensions.
  • Interface improvements:
  • Database profile management improvements:
  • Starting with this version it is possible to reorder database groups in the Explorer Tree as well as reorder databases from the same group. You can also sort database groups and databases in an alphabetical order.
  • Now all the database profiles related to the same group may be deleted at once.
  • The Rename Database Profile command has been added to the popup menu. Use this command to rename a profile without opening its editor.
  • Data Import wizard has been significantly updated:
  • Now you can import data from Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats along with Microsoft Office Excel 97-2003, Microsoft Office Access, CSV, DBF, and Text files supported in the previous versions.
  • Starting with this version you can import Text and CSV data files stored in different encodings.
  • Now it is possible to empty the target table as well as execute custom SQL scripts before and after import.
  • The wizard has been completely redesigned to improve the look and feel and increase the usability.
  • Data Grid features the following things:
  • Multi-column sorting has been implemented. To sort data on multiple columns, use the Advanced sort command from the grid's header popup menu.
  • Now you can fix grid columns to view them permanently when working with other grid data. To fix a column, choose the corresponding item from the grid's header popup menu.
  • Starting with this version the number of grouped records is displayed for the group's header.
  • SQL Editor: the Go to Line command has been added to the popup menu (Ctrl+G shortcut). Also field data types are now displayed in the Code completion window.
  • BLOB Viewer: Unicode support has been added to the Non-BLOB data grid.
  • BLOB Viewer/Editor: starting with this version it's possible to customize PHP syntax highlighting for the text representation of BLOBs.
  • Get SQL Dump: now you can specify the encoding on the generating dump to a file.
  • Database Designer: a possibility to select objects with Ctrl has been implemented.
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made

New in SQLite Maestro 9.3.0.4 (Mar 17, 2009)

  • Server management extensions:
  • SQL Editor: support for explicit transaction management has been implemented. Now you can execute queries either in autocommit mode (default behavior) or manage transactions manually. In the second case you have to issue the BEGIN TRANSACTION statement to start a transaction and explicitly end the transaction by COMMIT or ROLLBACK statements (it is also possible to use the corresponding links at the editor's navigation bar).
  • Auto-attached databases become available for remote connections.
  • Starting with this version it is possible to create referential integrity triggers together with a foreign key creation.
  • Interface improvements:
  • Data Export wizard has been significantly improved:
  • Now you can select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, Mac).
  • Support for Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats has been implemented.
  • The wizard has been completely redesigned to increase the usability. In particular, the export process now can be started at any step of the wizard.
  • Visual Query Builder has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs.
  • Trigger Editor: the Code Completion feature becomes available for the NEW and OLD keywords.
  • An Italian localization is now included into the installation package.
  • Data grid: starting with this version it is possible to allow displaying row numbers in grids. Of course you can adjust the corresponding column to yours liking.
  • Tabbed MDI interface: a popup menu has been added to each tab.

New in SQLite Maestro 8.11 (Nov 13, 2008)

  • New version provides support for transparent database encryption, remote database management extensions and some interface improvements.

New in SQLite Maestro 8.5 (Jun 1, 2008)

  • Version 8.5 features remote database management via HTTP tunneling, foreign keys support, column reordering and a lot of interface improvements.

New in SQLite Maestro 7.12 (Dec 14, 2007)

  • The most important thing added in this version is support of Unicode/UTF-8 data. For databases in UTF-8 encoding it is necessary to specify, which string fields are used to store Unicode data (available options are "Only nvarchar(xx) fields" and "All the string fields"). For databases in UTF-16 encoding no such actions required.
  • Create database wizard: now it is possible to specify the encoding (UTF-8 or UTF-16) for the new database.
  • It is now possible to execute SQL scripts after connect and before disconnect to/from a database.
  • Some new features are incorporated into SQL Editor and SQL Script Editor.
  • Now it is possible:
  • comment/uncomment selected text (Shift Ctrl . / Shift Ctrl , shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift Ctrl , having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
  • convert selected text to different cases (lower, UPPER, and NameCase);
  • export the contents of the editor to RTF and HTML formats (to file or to clipboard);
  • print/preview the contents of the editor.
  • The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object�s SQL definition (DDL) to the SQL Script Editor for future modifications;
  • Data grid: some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter);
  • Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool).

New in SQLite Maestro 7.9.0.1 (Sep 21, 2007)

  • Server management extensions:
  • Starting with this version it is possible to cancel a long running query execution (SQLite 3.x.x) and data fetching (all versions of SQLite).
  • SQLite Maestro does not lock connected databases anymore i.e. it is possible to connect to such databases using another software product e.g. the second instance of SQLite Maestro.
  • The contents of BLOB fields containing graphics is now saved correctly.
  • Interface improvements:
  • The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is fulfilled. It can be invoked with the aid of the Format SQL link on the SQL Editor's navigation bar (Ctrl Alt D shortcut).
  • BLOB Viewer: now it is possible to save all BLOBs from a table to a given directory.
  • Now our software displays execution time for lengthy operations.
  • Data Import Wizard: the speed of loading of Excel files has been significantly increased.
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

New in SQLite Maestro 7.7 (Jul 11, 2007)

  • Server management extensions:
  • The most important thing added in this version is support of Unicode/UTF-8 data. For databases in UTF-8 encoding it is necessary to specify, which string fields are used to store Unicode data (available options are "Only nvarchar(xx) fields" and "All the string fields"). For databases in UTF-16 encoding no such actions required.
  • Create database wizard: now it is possible to specify the encoding (UTF-8 or UTF-16) for the new database.
  • Interface improvements:
  • It is now possible to execute SQL scripts after connect and before disconnect to/from a database.
  • Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible:
  • comment/uncomment selected text (Shift Ctrl . / Shift Ctrl , shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift Ctrl , having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
  • convert selected text to different cases (lower, UPPER, and NameCase);
  • export the contents of the editor to RTF and HTML formats (to file or to clipboard);
  • print/preview the contents of the editor.
  • The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object�s SQL definition (DDL) to the SQL Script Editor for future modifications;
  • Data grid: some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter);
  • Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool).
  • In addition to this, several bugs were fixed and some other minor improvements and corrections were made.

New in SQLite Maestro 7.3 (Apr 19, 2007)

  • SQLite Maestro was successfully tested with the latest SQLite server versions up to 3.3.13.
  • SQL Editor: now SQLite Maestro can edit even very large SQL files. Also the speed of editor's work has been significantly improved;
  • SQL Editor: queries' tabs can now been displayed at the all sides of the editor (bottom, top, left or right);

New in SQLite Maestro 6.7 (Sep 11, 2006)

  • Server management extensions:
  • added support of Check constraints (SQLite 3.3);
  • improved Index Editor: implemented index sort ordering and index collating sequence (SQLite 3.3);
  • Interface improvements:
  • SQL Editor improvements: now you can execute each query in a separate thread in order to continue your work with the software while the query is executing;
  • SQLite Maestro wizards' windows are resizable now for more usability;
  • Now the server version can be viewed from the tool tip of the database node;
  • added an ability to edit object properties directly from the explorer tree without opening the object editor; it helps you to make your work with your SQLite database objects faster;
  • added an ability to rename an object directly from the explorer tree without opening its editor;
  • added more key shortcuts: a new query can be created in SQL Editor using the Ctrl N shortcut and deleted using the Ctrl R shortcut.
  • In addition to this, several bugs were fixed and some other minor improvements and corrections were made.