Category: Tools & Products releases

Announcements of new Firebird related products, or new releases.

Free Database Workbench Lite edition available!

Leave a comment

Upscene Productions is proud to announce the availability of a free feature limited version of Database Workbench, the Lite Edition, for personal non-commercial use. Download it here. There’s a version for Firebird and a version for MySQL.

For details on the feature differences between editions, see this feature matrix.

“Database Workbench is used by thousands of developers around the world, we’re making it available to hobbyists too”, says Martijn Tonies, founder of Upscene Productions. “Everyone can now use the free Lite Edition for personal non-commercial use.”

Database Workbench Basic and up support MySQL, MariaDB, Firebird, Oracle, SQL Server, PostgreSQL, NexusDB, SQLite and InterBase, comes in multiple editions and is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools.

RED EXPERT 2025.01 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.01 is available.

What’s new?

  • Updated the list of available application themes based on the survey results.
  • Stopped support of 32-bit Windows (x86) operating systems.

Improved:

  1. Display application fonts in new themes
  2. Copying field names with data types from a Result Set
  3. Data view panel interface for BLOBs that not available for editing

Fixed:

  1. Trace parsing
  2. Interacting with Red Database 2.6 and Firebird 2 connections
  3. Processing of connection parameters when changing the interface language
  4. Readability of selected lines on the “Analyze” tab in the Trace Manager
  5. Applying old settings, which require restarting the application, during upgrade
  6. Customizing date and time patterns
  7. Adding a comment to JOB
  8. Behavior of the “Wrap lines” checkbox on the BLOB data view panel
  9. Confirmation dialog disappearing when altering the database object
  10. Dialog closing after creating database objects
  11. Applying and restoring settings
  12. Various exceptions occurred by the data export
  13. Displayed data type size in the results of the SELECT query

In previous versions, Portuguese language support was added. We want to make the app better, so we welcome comments from native speakers.

Download and install the new version.

FBPC 1.0.3 is released

Leave a comment

A new version of Performance Comparer for Firebird (FBPC) is now available. Version 1.0.3 has the following changes:

  1. Fixed some parameters data type identifying logic (the traceapi writes the params data types based on their internal field type, not the declared type)
  2. The statement’s grid wasn’t showing a value when the statement execution time was below 1ms
  3. Added some error handling during the statements execution
  4. Now any errors during the execution of an statement will be logged in the errors.log file (in the application directory)

FBPC is a free tool that can help people to compare the performance of real life SQL statements between two Firebird versions, or even between the same Firebird version but with different configurations in firebird.conf.

RED EXPERT 2024.12 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2024.12 is available.

What’s new?

Added:

  1. Formatting numbers for table statistics
  2. Copying formatted column names

Improved:

  1. The amount of memory required for audit analysis has been reduced
  2. Exporting data with BLOB SUB_TYPE TEXT type now does not require mandatory file specification for exported blobs

Fixed:

  1. Recalculation of index selectivity
  2. Parsing of the nested procedures
  3. Parsing of the procedure cursors
  4. Parsing of the procedure variables with NCHAR, REAL, INT, LONG FLOAT and other types
  5. Generating SQL statements for variables with COLLATE
  6. Display SQL queries containing special characters on the “Analyze” tab in the Trace Manager
  7. Increased CPU load after repeated opening of the search window in the Query Editor
  8. Mismatch between the versions of the client library and driver used for native connection

Download and install the new version.

Jaybird 6.0.0 released

Leave a comment

We’re happy to announce the first release of Jaybird 6, Jaybird 6.0.0.

What’s new

The major changes and new features in Jaybird 6 are:

Upgrading from Jaybird 5 should be straightforward, but please make sure to read Compatibility changes before using Jaybird 6. If you’re using Jaybird with the native or embedded connections, you will need to make some additional changes. See also Upgrading from Jaybird 5 to Jaybird 6.

Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to the Firebird-java mailing list or reported on the issue tracker https://github.com/FirebirdSQL/jaybird/issues.

See also the full Jaybird 6.0.0 release notes.

Maven

The release is also available on Maven:

groupId: org.firebirdsql.jdbc
artifactId: jaybird
version: 6.0.0

If you use the native or embedded protocol, you need to add the jaybird-native dependency:

groupId: org.firebirdsql.jdbc
artifactId: jaybird-native
version: 6.0.0

For ChaCha64 wire encryption support, add the chacha64-plugin dependency:

groupId: org.firebirdsql.jdbc
artifactId: chacha64-plugin
version: 6.0.0

Database Workbench 6.6.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.6.0″

