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.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

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.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Blob transfer speed optimizations

Leave a comment

It is well known that transferring blobs in Firebird over high latency networks (i.e. internet) is very slow. The main reason is that transferring blobs always required lots of roundtrips. The good news is that the donations collected in the 21st Firebird Developers Day (FDD) Brazilian conference are being used to sponsor the improvement of blobs transfer speed. The changes are being developed by Vlad Khorsun and the currently results looks very good (see below)!

Note that the improvements are being developed in two phases. The first phase is ready and didn’t require any changes in the Firebird Wire Protocol, so it will be available in the upcoming Firebird 5.02 release. Transfer times were reduced by 33%-49%.

The second phase is still under development and requires changes in the Firebird Wire Protocol, so it will be available only in Firebird 6, but it already shows great results from 94%-97% improvement! In the best case, the time dropped from 12s to 477msecs!

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 5.00 out of 5)
Loading...

A sad day for the Firebird Project

Leave a comment

As seen in FirebirdSQL official site:

Helen Borrie, a key figure in the Firebird relational database project and a longtime contributor at IBPhoenix, passed away on January 2, 2025. Her contributions were essential to Firebird’s creation and its development over the past 25 years.

Helen’s dedication to the project was unwavering. She played a critical role in establishing the Firebird Foundation and managed its operations as the Foundation’s Secretary. Her work ensured that the project had the structure and support needed to grow and succeed. She often worked behind the scenes, making sure things ran smoothly and that the community had the resources it needed.

She was also the author of The Firebird Book, a comprehensive guide that became an invaluable resource for users and developers. Helen’s writing made Firebird accessible to many, helping them understand and use the database effectively. She was always ready to assist others, sharing her knowledge generously within the user community.

Helen’s quiet leadership and dedication left a lasting impact on Firebird and its users. Her efforts helped build not just a powerful database but also a strong, collaborative community. She will be deeply missed by all who knew her and benefited from her work.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

December Issue of EmberWings is Here!

Leave a comment

The Firebird Project is happy to announce that the December issue of EmberWings is now available for download! This special edition marks the magazine’s debut under the Firebird Foundation, bringing you a refreshed focus on both Firebird administrators and application developers alike.

This issue is currently available only to all Firebird Associates and Firebird Partners. It will be available to the general public in December 2025.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

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!

    1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
    Loading...

    Firebird Advent Calendar 2024

    Leave a comment

    From the Firebird Project

    This December, we invite you to join us in a special countdown that celebrates the holiday season and brings the Firebird community together. Each day, we’ll be unveiling exciting content, surprises, and fun activities to warm up your winter and keep you engaged with everything that makes Firebird special.

    But this isn’t just any countdown—it’s the start of the celebration leading up to Firebird’s 25th Anniversary in 2025! As we count down to this monumental milestone, we’ll share highlights from our past, present, and future, showcasing the power of collaboration that has driven Firebird forward over the years.

    So, grab a cup of hot cocoa, and let’s enjoy this festive season as we look ahead to an incredible year for Firebird. Together, we’re writing the next chapter of Firebird’s story—don’t miss a day!

    The Advent Calendar is featured on the Firebird website (Advent Calendar on menu), or use the direct link: https://www.firebirdsql.org/en/advent

    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...

    1 2 3 … 484