Firebird Maestro 19.8 released

Aug 8, 2019

SQL Maestro Group is happy to announce the release of Firebird Maestro 19.8, 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:

New feature highlights:

• This version of the software has been successfully tested with all the modern database server versions up to Firebird 3.0.4 (the latest official version available at the moment).

• Support for PSQL stored functions has been implemented (Firebird 3+). Such functions are scalar functions which can be called just like an internal function. Now you can create and edit stored function names, parameters and body using a powerful editor that comes with our product.

  Picture 1. Stored function list Picture 2. Stored function editor

• Support for external stored procedures and functions has been added (Firebird 3+). External procedures and functions are located in external modules. The special User Defined Routines (UDR) engine establishes a way to hook external modules into the server and make them available for use.

  To create an external procedure or function, turn ON the appropriate checkbox, specify an external module name and a name of function or procedure in this module.

  Picture 3. Create external procedure wizard
• Support for a number of data security protection new features has been implemented (Firebird 3+).
• USAGE privileges can now be granted for exceptions and generators as well as EXECUTE privileges for packages and functions.
  Picture 4. Exception editor: USAGE privilege
• Support for DDL privileges. Now it is possible to assign metadata write privileges to specified users or roles for specified database objects.
  Picture 5. Role editor: DDL privileges
  To simplify granting of DDL privileges for database objects to users the new "User DDL privileges" list has been added to the Explorer tree.
  Picture 6. User DDL privileges list Picture 7. User's DDL privileges editor
• Support for active and inactive user accounts. Inactive users cannot login and have grayscale icon in GUI.
  Picture 8. User editor: inactive user
• It becomes possible to allow users to create databases on a server.
  Picture 9. User editor: user can create databases
• Added possibility to specify additional attributes (tags) for users.
  Picture 10. User editor: Tags
• 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.
  Picture 11. Database Profile Statistics
• SSH client has been upgraded. Now it supports more secure key exchange algorithms.
  Picture 12. SSH Client has been upgraded
• Links to our social networks accounts have been added to the Quick Launch panel. As minor versions are announced only in our Facebook and Twitter, we would recommend you to follow us somewhere to stay informed.
  Picture 13. Follow us!

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