We recently added SQLite support, this release adds support for Windows on ARM64 and full support for MySQL 9, MariaDB 11.3 & 11.4, as well as other new features, improvements and bugfixes.

Mind you: there’s a 50% discount on all Upscene products this month, visit the website for more information.

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

    RED EXPERT 2024.11 HAS BEEN RELEASED

    Leave a comment

    You can join to the Telegram chat for discussion.

    New version of Red Expert 2024.11 is available.

    Added:

    1. Database backup / restore tool.

    Improved:

    1. Connection parameters configuration panel.
    2. Exporting database statistics to a file.
    3. Database creation panel.
    4. Password input field.

    Fixed:

    1. Executing EXECUTE BLOCK queries with parameters.
    2. Executing SQL-queries starting with a comment.
    3. Running application after upgrading from versions older than 2024.07.
    4. Errors when creating a new connection.
    5. Errors in the log when connecting to the database via SSH tunnel.
    6. Errors in the log when opening or closing Query Editor tabs.
    7. Errors in the log when displaying dependencies in the ER-diagram editor.
    8. Closing dialogs with a question.
    9. Updating application color scheme when switching from dark theme to light one.
    10. Applying line numbers properties in the Query Editor.
    11. Applying toolbar properties in the Query Editor.
    12. Applying SSH tunnel properties for connection.
    13. Applying authentication properties for connection.
    14. Generating INSERT and UPDATE scripts for tables and views.
    15. Modifying stored procedure code when creating or altering it.
    16. Adding constraints on table when connecting to the Firebird database.

    Download and install the new version.

    Jaybird 6.0.0-beta-1 available for testing

    Leave a comment

    Jaybird 6.0.0-beta-1 is now available for testing. You can download the distribution zip from Jaybird 6.0.0-beta-1 (GitHub).

    IMPORTANT

    This version is provided for testing purposes only. We’d appreciate your feedback, but we’d like to emphasize that this version is not intended for production.

    What’s new

    The major changes and new features in Jaybird 6 are:

    Upgrading from Jaybird 5 should be straightforward, but please make sure to read Compatibility changes before using Jaybird 6. If you’re using Jaybird with the native or embedded connections, you will need to make some additional changes. See also Upgrading from Jaybird 5 to Jaybird 6.

    Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to the Firebird-java mailing list or reported on the issue tracker https://github.com/FirebirdSQL/jaybird/issues.

    See also the full Jaybird 6.0.0-beta-1 release notes.

    Maven

    The release is also available on Maven:

    groupId: org.firebirdsql.jdbc
    artifactId: jaybird
    version: 6.0.0-beta-1

    If you use the native or embedded protocol, you need to add the jaybird-native dependency:

    groupId: org.firebirdsql.jdbc
    artifactId: jaybird-native
    version: 6.0.0-beta-1

    For ChaCha64 wire encryption support, add the chacha64-plugin dependency:

    groupId: org.firebirdsql.jdbc
    artifactId: chacha64-plugin
    version: 6.0.0-beta-1

    Jaybird 5.0.6 released

    Leave a comment

    We are happy to announce the release of Jaybird 5.0.6.

    The following has been fixed since Jaybird 5.0.5:

    • Fixed: Exceptions during statement execution did not always complete the statement, which could delay transaction commit in auto-commit mode (#806)
    • Fixed: Closing a connection when the database was shutdown, or the connection was otherwise broken, could result in a NullPointerException (#812)
    • Fixed: Error “Column unknown; IND.RDB$CONDITION_SOURCE” when calling DatabaseMetaData.getIndexInfo on Firebird 5.0 with a Firebird 4.0 (ODS 13.0) database (#813)
    • Fixed: Calling ResultSet.wasNull() when on the insert-row throws a SQLException instead of reporting the null-state of the last retrieved column (#816)
    • Fixed: Inserting a row into a result set backed by a server-side scrollable cursor could include the inserted row twice (#819)
    • Improvement: Updated JNA dependency to version 5.15.0 (#823)

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

    See also:

    PHP 8.4 Improvements when working with modern Firebird versions

    Leave a comment

    From firebirdsql.org:

    PHP 8.4 beta 5 has been released, marking a significant milestone for PHP developers, particularly those working with Firebird databases. This update brings crucial enhancements to the built-in PDO-Firebird driver. Now supporting modern data types, including DECFLOAT, the driver offers substantial benefits for PHP applications using Firebird 4 and 5.

    This improved Firebird support in standard PHP will streamline development of Firebird-based PHP applications, making the process more straightforward and transparent. For an in-depth look at these enhancements, check out the new article “PHP 8.4 Improvements when working with modern Firebird versions“.

    1 2 3 … 147