Softpedia >Windows >Internet >Servers >Database Utils >SQL Maestro for MySQL >  Changelog

SQL Maestro for MySQL Changelog

What's new in SQL Maestro for MySQL 17.5.0.2

Aug 7, 2017
  • New feature highlights:
  • This version has been successfully tested with all MySQL versions from 4.1 to 8.0.1 (the latest MySQL development version available at the moment) as well as with MariaDB 10.0, 10.1, and 10.2.
  • Direct support for a number of MariaDB-specific features has been implemented. The list of currently supported features is as follows:
  • Roles. Starting from this version you can create, edit, and delete roles as well as grant them permissions.
  • To grant a permission for a database object (table, view, procedure, etc) to a role, you can use either the Grants tab of the Role editor or the Permissions tab in the object editor.
  • Check Constraints. From now on you can add, edit, and drop named check constraints at the Checks tab of the Table Editor.
  • Virtual (Computed) Columns. Values of such columns are automatically calculated using a deterministic expression, in particular from the values of other fields in the table. Both persistent and pure virtual columns are supported.
  • In Data Grids and Data Input Forms virtual columns are marked by a green calculator.
  • Default values for text and BLOB columns can now be specified in Field Editor. Also it becomes possible to select some predefined default values such as CURRENT_USER() or CURRENT_ROLE() from the list instead of entering them manually.
  • The Aria storage engine is now supported.
  • Support for roles introduced in MySQL 8.0 has been also implemented. As MySQL currently has no 100% reliable way to distinguish a role and a user, we decided to consider a principal to be a role if the corresponding account is locked and the account's password is expired.
  • Starting from this version it is possible to specify a custom label and/or a font color for server nodes in the Database Explorer tree.
  • To change these properties, right-click a server node, select "Edit Server Properties" from the popup menu and provide the values you need in the modal dialog.
  • 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.
  • Data Grid: now it is possible to copy the value of the selected cell to Clipboard using grid's popup menu or Ctrl+Shift+C shortcut.
  • The "Show SQL Help" command now displays the manual that corresponds the version of the database server you are connected to. This means it will display this page if you are working with MySQL 5.7, this one if you are working with MySQL 5.6, and so on.
  • 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).
  • Default Data Import settings can now be set up in the Program Options dialog.
  • Data Import defaults
  • "Show special chars" and "Convert tabs to spaces" options have been added to the Editor settings.

