Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Renaud Lepage: "I was searching for a powerful server management as well as data management application, that could also have the ability to use stored procedures (MySQL5). I was using many separate apps. And then I stumbled upon this application. It just got better. With ease-of-use, powerful management, a very good level of customization, great MySQL server management and the very lushed graphical interface, MySQL Maestro is a product to consider seriously. I chose MySQL and this, to SQL Server 2000 and the MMC-integrated server management, for use in a programming course. I'm telling you, MySQL Maestro is a very powerful tool. Try it, you won't regret it".
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

More

Add your opinion

SQL Maestro Group / News / All company news / SQL Maestro for MySQL 15.5 released

SQL Maestro for MySQL 15.5 released

May 14, 2015

Prev Next
SQL Maestro for MySQL

SQL Maestro Group is happy to announce the release of SQL Maestro for MySQL 15.5, a powerful Windows GUI solution for MySQL administration and database development.

Please consider the list of new features implemented in this version since the last official release:

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.
    Managing generated columnsPicture 1. Managing generated columns
    In Data Grids and Data Input Forms generated columns are marked by a green calculator.
    Generated columns in the Data GridsPicture 2. Generated columns in data grids
  • 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.
    Creating a fulltext indexPicture 3. Creating a fulltext index
  • 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.
    Editing a timestamp fieldPicture 4. Editing a timestamp field
  • 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.
    Custom SQL scripts settingsPicture 5. Custom SQL scripts settings
  • 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 encryptionPicture 6. Data encryption
  • 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.
    Colored tabsPicture 7. Colored tabs
    For the same purpose tab hints now include the profile name.
    Tab hintsPicture 8. Tab hints
  • Starting with this version a warning message appears on creating a table without a primary key.
    Missing primary key warningPicture 9. Missing primary key warning
  • Data Export: from now on it becomes possible to specify caption, width, and alignment for output columns (when applicable).
    Data Export: customizing output columnsPicture 10. Data Export: customizing output columns
    Also it becomes possible to add current timestamp to the output file name.
    Data Export: adding current timestamp to output file namePicture 11. Data Export: adding current timestamp to output file name
  • 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 Import: working with empty valuesPicture 12. Data Import: working with empty values
  • 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 Input Form: marking important controlsPicture 13. Data Input Form: marking important controls
  • Data Grid: to reset all grid settings to defaults, open the Data tab when holding the Ctrl key.

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

Related links:

SQL Maestro for MySQL home page
Download SQL Maestro for MySQL
Get SQL Maestro for MySQL Tour
Purchase your license of SQL Maestro for MySQL today!
Prev Next