Firebird Maestro 15.11 released

Nov 16, 2015

SQL Maestro Group is happy to announce the release of Firebird Maestro 15.11, a powerful Windows GUI solution for Firebird 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 Firebird 3.0 RC 1 (the latest version available at the moment). We have also implemented support for some Firebird 3.0 new features:
  • Support for packages has been added (a package is a group of procedures and functions managed as one entity). Now you can create and edit package headers and their bodies using a powerful editor that comes with our product.
    Picture 1. Package body editor
  • Support for DDL triggers has been implemented. The purpose of such triggers is to enable restrictions to be placed on users who attempt to create, alter or drop a DDL object.
    Picture 2. Creating a new DDL trigger
  • Database Editor: now it is possible to change the default character set for an existing database. The alteration does not change any existing data. The new default character set is used only in subsequent DDL commands and will assume the default collation of the new character set.
    Picture 3. Database Editor
• Transaction Browser has been improved. Now all active connections are displayed correctly independently of the time they were opened. It also becomes possible to terminate an unwanted connection to the database with a single mouse click.
• A command line builder has been incorporated into all the maintenance wizards. Now Backup Database and Restore Database wizards provide you with a comfortable user interface for creating batch files for the GBAK tool, while Shutdown Database and Bring Database Online wizards allow you to easily create such files for the GFIX utility.
  Picture 4. Backup database wizard: Command line builder
• Starting with this version a warning appears on creating a table without a primary key constraint.

  Picture 5. Warning message

Interface improvements:

• In Data Grids and Data Input Forms computed columns are marked by a green calculator.
  Picture 6. Generated columns in data grids
• From now on it becomes possible to execute custom SQL scripts in all database connections established by the software.
  Picture 7. 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.
  Picture 8. Data encryption
• 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).
  Picture 9. BLOB Editor
• 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.
  Picture 10. Colored tabs
  For the same purpose tab hints now include the profile name.
  Picture 11. Tab hints
• Now dependencies of system domains are correctly represented on Dependency tracker and on the appropriate tabs of domains' editors.
• Data Export: from now on it becomes possible to specify caption, width, and alignment for output columns (when applicable).
  Picture 12. Data Export: customizing output columns
  Also it becomes possible to add current timestamp to the output file name.
  Picture 13. 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).
  Picture 14. 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.
  Picture 15. Data Input Form: marking important controls

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