Tag: firebird

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

Database Workbench 6.5.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.5.0″

Changes in recent releases:

  • Firebird 5 support
  • MySQL 8.3 support
  • PostgreSQL 16.x support
  • SQLite module introduced for full SQLite support, read only support in Pro and Enterprise editions without this module

Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you!

Release of IBProvider v5.37

Leave a comment

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.

Stored routine debugger Hopper, v2.3 released

Leave a comment

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.

EmberWings Magazine about Firebird

Leave a comment

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.

IBProvider News

Leave a comment

Hello Everyone.

We have updated all our components and recommend our user and customers to use them.

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

IBProvider 5.36.x

  • Sending short BLOB via VARCHAR datatype (Firebird v2.5.1+)
  • A support of Windows XP was restored

LCPI ADO.NET provider for OLE DB v1.29

  • Assemblies for .NET8 were added

Other updates

  • LCPI OLE DB Services was updated
  • LCPI EF Core Provider for OLE DB was updated

Kind Regards, IBProvider Team.

IBProvider v5.35 and BIG testing with FB4

Leave a comment

Hello Everyone!

We are pleased to present a new release of our OLE DB provider for Firebird and InterBase, which has undergone not only standard load testing, but also BIG testing with Firebird v4, which lasted more than a month. This is more than 7 million tests executed in parallel on a ten-core processor.

IBProvider v5.35

In this new version of the provider, the internal infrastructure has been improved — now the cancellation of query execution also applies to operations with BLOBs.

BIG testing with FB4

The last time BIG testing was done was 3 years ago with FB 3.0.8.33401…

Read more: https://www.ibprovider.com/eng/news/n_240212-fb4_big_testing.html

With Kind Regards, IBProvider Team.

REDEXPERT 2024.01 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of RedExpert 2024.01 is available.

Added:

  • Support of work with database statistics:
    • Obtaining database statistics via services
    • Parsing DB statistics from a file
    • DB statistics comparing
  • Data import support from XLSX and XML files
  • Export/import of data with BLOB type
  • Ability to select columns when exporting data
  • Ability to transfer data from one database to another
  • Database metadata extracting into SQL-script
  • SQL-queries executing to a file directly
  • Transaction parameters support in the Query Editor
  • Query execution in several connections simultaneously
  • Transaction confirmation window when closing the Query Editor and the “Data” tab of tables and views
  • Displaying connection and database properties (such as server, page size, database file size, etc.)
  • Ability to copy column names from a Result Set
  • “Triggers” tab for views
  • Ability to configure database connection timeout
  • Updated data import and export panels

Fixed:

  • Display tables with “NONE” encoding
  • Recognizing VARCHAR and CHAR types other than undefined subtype and with fixed binary data
  • Reloading of views after making changes
  • Auto-completion: by occurrence, not by string start
  • UDF opening errors
  • Editing foreign keys
  • Copying connection with encoding
  • Editing data in columns with names containing spaces
  • Disappearance of the edited procedure text on the “DDL” tab when switching tabs
  • Searching for database objects in the connection tree with names containing ‘$’
  • GUI defects when double-clicking on a table name in the Query Editor
  • Limitations on the number of characters and maximum value when editing field value with INT128 type
  • SQL code generation for external UDR functions, indexes and constraints
  • Table Validation with a large number of fields and indexes
  • Profiler buttons availability when switching between application tabs
  • Display PUBLIC role in the “Users” group in the Grant Manager
  • Focus shift when changing a filter field in the Grant Manager
  • Updating the list of triggers for tables and views when adding a new trigger
  • Updating the list of table fields when they are changed

Download and install the new version.

RedExpert 2023.10.1 has been released

Leave a comment

You can join to the Telegram chat for discussion.

New version of RedExpert 2023.10.1 is available.

Added:

  1. “Properties” tab on the database table editing panel.
  2. Configuring SQL templates from the Menu -> Tools.
  3. Checkbox “Automatic text wrapping” in the text browser of data with the BLOB type.
  4. Ability to specify a relative path to the log file in the settings.
  5. View blobs of PDF type.
  6. Autocomplete when editing table triggers for <new.> and <old.>.
  7. Ability to change column position.
  8. Ability to (not)check changes in column positions during DB comparison.
  9. Changing a cursor in the Query Editor while holding down the CTRL button when hovering over an object that can be opened.
  10. Restart the application only after saving several settings
  11. Target and source database exchange button on the comparison panel.

Fixed:

  1. ODBC driver support has been terminated.
  2. Recreation a role when adding a comment  for it.
  3. Errors of editing table foreign keys.
  4. Inability to add a comment to the index through the editing window.
  5. Adding extra versions of Red Expert to the list of Windows applications when installing a new version of the application over the old one.
  6. Action taken when clicking the Select Displayed Dataset Columns button when the Results Pane is closed.
  7. Selecting  table rows to be deleted after closing the “Data” tab and canceling the deletion.
  8. An error when the “Close all tabs” button did not close all tabs.
  9. Incorrect error handling during update.
  10. Syntax highlighting for multi-line identifiers.
  11. Application crash if user settings are broken.
  12. DDL generation for ARRAY, NUMERIC and DECIMAL columns.
  13. Improved autocomplete support for Firebird aliases and keywords.
  14. Working with tables with name length more than31
  15. Updated links for automatic Java downloads.
  16. Unreasonable memory consumption.
  17. Incorrect display of the red_expert.ico file.
  18. Functioning of such application settings as:
    1. highlighting the current line;
    2. number of saved log files;
    3. selected text color;
    4. alternative editor background;
    5. editor font color;
    6. alternative highlight color.

Download and install the new version.

1 2 3 … 18