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

Release of IBProvider v5.37

We are glad to present a new release of IBProvider — v5.37. This update contains a lot of internal changes and improvements. All the changes have been tested more than one time, so this release is ready for use in your projects. Please update your copy of IBProvider with this version. If you work with Firebird, please use «fb.direct» mode. Thanks.

https://www.ibprovider.com/eng/news/n_240518.html

Build of error message in built-in Firebird client

  • The current release of IBProvider adds the new initialization property ctype_system that allows to point a codepage of operation system where a connected database server is working. This information will help IBProvider process the DBMS system errors
  • Provider uses a connection charset for translating server error messages into UNICODE

Work with ICU

  • ICU 63.1 (FB4). A suppression of translation error between code pages is disabled now (FB:CORE-8108)
  • A processing of ucnv_open function return code is corrected

Common changes

  • vc16 binaries are compiled with C++20
  • vc15 binaries use a built-in thread pool based on the source code of the external thread pool of vc16/vc17 assemblies (source code unification)
  • The information content of the error message “unsupported database server version” is improved
  • The internal instrumental C++ library was refactored

With Best Regards, IBProvider Team.

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

Firebird-Export

Export a Firebird database to CSV, JSON or other formats is a Open Source project to export a Firebird database, show a summary of the database table names, field names, field data types, and index columns. Optionally extract and save table data to a directory, in CSV/JSON (or potentially in any other format), as well any other binary files from blobs.

A subset of the tables and fields can be specified (in python) and the number of records returned can be limited for testing purposes. Output data can be combined or into one or saved in individual files named after the tables.

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

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

libpthread compatibility problem with Firebird 2.5

We’ve identified an issue where the latest libpthread library versions are not compatible with Firebird 2.5 (including the latest available release of vanilla version 2.5.9.27139 and HQbird 2.5 till the version 2.5.9.27173).

This incompatibility may cause Firebird 2.5 to crash during certain operations on newer Linux distributions. The error occurs frequently in architectures SuperServer and SuperClassic, and less frequently, in Classic.

Immediate Action Required:
To prevent any impact on Firebird 2.5, please follow the guidance provided below.

Assessing Your System:
Determining which Linux distributions are impacted is dificult since libpthread updates can be applied to older operating system versions, potentially introducing the issue to Firebird. It means that any update of OS can bring the problem to your system, even if you are running old version. It means that you need to test your instance of OS.

Testing for Compatibility:
We’ve developed a command-line application to test whether libpthread is compatible with Firebird 2.5.

Download Instructions:
•  The binary for the test application can be downloaded from the following link: www.ib-aid.com/download/libpthread/pthr-tst
•  The source code for the test application is also available at this link: www.ib-aid.com/download/libpthread/test.cpp

Execution Guide:
Execute the test application in your terminal as outlined in the instructions below to perform the compatibility check.

For the Operating System with old libptread (i.e., it is compatible with 2.5)  

wget https://ib-aid.com/download/libpthread/pthr-tst
chmod +x pthr-tst
# ./pthr-tst 
Set signals
Sigenv works 

For the Operating System with new libptread (i.e., not compatible with 2.5):

# ./pthr-tst
Set signals
Segmentation fault

What to do next in short-term

For Firebird 2.5 vanilla users:
If you have made the test and found that libpthread is not compatible with Firebird 2.5, change the architecture to Classic (make sure to do not confuse the configuration!), and then plan to reinstall your Linux Operating System to the old version with compatible libpthread, which does not have this problem – as soon as possible.

If you have made the test and did not encounter the problem with libpthread, there is no direct danger at the moment. Make this test after each OS update.

Please note that Firebird 2.5 is discontinued version, and Firebird Project will not release fix for vanilla version of 2.5.

For user of commercial versions
Contact your vendor to receive a fix.

What to do next in long-term? Upgrade!

Take this as a final notice that you need to upgrade to Firebird 5.0. The version 2.5 was good and stable, but it originates from 2010, the majority of products released in that year already retired.

