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:
- 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.
- 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.
- Pool of connections for external statements (for version 2.5) which greatly increases the performance of Execute On External statements
- Pool of prepared statements (for version 3.0) which greatly improves the performance in case of frequent parametrized queries
- 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 email@example.com
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 2.5 Language Reference is released with document version 1.000.
Here is the Helen Borrie commit.
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 firstname.lastname@example.org: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.
Adriano added two new builtin functions FIRST_DAY and LAST_DAY.
Here is the Github commit a2556be .
Meiji Kimura and Hajime Nakagami created Firebird Advent Calendar 2017 , there Firebird Japanese community will post articles in each day of Advent period.
You can check for articles from the previous year for inspiration.
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 .
The first pre-beta release of the English version of the Firebird 3 Develoepers Guide is now publicly available. Please report any problems or mistakes. The translation work, from Russian to English, was sponsored by a crowdfunding campaign. Thanks to all who contributed!