Firebird Maestro 21.7 released

Jul 28, 2021

SQL Maestro Group is happy to announce the release of Firebird Maestro 21.7, 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 database server versions up to Firebird 4.0.
• Support for a number of Firebird 4.0 new features has been implemented as follows:
  • Added support for the new data types:
    • INT128, an integer data type with value ranges from -2¹²⁷ to 2¹²⁷ - 1.
      Picture 1. INT128 column
    • DECFLOAT, a numeric data type that stores floating-point numbers precisely.
      Picture 2. DECFLOAT data type
    • TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE are used for time zone support and store time and timestamp values, respectively, with the time zone.
      Picture 3. TIMESTAMP WITH TIME ZONE column

      Please note that starting from 4.0 version, CURRENT_TIME and CURRENT_TIMESTAMP expressions return TIME and TIMESTAMP values with the time zone, therefore the appropriate predefined default values for TIME and TIMESTAMP fields were changed to LOCALTIME and LOCALTIMESTAMP, accordingly.

      Picture 4. Predefined default values for TIMESTAMP data type
  • Increased Precision for NUMERIC/DECIMAL data types. NUMERIC and DECIMAL data types can now be defined with up to 38 digits precision (previously limited to 18 digits).
    Picture 5. Numeric data type with increased precision
  • Extensions to the IDENTITY Type. Now it is possible to specify and override the behavior of an identity column, specify and change the sequence options produced by the IDENTITY generator, and also drop the IDENTITY property.
    Picture 6. Identity options Picture 7. Identity options in a table definition
  • Now it is possible to create databases with 32K page size.
    Picture 8. Create Database Wizard: 32K page size support
  • Added support for a number of security enhancements:
    • Enhanced System Privileges. To assign special tasks to a role, the new "System privileges" tab has been added to the Role editor.
      Picture 9. Managing system privileges
    • Granting a Role to Another Role. The "Role members" and "Member of" tabs have been added to the Role editor to manage role membership.
      
      Picture 10. Managing role members
      Picture 11. Managing roles the role is member of
    • SQL SECURITY Feature. From now you can specify the context (INVOKER or DEFINER) the executable objects (triggers, stored procedures, stored functions) will run as.
      Picture 12. Procedure properties: SQL security property
  • Support for Firebird 4.0 embedded server has been added. Now Firebird Maestro comes with Firebird 2.5, 3.0 and 4.0 embedded server libraries. To create or to connect to a 4.0 database, select the "Embedded server 4.0" protocol in Create Database Profiles or Edit Database Profile windows.
    Picture 13. Create Database Wizard: Firebird 4.0 embedded server
• Now it's possible to manage user membership in the current database via "Member of" new added tab of "User DDL privileges and membership" editor (previously called "User DDL privileges").
  Picture 14. User DDL privileges and membership list
  Picture 15. User membership

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