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

Subscribe to our news:
Partners
Testimonials
Peter W Rasmussen: "Just checking out on MySQL Maestro - really nice product".
Grey: "We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

More

Add your opinion

Customers
SQL Maestro Group / News / SQL Maestro for MySQL 17.5 released

SQL Maestro for MySQL 17.5 released

May 22, 2017

Prev Next
SQL Maestro for MySQL

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

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

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.
      Role Editor (MariaDB)Picture 1. Role Editor (MariaDB)
      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.
      Managing Table PermissionsPicture 2. Managing Table Permissions
    • Check Constraints. From now on you can add, edit, and drop named check constraints at the Checks tab of the Table Editor.
      Check EditorPicture 3. Check 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.
      Managing generated columnsPicture 4. Managing virtual columns
      In Data Grids and Data Input Forms virtual columns are marked by a green calculator.
      Generated columns in the Data GridsPicture 5. Virtual columns in data grids
    • 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.
      Predefined Default ValuesPicture 6. Predefined Default Values
    • 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.
    Role Editor (MySQL)Picture 7. Role Editor (MySQL)
  • 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.
    Explorer Tree: custom labels and colorsPicture 8. Explorer Tree: custom labels and colors
    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.
    Edit Server Properties dialogPicture 9. Edit Server Properties 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.
    Database Profile StatisticsPicture 10. Database Profile Statistics
  • 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.
    Data Grid: copy cell valuePicture 11. Data Grid: copy cell value
  • 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.
    Show SQL Help commandPicture 12. Show SQL Help command
  • 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).
    BLOB EditorPicture 13. BLOB Editor
  • Default Data Import settings can now be set up in the Program Options dialog.
    Data Import defaultsPicture 14. Data Import defaults
  • "Show special chars" and "Convert tabs to spaces" options have been added to the Editor settings.
    Editor OptionsPicture 15. Editor Options

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

Related links:

Prev Next
Back to news archive