Tag: firebird

Load testing of IBProvider v5.21.1 and Firebird v3.0.7

Leave a comment

Hello All.

We have good news for everyone who uses IBProvider in critical and complex systems.

A «large», multithreaded, load testing of the latest release of IBProvider v5.21.1 and Firebird v3.0.7 (SS, Win, x64) has been carried out.

This is more than 7 million tests that were performed on a 10-core processor.

The main point of this testing was that the global cache of the SQL query parser was used (sql_cache__scope=db).

As usual, the built-in client for Firebird (dbclient_type=fb.direct) was used.

Testing completed with no visible problems.

See additional info at our web site: https://www.ibprovider.com/eng/news/n_201225.html

Best regards, IBProvider Team.

New version of RedExpert 2020.10 has been released

Leave a comment

New version of RedExpert 2020.10 has been released.

Fixes:

  • A value of a variable is not lost when editing a procedure.
  • Object names are quoted only when necessary.
  • Removed redundancy in variable declarations.
  • Generation of a random date (There was an error that the minimum is greater than the maximum).
  • Comments to variables are not lost when editing a procedure.
  • Roles which were not created by a user have been moved under the system roles branch.
  • Few first characters in the cell are displayed instead of ‘CLOB DATA’.
  • Removed the unreasonable occurrence of the error about the loss of connection with the server.
  • Fixed generation of table DDL statement.
  • Fixed generation of procedure DDL statement.
  • Fixed generation of trigger DDL statement.
  • Fixed display of table constraints.
  • Fixed display of release notes in the application.

Improvements:

  • Added the ability to use autoddl when executing a script.
  • Added the ability to manage update rule and delete rule for foreign keys.
  • Added the ability to use autocomplete without hotkeys.
  • Added the ability to delete user settings when uninstalling the application.
  • Added the ability to work with collates of character sets in datatypes.

Download and install the new version.

New version of RedExpert 2020.08 has been released

Leave a comment

New version of RedExpert 2020.08 has been released.

The main changes:

  • the launch of the program and the search for Java have been completely redesigned. Now if Java is not found, it is suggested to specify the path manually or download Java automatically;
  • fixed display of system objects (generators, domains and functions that are not defined by the user are not displayed in the main nodes);
  • fixed execution of the script containing “execute block”;
  • fixed editing procedure with declare variables block;
  • removed the type of object while copying the name;
  • fixed display of tables if “RDB $ RELATION_TYPE IS NULL”;
  • fixed bugs with autoincrement while creating and editing tables;
  • other minor fixes.

Download and install the new version.

RedExpert: free open source tool for Firebird administration from RedSoft

Leave a comment

RedSoft, Platinum Sponsor of Firebird Foundation and contributor of Firebird Project development, has introduced the new major version of the free open-source multi-platform tool for administration and development of Firebird databases: RedExpert v2020.04.1.

The new version introduces:a test data generator, database object dependencies, and many other improvements and bug fixes.
Download here RedExpert installation and binaries.

Join RedExpert development
If you like RedExpert as a tool and as an idea of a free multi-platform high-quality tool for Firebird, and if you have experience as a Java developer or tester, or simply as advanced Firebird user, please join the development effort: RedExpert sources are available in GitHub, please submit your pull-requests there, and send your feedback, bug reports, suggestions, etc to Issues section on GitHub.

Stored routine debugger Hopper, v2.1 released

Leave a comment

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

This release brings new features for the MySQL Edition and bugfixes to the InterBase or Firebird Edition.

Version 2 includes support for Firebird 3 packages and stored functions, MySQL diagnostic-statements, binary data in variables and much more.

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 18 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.

Upscene releases Database Workbench 5.7.0

Leave a comment

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 5.7.0″

This new release brings you PostgreSQL 12 support and fixes to the Firebird and MySQL modules.

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

upscene releases new advanced data generator

Leave a comment

Upscene Productions is happy to announce the next major version of their test data generator tool:

“Advanced Data Generator 4”

A fast test-data generator tool that comes with a library of real-life data, can generate data to your database,
script or data files, many filling options, templates and much more.

  • Data settings
  • Generate JSON data files
  • Sample generated data

New article: Fast conversion from Firebird 2.5 to 3.0 with streamed backup-restore

Leave a comment

If you need to convert a very big Firebird 2.5 database to 3.0, or many databases during the short period of time (for example, overnight or during the weekend), you will definitely find useful this article: it describes how to speed up the backup-restore process by 25-30% with stream backup-restore process. 
Please read  Fast conversion of Firebird 2.5 databases to Firebird 3.0

HQbird 2018R4

Leave a comment

The minor release of HQbird, the advanced distribution of Firebird for enterprises, is available: 2018R4. The new version contains the following fixes:

  1. Improved replica initialization sequence under high load.
  2. Latest patches from Firebird sources, including the patch for tmpwatch problem for 3.0 at CentOS
  3. Simplifications of the interface for the database replication setup
  4. Significant changes in Performance Monitoring: now HQbird generates 3 reports (Duration, Frequency, and Summary), and also XLS report with top-consuming applications and statements, with all performance details (fetches, reads, writes, etc). FBPerfMon tool is excluded from HQbird ServerSide, since their functions are mostly covered by extended capabilities of Performance Monitoring.
  5. Several bug fixes

Download HQbird 2018R4 now!

Release of IBProvider v5

Leave a comment

We are proud to introduce the fifth version of our basic product for working with Firebird and InterBase.

IBProvider v5 inherits all the best from IBProvider v3 and dramatically improves the quality of implementation of the OLE DB components.

For the last few years, the main development line of IBProvider was fixing problems that prevented its stable operation. First of all, we had to fix problems not related to the provider itself — we rewrote the client for Firebird and the standard pool of OLE DB connections. It took a lot of time and resourses, but it was worth it.

Now the time has come to get to IBProvider itself.

Instead of local fixes, within the support of the third version we redesigned the inner infrastructure of the OLE DB components of IBProvider taking into account the entire experience gained over the last years. In part, the ideas were taken from our ADO.NET provider.

The main qualities of IBProvider v5 are reliability and fail safety…

Read full text of IBProvider v5 release.

With Best Regards, IBProvider Team.

1 2 3 4 5 6 … 18