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

Subscribe to our news:
Partners
Testimonials
Andrew Maclean: "I am really quite impressed with the software. You and your people are doing a wonderful job. I actually have spent a while researching PostgreSQL admin/code generators and yours seems to fit our needs nicely. Your interface is beautiful".
Ingo Bindbeutel: "I did buy Firebird Maestro before, because it is an excellent application and does a very very good work for me! I tried AnySQL and I did buy it, because it's a wonderful application too! Both are similar to use and easy to work with it! I am impressed by the quality and stability of the product! To all members of the SQL Maestro - Team: "keep going this way and make many people happy in using your software!" Thank you for making my life easier and my work productive".

More

Add your opinion

SQL Maestro Group / 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