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

Subscribe to our news:
Partners
Testimonials
Dan Flazer: "Your new product and your assistance with us was excellent...will prove invaluable to the future of our company".
Peter Robinson: "

As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

More

Add your opinion

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

SQL Maestro for MySQL 14.2 released

Feb 3, 2014

Prev Next
SQL Maestro for MySQL

SQL Maestro Group is happy to announce the release of SQL Maestro for MySQL 14.2, 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 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.

      Multiple trigger creation: setting the trigger order.Picture 1. Multiple trigger creation: setting the trigger order.

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

      User Editor: setting a password as expired.Picture 2. User Editor: setting a password as expired.

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

    Connecting via MySQLi based HTTP tunnelPicture 3. Connecting via MySQLi based HTTP tunnel

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

    SSH Options: keyboard interactive authenticationPicture 4. SSH Options: keyboard interactive authentication

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

    Database Editor: changing the default collation.Picture 5. Database Editor: changing the default collation.

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

      Data Grid: bit values.Picture 6. Data Grid: bit values.

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

    Table Editor: time of the table creationPicture 7. Table Editor: time of the table creation

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.

    Nullable Column CheckerPicture 8. Nullable Column Checker

  • Advanced data grid features such as lookup editors and column header images become available on working via an HTTP tunnel.

    Advanced data grid featuresPicture 9. Advanced data grid features

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

      Import data from multiple filesPicture 10. Import data from multiple files

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

      Column BuilderPicture 11. Column Builder for text files with fixed column width

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

    Data Export to JSONPicture 12. Data Export to JSON

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