SQL Maestro for MySQL 9.2 released

Feb 3, 2009

SQL Maestro Group is happy to announce the release of SQL Maestro for MySQL 9.2, a powerful Windows GUI solution for MySQL administration and database development. Please consider the list of new features implemented in this version since last official release:

• 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).
  
  

• 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.
  
  

  

  
  
• 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.
    
    

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

Related links:

Back to news archive