Category: General news
Firebird related news
PyFirebirdSql 1.0.1 is released
PyFirebirdSql 1.0.1 is released with ipv6 support and other fixes that can be reviewed in the commits log .
Firebird Perl extension DBD-Firebird version 1.31 is released
Perl extension DBD::Firebird version 1.31 is released with quite a few changes if you compare with provious announcement , here are a few from the ChangeLog:
* remove artificial hard-coded limit of 1_000_000 bytes when fetching BLOB data
* add /usr/local to the list of possible firebird homes [RT#123723]
* blob_type needs to be signed to be assigned/compared to -1
* bpb parameter to isc_open_blob2 is a pointer
* drop unused column character set definition
* correctly check for Test::CheckDeps presense
* finish: do not check uninitialised status vector If statement type is isc_info_sql_stmt_exec_procedure,isc_dsql_free_statement is not called and there is no point checking the status vector for errors. An error there may be from a previous call, or just plain garbage.
Fixes Debian bug : 883183 — test failure on i386, and RT#110979
* add support for a ‘timeout=$secs’ parameter [RT#119764]
* put fb_api_ver in XS and make it available to both embedded and regular driver
* more constants for client version (major/minor/full version string)
Presentations from Firebird Tour 2017: Firebird 3 Statistics and Plans and Advanced Trace API
More presentations from Firebird Tour 2017:
- Firebird 3: New in Database Statistics and New SQL execution plans, by Dmitry Kuzmenko, IBSurgeon
- Advanced Firebird Trace API, by Vlad Horsun, Firebird Project
Stay tuned for more interesting materials!
Entity Framework Core 2.0 provider for Firebird now in beta
Jiří Činčura announced that Entity Framework Core 2.0 provider for Firebird is now in beta stage.
Lazarus Release 1.8 (with FPC 3.0.4)
The Lazarus team is glad to announce the release of Lazarus 1.8.
The release was built with FPC 3.0.4.
Presentations from Firebird Tour 2017: Firebird Performance and Tuning Linux and Windows
We start to publish presentations from Firebird Tour 2017. Please find the first 2 presentations below:
“Firebird Performance“, by Vlad Khorsun, Firebird Project
“Tuning Linux, Windows, and Firebird for heavy workload” by Alex Kovyazin, IBSurgeon.
More presentations will be published later – stay tuned!
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:
- 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 support@ib-aid.com
ADO.NET provider 5.12.0.0 for Firebird is ready
Database .NET 23.5 and dbMigration .NET 6.8 released
Database .NET 23.5 and dbMigration .NET 6.8 have been released.
(Full support for Firebird 1.5~4.0+ Embedded and Server)
For more information please visit the following links:
http://fishcodelib.com/Database.htm (Change Log 2017/11/15)
http://fishcodelib.com/DBMigration.htm (Change Log 2017/11/15)