New in SQL Maestro for MySQL 15.5.0.3 (Aug 4, 2015)

  • Server management extensions:
  • This version has been successfully tested with all recent MySQL versions up to 5.7.7 rc (the latest MySQL 5.7 milestone release available at the moment).
  • Support for generated columns has been added (MySQL 5.7.6+). Values of such columns are computed from an expression provided in the Formula edit box. Both stored and virtual columns are supported.
  • In Data Grids and Data Input Forms generated columns are marked by a green calculator.
  • Support for InnoDB fulltext indexes has been implemented (MySQL 5.6+). Such indexes are created on text-based columns to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as stopwords.
  • The "Set to current timestamp on update" option has been added to Field Editor. It is available for timestamp fields (all MySQL versions) as well as for datetime fields starting from MySQL 5.6.5.
  • The Backup Database tool now works fine with MySQL 5.6 and 5.7 databases.
  • Interface improvements:
  • From now on it becomes possible to execute custom SQL scripts in all database connections established by the software.
  • 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.
  • Starting from this version 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. The color can be specified at the Options tab in the Database Profile Properties dialog.
  • Starting with this version 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).
  • Data Import: starting from this version it is possible to import empty values as empty strings (while previous versions always imported such values as NULLs).
  • 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 SQL Maestro for MySQL 14.2.0.1 (Feb 4, 2014)

  • Server management extensions:
  • This version of the software has been successfully tested with all the modern MySQL versions up to MySQL 5.7.3 (the latest version available at the moment). We have also implemented support for some MySQL 5.7 new features
  • Now it is possible to define multiple triggers for a given table that have the same trigger event and action time to fire in a specified order. By default, the triggers activate in the order they were created.
  • Starting from this version SQL Maestro for MySQL generates the ALTER TABLE ... RENAME INDEX statement to rename an index (instead of DROP/CREATE).
  • Support for the password-expiration capability has been implemented (MySQL 5.6+). This feature allows you to expire a password for any account in a single click.
  • A new implementation of HTTP tunneling based on MySQLi PHP extension has been added. The installation folder now contains two connection scripts: mysqli_tunnel.php and mysql_tunnel.php. We would recommend you to use the mysqli_tunnel.php script always if possible as it operates through the modern MySQLi PHP extension (available since PHP 5) while mysql_tunnel.php uses the original MySQL PHP API that is deprecated as of PHP 5.5.
  • Support for keyboard interactive SSH authentication has been implemented. This method provides for a multiple challenge-response dialog with the user in which the server sends a text query to the user, the user types in a response, and this process can repeat any number of times to ensure that the client is a human.
  • Starting from this version it is possible to change the default database character set and collation (these settings are used as default values for newly created tables if the table character set and collation are not specified explicitly). To modify the default character set and/or collation for a database, you must have the ALTER privilege on this database.
  • Support for the bit data type has been significantly improved
  • Starting from this version the columns of bit(1) data type are represented in the data grids as checkboxes (the checked state corresponds to the value '1', and the unchecked one to the value '0').
  • The values of the bit(m), m > 1 data types are now displayed and edited as the corresponding integers from 0 to 2m - 1. For example, binary literals b'0111' and b'1010' are represented in the data grid as 7 and 10, respectively.
  • Binary literals used as default values for columns of bit data type are now displayed correctly in the table's SQL definition.
  • The time of the table creation is now displayed in the Table Editor, Database Editor, and Object Browser.
  • Interface improvements:
  • Nullable Column Checker has been implemented. This feature allows you to refactor your database schema by enforcing omitted NOT NULL constraints. It is useful, for example, if you have got a legacy schema with a lot of columns allowing NULL values and plenty of data. To invoke the wizard, use the appropriate link in the Generate SQL section of the table popup menu at the Explorer tree.
  • Advanced data grid features such as lookup editors and column header images become available on working via an HTTP tunnel.
  • Data Import features
  • Starting with this version it's possible to import data from several files at a time. To import data from multiple files with the same structure, set the mask of the file names to the corresponding field. To see the list of matching files, use with the button on the right.
  • The Column Builder for text files with fixed column width has been redesigned. Now to set the correspondence between table columns and areas of a text file, you can either input offset and width for each column directly into the controls, or define these values by clicking the left mouse button in the right area of the tool.
  • Now it's possible to add current timestamp to the log file name using the %ts:TIMESTAMP_FORMAT% string template. Examples of valid datetime formats are: 'YYYY-MM-DD', 'YYYY-MM-DD-HH24-MI', 'YYYY-MM-DD-HH24-MI-SS', and so on.
  • 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.
  • Data Export: Support for Json file format has been implemented.
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

New in SQL Maestro for MySQL 12.12.0.1 (Dec 20, 2012)

  • Server management extensions:
  • This version has been successfully tested with all the recent MySQL versions up to 5.6.9 RC.
  • Get SQL Dump wizard has been significantly updated
  • Now it is possible to rename output columns in the result SQL script. To set a new target column name, enter a value to the Target column in the grid at the first step of the wizard.
  • You can also change the order of output columns using the appropriate commands of the popup menu or Ctrl+Up and Ctrl+Down shortcuts.
  • Starting with this version it is possible to specify the SQL syntax the result script to be written on. This feature allows you to restore the dump contents to a table in a different database server such as PostgreSQL, SQL Server, Oracle, Firebird, or SQLite.
  • 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 (did you know about such a possibility?), 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.
  • Hints for foreign key columns now include the name of the parent table.
  • Script Runner allows now to execute archived scripts directly from .zip files. The tool unpacks zip archives to temporary files by itself for further executing.
  • Data Grid features
  • Multi-column lookup editors become available. Such editors modify values of several columns in the record simultaneously in order to guarantee referential integrity.
  • Now the headers of primary and foreign key columns are marked with the 'gold key' and 'silver key' images accordingly as well as the headers of required columns are marked with a red asterisk. 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 SQL Maestro for MySQL 12.3.0.1 (Aug 28, 2012)

  • Server management extensions:
  • Starting with this version you can backup the whole database as well as the selected tables with the Backup Database tool that actually automates your work with the mysqldump client. This piece of the software combines a convenience of a user-friendly interface with a power and flexibility of the original utility and allows you to specify any option available in mysqldump in the easiest possible way. The result command can be executed immediately and/or saved to a batch file for further using. To invoke the Backup Database window, select the corresponding item from the Tools menu.
  • Interface improvements:
  • 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.
  • SQL Editor with Unicode support:
  • 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.
  • Change markers:
  • 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.
  • Code Folding:
  • Now when entering a function or stored procedure call, a function parameter hint box can be displayed detailing the types of parameters that should be entered within the parentheses of the function call. To get the hint box displayed, place your cursor between the parentheses of the function call and press Ctrl+Shift+Space.
  • The function parameter hint box:
  • Drag-n-drop from Windows Explorer has been added to SQL Editor and SQL Script Editor. Now to open a file in one of the 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.
  • 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.
  • Data Grid: inline images:
  • Data Input Form has been significantly improved. Now it simplifies the input of data with lookup menus for columns linked with foreign keys and ENUM columns, a calculator for DECIMAL columns, and check box groups for SET ones. The form can be invoked now with Ctrl+Alt+D shortcut.
  • Data Input Form:
  • 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.
  • Creating a new index:
  • Foreign key references i.e. foreign keys created in other tables and referencing for columns of the current one, are now displayed well.
  • 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.
  • BLOB Viewer: representing 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 SQL Maestro for MySQL 11.6.0.3 (Oct 27, 2011)

  • Server management extensions:
  • Now it's allowed to create DML procedures automatically. These procedures are the most efficient choice for accomplishing the CRUD operations (Create, Read, Update, and Delete).
  • It is possible to create the procedures 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 DML Procedures wizard accordingly.
  • New version also allows you to generate updatable views for all or selected tables (in the same manner).
  • Starting with this version our software automatically checks the database connection physical status and displays the notification window if the connection is broken. This window allows you either to reconnect or to close the connection.
  • Interface improvements:
  • Table Editor features:
  • 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 table or view, or even from a data set from a different DBMS especially if it is opened with an appropriate our product.
  • An ability to upload files as BLOBs into a table has been implemented. 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.
  • 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.
  • Now the application allows you to use Code snippets, segments of reusable code that you can copy into the editor. The feature is available from SQL Editor, SQL Script Editor, and editors of objects containing SQL bodies (such as views, triggers, etc.) with the corresponding item of the popup menu or with Ctrl+J shortcut.
  • Data Analysis tool has been updated:
  • 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.
  • 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).
  • 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.
  • 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: now you can view all columns included in a foreign key by selecting the relation based on the foreign key.
  • Application Options: now it's possible to specify default directories for data export/import/extract/etc to be used on database profiles creating.
  • Table Editor Options: starting with this version it's possible to allow the application to open details at the Data tab automatically.

