If you need to convert a very big Firebird 2.5 database to 3.0, or many databases during the short period of time (for example, overnight or during the weekend), you will definitely find useful this article: it describes how to speed up the backup-restore process by 25-30% with stream backup-restore process. Please read Fast conversion of Firebird 2.5 databases to Firebird 3.0
The minor release of HQbird, the advanced distribution of Firebird for enterprises, is available: 2018R4. The new version contains the following fixes:
Improved replica initialization sequence under high load.
Latest patches from Firebird sources, including the patch for tmpwatch problem for 3.0 at CentOS
Simplifications of the interface for the database replication setup
Significant changes in Performance Monitoring: now HQbird generates 3 reports (Duration, Frequency, and Summary), and also XLS report with top-consuming applications and statements, with all performance details (fetches, reads, writes, etc). FBPerfMon tool is excluded from HQbird ServerSide, since their functions are mostly covered by extended capabilities of Performance Monitoring.
Now the time has come to get to IBProvider itself.
Instead of local fixes, within the support of the third version we redesigned the inner infrastructure of the OLE DB components of IBProvider taking into account the entire experience gained over the last years. In part, the ideas were taken from our ADO.NET provider.
The main qualities of IBProvider v5 are reliability and fail safety…
InterBase was created in 1985: it was the first commercial multi-versioning database. In the end of 1999, Borland decided to close InterBase development and published its source codes under InterBase Public License. This code was copied (it is permitted by the license), and Firebird was born – from the version 1.0 Firebird is a production-ready database, based on previous decades of InterBase development.
At the end of 2000, Borland turned back to the closed source and commercial licenses (exactly as it was earlier) with InterBase and started development of 6.5.
Firebird 1.0 was released in 2002, with many bugfixes and extensions of DDL and DML. The active Firebird development continued after 1.0, and in 2004 the second major version of Firebird (v.1.5) was released. Borland at that time also has introduced new versions (7.0 and 7.1). Firebird 1.5 and InterBase 7.0 was incompatible both by database format (ODS) and core functionality. The migration from InterBase to Firebird and back with backup/restore is impossible since Firebird 2.0 and InterBase 7.0.
Since then, the difference between Firebird and InterBase became bigger.
Check the full article from IBSurgeon, and see the currently diferences between Interbase and Firebird.
You can often see the following question in Firebird technical support groups: “What is the hardware of choice for the Firebird DBMS?”. This topic remains permanently popular because hardware requirements differ by tasks and hardware itself changes with time.