Author: Cantu

I'm the owner of the www.Firebase.com.br site and the author of the books Firebird Essencial, Firebird 2 and Migration Guide to Firebird 3. Loving Firebird even before it was born!

Jaybird 3.0.4 update

Leave a comment

The Firebird JDBC team is happy to announce the release of Jaybird 3.0.4.

This release of Jaybird introduces two new features: wire protocol encryption and database encryption callback support.

Jaybird 3.0.4 contains the following fixes and changes:

– New feature: Back-ported wire encryption support from Jaybird 4 (JDBC-415)
– Fixed: Native/embedded (JNA) connections truncate varchars to length 255 on read (JDBC-518)
– New feature: Database encryption callback support in pure Java protocol (JDBC-527)

See the Jaybird 3.0.4 release notes for more information. Jaybird 3.0.4 can be downloaded from the JDBC Driver page.

The release is also available on maven:

groupId: org.firebirdsql.jdbc
artifactid: jaybird-jdkXX*
version: 3.0.4

* The artifactId depends on your target Java version: jaybird-jdk18, or jaybird-jdk17

Firebird Foreign Data Wrapper update

Leave a comment

After a long hiatus, I’ve finally found time to update firebird_fdw, which is now available as version 0.3.0.

This update, together with an update of the underlying Firebird API wrapper libfq to version 0.2.0, is a general cleanup/bugfix release, with improvements including:

  • support for PostgreSQL 9.6 and 10
  • support for IMPORT FOREIGN SCHEMA (PostgreSQL 9.5 and later)
  • automatic reconnection to Firebird
  • improved error message handling and display
  • improved memory handling and prevention of various unhandled situations which caused the PostgreSQL server to crash

Additionally, CentOS rpm packages are now available via the Fedora Copr build system.

This release has been developed and tested with Firebird 2.5. It will work with Firebird 3.0, but does not yet take advantage of any new features; future releases will hopefully address this.

eXpress Persistent Objects (XPO)

Leave a comment

XPO (an object-relational mapping library – ORM) supports more than a dozen database engines (including SQL Server, Oracle and various Open Source products) and recently got updated to support Firebird 3 too.

Firebird

In addition to SQL Server, MySql, PostgreSQL and SQLite, XPO for .NET Core / .NET Standard 2.0 supports ADO.NET provider 5.11+ for Firebird starting with v17.2.5. As we noted in our introductory post, the lack of support for other providers is not an XPO limitation – as soon as RDBMS vendors begin supporting .NET Standard 2.0, we will test XPO with these RDBMS providers and add them to our supported list.

Support for Firebird 3.0 server and the client ADO.NET data provider (FirebirdSql.Data.FirebirdClient 5.8.0) will be available in v18.1. We will also support the Substring criteria function that was missing before.

Firebird Synchronization to AWS Cloud.

Leave a comment

Happy to announce a new release and general availability of Bipost Sync, a tool designed for synchronizing Firebird SQL (Windows) to AWS cloud.

Built for developers in mind.

Bipost Sync is ideal to extend your on-premises Firebird DB’s to the cloud, and build web applications, web services and API’s on top of AWS cloud platform.

It is also a great way to consolidate information from separate databases and locations, e.g. manufacturing companies may want to read sales and inventory information from 2nd or 3rd tier small retailers.

Tech Stuff:
(*) Synchronize specific data sets from Firebird SQL on Windows to AWS Aurora-MySQL.
(*) Two-way synchronization available, from AWS Aurora-MySQL back to your Firebird SQL.
(*) No need to create/alter schemas, this is done by our sync tool.
(*) Prepare your data before you load with stored procedures you define.
(*) Transform your data after load is done, also with stored procedures you define.

More info:
https://factorbi.github.io/

Firebird Members Offer available:
https://www.firebirdsql.org/en/member-to-member-offers/

Leave a comment

MWA Software is pleased to announce that release 2.2.0 of IBX for Lazarus is now available for download from mwasoftware.co.uk/ibx. This is an important update to IBX and all users are recommended to upgrade to the new release. Please read the changelog before upgrade.

The main intent behind the release is to add support for the remaining Firebird 3 features (and some from earlier Firebird releases) that were not supported in release 2.1. This includes:

  1. Support for SQL Statements INSERT/UPDATE/DELETE…RETURNING. The first two cases are now able to update the current row for all TIBCustomDataset descendents including TIBTable, using data returned following a row insert or update.
  2. INSERT…RETURNING is used to provide support for Firebird “Identity” columns. For example, when used to provide auto-increment primary keys.
  3. Firebird “Packages” are now supported by TIBStoredProc and by the SQL Component Editors.
  4. Additional Firebird 3 properties are now supported by TIBDatabaseInfo and by the Services API components (e.g. TIBConfigService).
  5. Alternative Security Databases are now supported by the Services API Components.
  6. TIBExtract now supports DDL Grants and triggers on database objects.
  7. A new IBServices component to support online validation of a database (TIBOnlineValidationService).
  8. A major new example application (DBAdmin) is now included. This illustrates the use of IBX for Day-to-Day Database Administration tasks including User Management, Backup/Restore and Database Validation and Repair. It is also intended to provided a useable application that users may use directly or incorporate into their own toolsets. It also demonstrates User Management using Firebird 3 virtual tables and SQL statements. Note: this application also requires the standard Lazarus package MemDSLaz.

This release also incorporates recent bug fixes and includes a 33 page guide to the use of IBX for Firebird DBA activities.

IBX for Lazarus may be downloaded from: www.mwasoftware.co.uk/ibx

or by subversion from:

svn.mwasoftware.co.uk/public/ibx/tags/R2-2-0

Migration Guide to Firebird 3 gets updated!

Leave a comment

I’m proud to announce a new update to my Migration Guide to Firebird 3 eBook! The changes in revision 1.20 are mostly concentrated in the chapters about Connecting to Firebird 3 using an old client library, Testing application’s queries, Jaybird, .NET Provider and the two new sections about permissions for creating databases and for generators and exceptions.

In the next days, all those who already bought the eBook will receive an email with instructions about how to download the new revision.

The printed version will also get updated asap is already updated to 1.20. Those who already bought the printed book (rev 1.02) can email me to receive a PDF with the changes.

Click here for more information and to buy the eBook.

IBSurgeon is offering 10% discount on the HQBird Standard to all buyers of the eBook. More information here.

What do you think about coming to the Firebird Developers Day?

Leave a comment

The Firebird Developers Day is an annual Firebird conference that happens in Brazil. So far, it was mainly a Portuguese speakers conference, but this year, when FDD completes its 15th birthday, we are checking the possibility to receive international attendees too. The conference date is August, 18 2018.

The first thing we need to do is to figure out if people outside Brazil has interest to participate in FDD. So, if you live outside Brazil, and would like to come to the 15th Firebird Developers Day, answer this 3 questions survey and let us know!

Thanks!

Firebird 3.0.3 is now available!

Leave a comment

Firebird Project is happy to announce general availability of Firebird 3.0.3 — the third point release in the Firebird 3.0 series.

This sub-release offers many bug fixes (including fix for a recently reported security vulnerability) and also adds a few minor features and improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows and Linux on both 32-bit and 64-bit platforms are immediately available for download.

1 … 8 9 10 11 12 … 100