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

Subscribe to our news:
Partners
Testimonials
Neil McPherson: "Thanks very much for your advice. I would just like to add that SQL Maestro makes life so much easier to work with Firebird, I have tried some of the other management tools but Maestro is such a nicely organized product and it has never let me down".
Brian Vivian: "Thank you very much for making such a great product. It makes my job a LOT easier".

More

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.
        TIMESTAMP WITH TIME ZONE columnPicture 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.

        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