Year: 2024

RED EXPERT 2024.07 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2024.07 is available.

Improved:

  1. Application interface
    • Default themes (light and dark)
    • Application toolbar
    • Application menu
    • Query Editor toolbar
    • Query Editor popup menu
    • Connections tree
    • Settings menu
    • About panel
    • Procedures, Functions and Jobs editing panel
    • Changelog panel (release notes panel)
    • Drivers panel
    • Feedback panel
  2. ER-diagram tools
    • Color differentiation of tables in the ERD editor
    • Reverse engineering
    • Text blocks with ability to set background color
    • Undo/Redo operation
    • Added display of unique fields status (UQ)
    • Display table and field comments
    • Deleting tables can now be done with DELETE key 
    • Ability to stretch the size of tables with the mouse
    • Ability to switch between color and B&W lines 
    • Ability to select several tables and move them at the same time
    • Fixed scrolling by mouse wheel (SHIFT + wheel scrolling = horizontal scrolling)
    • Sorting by tables relationships
    • Ability to select the type of lines
  3. The execute button in the query editor can now:
    • Execute only the selected script
    • Execute everything if nothing is selected

Added:

  1. Ability to display column folders, constraints, indexes and triggers for tables in the connections tree
  2. Panel with basic information about connections
  3. Ability to create a bug report when an error occurs
  4. Ability to customize the Query Editor toolbar

Fixed:

  1. Switching between “Database Statistics” tabs
  2. Component layout on the column type selection panel
  3. Displaying domain fields

Removed:

  1. “Scratch pad” tool
  2. “Compare Data Types” tool
  3. “Execute Stored Objects” tool
  4. Ability to add custom SQL keywords

Download and install the new version.

New issue of EmberWings magazine published

Leave a comment

EmberWings is a quarterly PDF magazine about Firebird published by IBPhoenix.

Beyond technical articles, instructions and tips, it contains interviews with noteworthy individuals, an overview of Firebird’s development, information from the Firebird community, evaluations of compelling products, and a touch of thematic humor. All of this presented in a streamlined format with an aesthetically pleasing print-friendly layout.

The magazine is available in IBPhoenix store for free on a pay-what-you-want basis, with half of the proceeds going to the Firebird Foundation. The remaining half is used to finance the publication of the magazine.

This issue has 70 pages.

Jaybird 5.0.5 released

Leave a comment

We are happy to announce the release of Jaybird 5.0.5.

The following has been fixed since Jaybird 5.0.4:

  • Fixed: FBResultSetMetaData.getPrecision would always estimate the precision of NUMERIC or DECIMAL columns instead of obtaining the actual precision if the column position was 71 or higher (#731)
  • Optimized the query to retrieve extended field info for ResultSetMetaData.getPrecision to only retrieve columns of type NUMERIC or DECIMAL (#732)
  • Fixed: PreparedStatement.executeBatch() of statement without parameters throws “Statement used in batch must have parameters [SQLState:07001, ISC error code:335545186]” on Firebird 4.0 or higher (#788)
  • New feature: ResultSetMetaData.isAutoIncrement(int) reports true for identity columns if Jaybird can identify the underlying table and column (#793)
  • New feature: Boolean connection property extendedMetadata (default true) to disable querying of extended metadata for getPrecision(int) and isAutoIncrement(int) of ResultSetMetaData (#795)
  • Improvement: The FILTER_CONDITION of DatabaseMetaData.getIndexInfo is populated for Firebird 5.0 partial indices (#797)
  • Fixed: ResultSet.isBeforeFirst() and ResultSet.isAfterLast() should always report false for an empty result set (#807)
  • Improvement: Statement.getResultSet no longer throws a SQLException with message “Only one result set at a time/statement” if the current result set has already been returned by executeQuery or a previous call to getResultSet (#762)
  • Improvement: Updated JNA dependency to version 5.14.0 (#810)

Jaybird 5 supports Firebird 2.5 and higher, on Java 8, 11, 17, 21, and 22 (support for Java 11 and higher using the Java 11 version of the driver).

See also:

Real-time Firebird – Monitor for Firebird – Server 2.5 / 3.0 / 4.0 / 5.0

Leave a comment

We are pleased to present the new version 2 of the Firebird Monitor with “Trace and Audit”.

We are currently offering a 10% discount on the purchase of a license until the end of June 2024. The coupon code is “Discount10”.

With “Trace and Audit”, they are able to record and evaluate every single event in the database.

Visit our homepage and download the demo version.

https://fbm.gksoft.ch

Database Workbench 6.5.0 released

Leave a comment

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 6.5.0″

Changes in recent releases:

  • Firebird 5 support
  • MySQL 8.3 support
  • PostgreSQL 16.x support
  • SQLite module introduced for full SQLite support, read only support in Pro and Enterprise editions without this module

Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you!

1 2 3 4