Batch API benchmark
Gerdus van Zyl published an article comparing the speed of bulk operations using the Firebird batch API (introduced in FB 3) and the standard/legacy API.
Check it out, the results are very interesting.
(No Ratings Yet)
Loading...Jaybird 4.0.8 released
Jaybird 4.0.8 has been released
The following has been changed or fixed since Jaybird 4.0.7:
- Improvement: Backported new generated keys parser from Jaybird 5 to remove dependency on ANTLR (jaybird#718) With this change, Jaybird no longer relies on antlr-runtime-4.7.2.jar, if you don’t need it yourself, you can remove this library from the classpath. See New parser for generated keys handling for more information.
Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11, 17 and 19 (support for Java 17 and 19 using the Java 11 version of the driver).
See also
(2 votes, average: 5.00 out of 5)Loading...Django firebird driver 2.2.1 released
Django Firebird driver 2.2.1 released with a small fix for issue #108
https://pypi.org/project/django-firebird/2.2.1/
Also master branch is patched (that can be used with django 3.x)
(2 votes, average: 5.00 out of 5)Loading...Jaybird 4.0.7 released
Jaybird 4.0.7 has been released
The following has been changed or fixed since Jaybird 4.0.6:
- Improvement: (VAR)CHAR is now sent to the server with blr_varying2 or blr_text2 which includes the character set information (jaybird#692)
- Changed: Usages of String.toUpperCase and String.toLowerCase now use Locale.ROOT to prevent locale-sensitivity issues (jaybird#697)
- New feature: Support for NBackup “clean history” option (jaybird#706)
The org.firebirdsql.management.NBackupManager interface has three new methods: setCleanHistory(boolean) to enable (or disable) cleaning of history during backup, and setKeepDays(int) and setKeepRows(int) to specify the number of days or rows to keep history. These options require Firebird 4.0.3 or higher.
This feature was backported from Jaybird 5. - Fixed: Calling PreparedStatement.setClob or PreparedStatement.setBlob with a null Clob, Reader, Blob, or InputStream would result in a NullPointerException (jaybird#712)
As part of this change the behaviour of setClob methods accepting a Reader was changed to be identical to setCharacterStream, and setBlob accepting an InputStream to setBinaryStream. The end result before and after this change is identical, but it can result in different memory and performance characteristics, as the stream is now consumed on execute, and not on set.
Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11, 17 and 19 (support for Java 17 and using the Java 11 version of the driver).
See also
(2 votes, average: 5.00 out of 5)Loading...IBProvider News
Hello Everyone!
We came back with new releases 🙂
We have just finished the large revision of our components and we are really glad to announce the following new versions:
- LCPI EF Core Provider for OLE DB v6.0.8
- LCPI IBProvider v5.26
- LCPI OLE DB Services v1.21
You can read about changes in these components at our website – https://www.ibprovider.com/eng/news/n_221110.html
Only for visitors of this resource. We restored our store at PayProGlobal and we would like to test it 🙂
Everyone who will buy or renew a license for IBProvider 32/64bit till the end of this month will get two years of free updates.
With Best Regards, IBProvider Team.
(No Ratings Yet)Loading...Github Action : Setup FirebirdSQL updated to 1.2.0
Github Action : Setup FirebirdSQL updated to 1.2.0.
This GitHub Action sets up a Firebird database running on a docker container.
(2 votes, average: 5.00 out of 5)Loading...Node Firebird driver node-firebird 1.1.3 is released
(2 votes, average: 5.00 out of 5)Loading...ADO.NET provider 9.1.0.0 for Firebird is ready
More info at this link.
(1 votes, average: 5.00 out of 5)Loading...Fixed IB DataPump
Probably almost everyone who have worked with Firebird and Interbase know this nice utility called IB DataPump, from CleverComponents (CC). It is a Windows GUI tool that allows data to be pumped from IB/FB or different RDBMSs to Firebird/Interbase databases.
Unfortunately, the (original old) tool had a problem that avoided pumping to Firebird 3 databases (you got a “list index out of bounds” error). CC seems to have fixed that problem but one of the most useful features is was still broken: the automatic reorder of the tables to avoid broken dependencies based on the existing Foreign Keys!
The good news is that CC open sourced this tool a while ago, and Vlad Khorsun (our fellow Firebird’s Core Developer) was able to fix that problem!
Now you can download the fixed version here.
Thanks, Vlad, for the time spent fixing this problem, and please enjoy my small donation for your work 🙂
Update 03-Nov: Vlad has now published his changes.
(9 votes, average: 5.00 out of 5)Loading...New release of extension package for Firebird driver – firebird-lib v1.2.2 is released.
New release of extension package for Firebird python driver – firebird-lib v1.2.2 is available for download.
(3 votes, average: 5.00 out of 5)Loading...