There are enough material to perform upgrade in the smooth and easy way, see for details Practical Migration Guide to Firebird 5.
 

Questions?

Please feel free to ask any questions: ak@firebirdsql.org

Original article: https://firebirdsql.org/en/news/urgent-and-import-message-for-users-of-firebird-2-5-on-linux/

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

Stored routine debugger Hopper, v2.3 released

Upscene Productions is proud to announce version 2.3.0 of “Hopper”, a stored routine debugger for InterBase, Firebird or MySQL.

This release brings support for Firebird 5 and bugfixes.

For more information, check the Hopper page at our website.

About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase. If you use
stored procedures on these database systems, Hopper will be a great tool for debugging
these routines.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been providing
database developers with useful tools for over 20 years. Slowly expanding the product portfolio
and gaining recognition amongst InterBase and Firebird database developers, they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

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

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

EmberWings Magazine about Firebird

EmberWings is a new quarterly PDF magazine about Firebird published by IBPhoenix.

Beyond technical articles, instructions and tips, it contains interviews with noteworthy individuals, an overview of Firebird’s development, information from the Firebird community, evaluations of compelling products, and a touch of thematic humor. All of this presented in a streamlined format with an aesthetically pleasing print-friendly layout.

The magazine is available in IBPhoenix store for free on a pay-what-you-want basis, with half of the proceeds going to the Firebird Foundation. The remaining half is used to finance the publication of the magazine.

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

HQbird 2024 is released

We are glad to announce that HQbird version 2024 is released!
HQbird is advanced distribution of Firebird, with many improvements in the areas of performance, high availability, development, and more. It is intended for large enterprises and development companies with many Firebird installations, offering performance, protection from various threats, and mass maintenance.

Version 2024 introduces support of Firebird 5, and continue to support versions 4.0, 3.0, 2.5, with various improvements in the engine, high availability, tooling, and encryption.

HQbird is 100% compatible with Firebird, no need to perform backup/restore, you can install HQbird in trial mode in parallel with vanilla Firebird, and switch between instances.

The detailed list of HQbird features which improves Firebird can be found here, and below there are the biggest improvements of version HQbird 2024:

  1. Replacing queries “on the fly”
  2. Plugins for performing external connections with ODBC and MySQL
  3. Streaming/Change Data Capture with ready-to-use Kafka plugin, and plugin-building framework.
  4. Automation support to work with many databases on the server (for clients with SaaS model), with ability to create “replica server”
  5. Multi-instance support, which makes migration process from old Firebird versions much easier. HQbird 2024 is also integrated with Mass Migration Framework
  6. Automatic correction of firebird.conf configuration in case of erroneous configuration.

All features are described here.

HQbird v2024 has 2 licenses (click here to see purchasing options):

  • Per server, suitable for small and medium companies, US$899/server
  • Unlimited License, for large enterprises and software development companies, cost US$13465/year for unlimited number of installations.

Download HQbird v2024 here.

Customers with support contracts, subscriptions, or recent maintenance purchases (within the last 13 months), as well as customers who bought HQbird in the last 30 days, will get free upgrades in the next 10 days.

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

Practical Migration Guide To Firebird 5.0

The “Practical Migration Guide to Firebird 5.0,” authored by D. Simonov, is a free technical manual that describes the main steps for upgrading to Firebird 5 from legacy versions such as 2.5, 3.0, and 4.0.

It encapsulates a wealth of pragmatic advice, troubleshooting methodologies, and resolution techniques for common migration challenges. Despite its brevity (40 pages), the guide comprehensively addresses critical aspects of the migration process, including installation protocols, configuration optimization, user account migration, and data type transition strategies.

Read “Practical Migration Guide to Firebird 5.0” or download it in printable PDF format.

From www.firebirdsql.org

Note from the submitter: For those upgrading to Firebird 5, this practical guide can be considered an “add-on” for my (+200 pages) Migration Guide to Firebird 4 eBook, which contains detailed and very important information specially for those moving from FB 3 (or older versions).

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

1 3 4 5 6 7 484