Tag: firebird

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.

Final release of «Native OLE DB Provider for Firebird v4»

Leave a comment

Hello Everyone!

We are very pleased to announce the release of final IBProvider v5.32 with support for Firebird v4.

Some of our users have already appreciated our work and started using IBProvider with FB4, including as a linked MSSQL server.

We are grateful to everyone who helped us.

Special thanks to Marek D., who initiated this process.

General overview of FB4 support in IBProvider

  • The direct connection and connection through fbclient.dll are supported
  • The 63-symbols object names are supported
  • Provider supports the following new datatypes (including arrays):
    • INT128
    • NUMERIC on INT128 base
    • DECFLOAT(16)
    • DECFLOAT(34)
    • TIMESTAMP WITH TIME ZONE
    • TIME WITH TIME ZONE
  • Provider supports two mode for processing time zones:
    • Through own algorithms
    • Through external library (ICU)
  • The support of the following queries was implemented:
    • SET DECFLOAT ROUND
    • SET DECFLOAT TRAPS
    • SET BIND
  • Provider executes ALTER SESSION RESET before reusing of the connection. Example
  • The new connection initialization properties were added.

In addition to the above, we have significantly improved the existing functionality.

Therefore, it makes sense to upgrade even if you are not yet planning to move to FB4 or are working with InterBase.

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

With Best Regards, IBProvider Team.

1 2 3 … 18