HQbird 2018: New version of advanced FirebirdSQL distribution

We are glad to release the new major version of advanced Firebird (2.5 and 3.0) distribution: HQbird 2018. The key new features are the following:

  1. Online initialization of asynchronous replication (in the Enterprise edition). Now it is possible to initialize and re-initialize database replicas with zero downtime of the master server.
  2. Automatic performance monitoring (in all editions), with the performance reports which show the slowest and the most frequent SQL queries, and with the advanced monitoring of long-running active transactions.
  3. Pool of connections for external statements (for version 2.5) which greatly increases the performance of Execute On External statements
  4. Pool of prepared statements (for version 3.0) which greatly improves the performance in case of frequent parametrized queries
  5. New version of Firebird SQL Studio, now with the support of encrypted databases

Please refer to HQbird User Guide for more details!

For those, who downloaded trials of previous HQbird versions: we have reset all previous trial registrations to the end of December 2017.

All registered users of HQbird 2015, HQbird 2016 and HQbird 2017 will receive the free upgrade to HQbird 2018!
For Windows users – it is possible to install HQbird 2018 over the existing installation and keep the configuration.

HQbird 2018 comes in 3 editions:

  • Standard ($399): automatic backups, automatic maintenance, and automatic performance monitoring
  • Professional ($599): Standard + Recovery tools (FirstAID Tech Support) + SQL Studio.
  • Enterprise ($799): Professional+ replication (asynchronous and synchronous)

More details here: https://ib-aid.com/en/hqbird-features

Please feel free to ask any questions through email support@ib-aid.com

New IBProvider v3.47 and “LCPI ADO.NET Provider” for .NET Standard 2.0

Hello Everyone!

We have a great piece of news for all users of IBProvider v3 — we have rewritten the latest subsystem inherited from the second version of the provider.

In other words, we have finally fully updated and improved the entire IBProvider v3!

In addition to updating the IBProvider, we released new assemblies of our ADO.NET provider for .NET Standard 2.0 and refreshed the “LCPI OLE DB Services”.

Full news text: http://www.ibprovider.com/eng/news/n_171114.html

Firebird Documentation SourceForge CVS to GitHub migration is done

News via Firebird-Docs mailing list :

The migration from SourceForge CVS to GitHub has been completed. The repository is at https://github.com/FirebirdSQL/firebird-documentation (with clone URL git@github.com:FirebirdSQL/fiebird-documentation.git or https://github.com/FirebirdSQL/firebird-documentation.git )

Members of the firebird-documentation team have write access to the repository, and in addition to me and Helen, I have given Paul rights to add (or remove) members from this team.

Be aware that FirebirdSQL organization members that are marked as ‘owner’ also have write access and can manage the team.

I have disabled the issues and projects features, but left the Wiki enabled.
If there are any problems or questions, let me know.

Mark


Mark Rotteveel

UDFs are deprecated in Firebird 4

From Firebird 3 to 4 list of know incompatibilities file :

UDFs are deprecated in v.4. That means that UDFs can’t be used with default configuration (parameter “UdfAccess” set to “None”) and all sample UDF libraries (ib_udf, fbudf) are not distributed any more. Most of functions in that libraries were replaced with builtin analogs in previous versions and therefore already deprecated. A few remaining functions got safe replacement in UDR library “udf_compat“, namely div, frac, dow, sdow, getExactTimestampUTC and isLeapYear. Users who still wish to use UDFs should set “UdfAccess” to “Restrict <path-list>”. If you never used to modify this parameter before path-list is just UDF and resulting line in firebird.conf should be:
UdfAccess = Restrict UDF
Recommended long-term solution is replacing of UDF with UDR.

Ps: Here is the related git commit .

1 2