Firebird News

Thursday, December 19, 2019

Firebird driver for PHP 7.4 ready for download

Firebird driver for PHP 7.4 ready for download


Tuesday, December 17, 2019

Firebird high-level native client for Node.js / TypeScript updated to v2.0

Firebird high-level native client for Node.js / TypeScript updated to v2.0 with a few changes :

native-driver

  • Feature #34 - Support for Firebird events.
  • Feature #42 - SQL role name in connection options.

native-api

  • Minimal node version is 10.6.0.
  • Fix #41 - Error: pointer argument must be an instance of Pointer class or null with node v13.

all projects

  • Upgrade TypeScript to v3.7.

Thursday, November 21, 2019

Sourcetrail is now free and open-source

Sourcetrail is very useful when you try to study/navigate large C++ codebases like @firebirdsql / @LibreOffice


Monday, October 28, 2019

Replication in Firebird 4: Configuration and practical examples

Replication is a long-awaited feature that allows the creating of reliable high-performance database replicas without user-defined triggers and with full DDL support. This talk presents the replication subsystem architecture, possible replication modes, their impact on performance and available tuning options. We'll demonstrate how to set up a simple standby configuration and use it in practice.


Download PDF

Firebird on the road from v4 to v5

This talk done at Firebird Conference 2019 describes the current state of the v4 development and reviews its key features (new data types, Batch API, timezones). Dimitry Yemanov spoke about the future of Firebird development, including the updated release plan and expected post-v4 features. Review of upcoming features for Firebird 5


Download PDF



Wednesday, October 02, 2019

Embedded Firebird 3 Framework on MacOSX

Paul Beach has finally managed to get around to preparing a mechanism for creating an embedded Firebird Framework on MacOSX.


If you can’t build Firebird from scratch you can download a copy of the embedded framework (currently Firebird 3.0.4) from IBPhoenix. (Approx 15mb)

32bit Embedded Framework

64bit Embedded Framework

Thursday, September 05, 2019

Understanding High Performance

Understanding High Performance via Michael Abrash's Graphics Programming Black Book

"Before we can create high-performance code, we must understand what high performance is. The objective (not always attained) in creating high-performance software is to make the software able to carry out its appointed tasks so rapidly that it responds instantaneously, as far as the user is concerned. In other words, high-performance code should ideally run so fast that any further improvement in the code would be pointless.
Notice that the above definition most emphatically does not say anything about making the software as fast as possible. It also does not say anything about using assembly language, or an optimizing compiler, or, for that matter, a compiler at all. It also doesn't say anything about how the code was designed and written. What it does say is that high-performance code shouldn't get in the user's way—and that's all.
That's an important distinction, because all too many programmers think that assembly language, or the right compiler, or a particular high-level language, or a certain design approach is the answer to creating high-performance code. They're not, any more than choosing a certain set of tools is the key to building a house. You do indeed need tools to build a house, but any of many sets of tools will do. You also need a blueprint, an understanding of everything that goes into a house, and the ability to use the tools.
Likewise, high-performance programming requires a clear understanding of the purpose of the software being built, an overall program design, algorithms for implementing particular tasks, an understanding of what the computer can do and of what all relevant software is doing—and solid programming skills, preferably using an optimizing compiler or assembly language. The optimization at the end is just the finishing touch, however."

Tuesday, September 03, 2019

ADO.NET provider 7.1.0.0 for Firebird is ready

New version 7.1.0.0 of ADO.NET provider for Firebird is ready for download. The main focus of this release is performance.

Wednesday, August 21, 2019

New version 7.0.0.0 of ADO.NET provider for Firebird is ready for download.

New version 7.0.0.0 of ADO.NET provider for Firebird is ready for download. The main focus of this release is wire encryption.

Monday, August 12, 2019

Firebird high-level native client for Node.js / TypeScript updated to v1.0.0

Firebird high-level native client for Node.js / TypeScript updated to v1.0.0

Thursday, April 18, 2019

Xubuntu 19.04: The Exhaustive Update

Xubuntu 19.04: The Exhaustive Update #Xubuntu #Xfce #DiscoDingo https://bluesabre.org/2019/04/18/xubuntu-19-04-the-exhaustive-update/

Thursday, February 21, 2019

Firebird 4.0 Beta 1 release is available for testing

Firebird Project announces the first Beta release of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing.

This Beta release arrives with features and improvements already implemented by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.

Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

Please read the Release Notes carefully before installing and testing this Beta release.

Saturday, February 09, 2019

Pure Elixir database driver for Firebird

Pure Elixir database driver for Firebird

Firebird 4.0 Built-in logical replication

Firebird 4.0 implemented Built-in logical replication is now merged

Here is the pull request

https://github.com/FirebirdSQL/firebird/pull/182


We know that is a long standing feature request

Firebird 4.0 Changed travis distribution used to Ubuntu xenial.

Firebird 4.0 is using Ubuntu xenial on travis .
https://travis-ci.org/FirebirdSQL/firebird

.travis.yml looks a lot simpler after this change.

Build Status 
ps: Here is official Travis CI announcement: Ubuntu Xenial 16.04 is available

Tuesday, February 05, 2019

Max Transaction ID in Firebird



Firebird 3.0.x introduced 48-bit internal transaction IDs that are publicly (via API and MON$ tables) represented as 64-bit numbers. This makes the new limit roughly equal to 2.8*10^14 transactions, later it could be extended up to the 2^63 limit.


Related notice in Firebird 3.0.x release notes.
Related article about Posgtresql : How long will a 64 bit Transaction-ID last in PostgreSQL?

Friday, January 18, 2019

Understanding Debian: The Universal Operating System

"And my final test as to whether or not Debian succeeded was: could the founder step away from the project and could the project keep going because that is the only point at which you know that the project has basically taken a life of its own." ~ Ian Murdock