Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Stephen Arrowel, Database Administrator: "We are in the process of implementing Firebird solutions at multiple levels in our international organization. We expect that SQL Maestro Group will do nothing short of revolutionize the way we develop and maintain our Firebird databases. The continuous improvement and development means that the product is extremely flexible and will grow with us. The service and responsiveness of the Support Team has been exceptional. They have devoted countless hours to understanding our needs, so that we could get a Firebird administration tool which would be so simple and effective in use. SQL Maestro Group is helping Sytrax sail into the 21st Century".
Andrey Bistriy: "In our daily business we face the database management and refactoring. We were pleasantly surprised to discover SQL Maestro. After trying it out we started to use it on a regular basis".


Add your opinion

SQL Maestro Group / Products / Firebird / Firebird Maestro / News / Firebird Maestro 21.7 released

Firebird Maestro 21.7 released

Jul 28, 2021

Prev Next
Firebird Maestro

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 -2127 to 2127 - 1.
        INT128 columnPicture 1. INT128 column
      • DECFLOAT, a numeric data type that stores floating-point numbers precisely.
        DECFLOAT data typePicture 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.

        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.

        Predefined default values for TIMESTAMP data typePicture 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).
      Numeric data type with increased precisionPicture 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.
      Identity optionsPicture 6. Identity options Identity options in a table definitionPicture 7. Identity options in a table definition
    • Now it is possible to create databases with 32K page size.
      32K page size supportPicture 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.
        Managing system privilegesPicture 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.
        Managing role membersPicture 10. Managing role members
        Managing roles the role is member ofPicture 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.
        Procedure properties: SQL security propertyPicture 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.
      Create Database Wizard: Firebird 4.0 embedded serverPicture 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").
    User DDL privileges and membership listPicture 14. User DDL privileges and membership list
    User membershipPicture 15. User membership

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

Related links:

Firebird Maestro home page
Download Firebird Maestro
Get Firebird Maestro Tour
Purchase your license of Firebird Maestro today!
Prev Next