Year: 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

Press Release: Firebird Foundation Transitions to New European Base for Enhanced Project Support

Leave a comment

After more than two decades of operation from Australia, the Firebird Foundation is excited to announce a major transformation. A new organization of the same name has been established, now operating from the Czech Republic, within the European Union. This shift marks a significant step in strengthening the Foundation’s ties to Project Firebird, one of the leading open-source relational database systems.

The new Firebird Foundation has been set up with a closer connection to Project Firebird, which enables a more efficient and focused approach to supporting its development. This change promises a range of advantages for Firebird users, especially for those who contribute to the ongoing development of the database.

“We are excited about this transition,” said Alexey Kovyazin, former President of the Firebird Foundation in Australia. “Having the Firebird Foundation so closely linked to the core project team will streamline our ability to address the needs of Firebird users and drive the database’s progress more effectively. This will benefit the entire Firebird community, from individual developers to large enterprises relying on Firebird as their database solution.”

As the world continues to face economic and technical challenges, ongoing support from the community is more crucial than ever. Firebird’s global user base relies on this database for mission-critical operations, and ensuring its continued development and innovation is key. The new Firebird Foundation, with its European location, is well-positioned to offer faster, more tailored responses to the evolving needs of users.

Support the Future of Firebird

The Firebird Foundation remains committed to supporting its community, and this change enhances its ability to do so. Users are encouraged to get involved by supporting the project through donations or sponsorships. Contributions directly impact Firebird’s development, allowing the project to remain a leading, cost-effective solution for developers and businesses worldwide.

“We want to assure our community that Firebird remains strong,” said Pavel Císař, vice-president and secretary of new Firebird Foundation. “Our users and supporters are the backbone of this project, and their continued contributions are more important than ever in these difficult times. By supporting the Firebird Foundation, you are ensuring the future of this essential open-source database.”

For more information about the new Firebird Foundation and how to contribute, visit [https://www.firebirdsql.org/en/firebird-foundation].

About Firebird

Firebird is a powerful, open-source relational database management system used worldwide by developers, enterprises, and individuals. It offers robust features and scalability while maintaining a small footprint, making it a preferred choice for a wide range of applications.

Media Contact:
Alexey Kovyazin, ak@firebirdsql.org

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:

21st Firebird Developers Day – the end

Leave a comment

The 21st Firebird Developers Day concluded today with a special lecture by Dmitry Yemanov on the topic “Understanding the Optimizer Plans.” For the first time, participants heard Dmitry speaking Portuguese :-), thanks to the help of Artificial Intelligence.

This year’s event was held online, allowing more people to participate, especially those who live far from Piracicaba, where the in-person event is usually held. In terms of content, it was one of the best FDDs and featured high-quality live questions at the end of each presentation!

I would like to thank all the speakers (Rodrigo Marchiori, José Francisco Cervi Neto, Carlos Eduardo, Marcelo Daibert, and Dmitry Yemanov), as well as the participants and also the sponsors: IBExpert, uniGUI, Innovio, and Embarcadero, in addition to the supporters Woll2Woll, Steema, and ACBr.

1 2 3 … 6