New in SQL Maestro for MySQL 10.6.0.2 (Aug 17, 2011)

  • New version features tools to generate CRUD stored procedures and updatable views, data import from ODBC data sources, updated Data Analysis tool, and other useful things.

New in SQL Maestro for MySQL 10.5.0.1 (May 17, 2010)

  • New version introduces support for key-based authentication and SSH-2 protocol, insert-or-update data import mode, displaying of MySQL warning messages, and some other new features.

New in SQL Maestro for MySQL 9.9 (Sep 30, 2009)

  • Features database profile management extensions, completely redesigned Data Import and Data Export wizards, cross-database queries in Visual Query Builder and a lot of other interface improvements.

New in SQL Maestro for MySQL 9.2.0.1 (Feb 13, 2009)

  • Server management extensions:
  • Starting with this version it is possible to manage (create, edit and drop) remote servers i.e. servers that can be later used when creating tables with the FEDERATED storage engine (MySQL 5.1.15 and higher). To create a federated table using such a server, set the Connection property to 'server_name/table_name' within the Create Table wizard.
  • 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 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).
  • Field Editor: now it is possible to select some predefined default values such as CURRENT_USER for the string columns or CURRENT_TIMESTAMP for TIMESTAMP columns from the list instead of entering them manually.
  • Interface improvements:
  • 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.
  • Tabbed MDI interface: a popup menu has been added to each tab.
  • An Italian localization is now included into the installation package.
  • Data grid features the following things:
  • 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.
  • The contents of string columns can now be encrypted using the md5 algorithm.

New in SQL Maestro for MySQL 8.10.0.1 (Oct 22, 2008)

  • Master-detail data views
  • Lookup editors
  • Improved Data Import wizard

New in SQL Maestro for MySQL 7.2 (Apr 19, 2007)

  • MySQL Maestro has been successfully tested with the latest MySQL versions up to 5.0.27, 5.1.15 beta and 5.2 alpha;
  • Support of the Falcon storage engine from MySQL 5.2 is implemented;
  • The main feature of the new version is the Graphical Database Designer - a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your MySQL databases. Each diagram displays the tables of your database and the relationships between them;
  • Handy tools of Designer allow you to create new and edit existing tables and references;
  • The reverse engineering feature will help you to understand the schema structure and make its modification in an easy and clear way;
  • Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc;
  • A rich set of options and settings give you a way to see your database in your own look and feel style.
  • A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
  • SQL Editor: now MySQL 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);
  • The hint for foreign keys now contains such information as foreign table name and field correspondence