Month: November 2024

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

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.

PHP 8.4 final released with Improvements for modern Firebird versions

Leave a comment

PHP 8.4 released with many Improvements for modern Firebird versions : 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.

Related PDO-Firebird changes from PHP Changelog :

  • PDO_Firebird:
    • Fixed setAttribute and getAttribute.
    • Feature: Add transaction isolation level and mode settings to pdo_firebird.
    • Added class Pdo\Firebird.
    • Added Pdo\Firebird::ATTR_API_VERSION.
    • Added getApiVersion() and removed from getAttribute().
    • Supported Firebird 4.0 datatypes GH-14896
    • Support proper formatting of time zone types.
    • Fixed GH-15604 (Always make input parameters nullable).

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