Hello everyone!
For fans only:
For the first time, we managed to perform all IBProvider system tests applicable to Firebird v3 in one run. This took 26 days and a ten-core processor.
Full note text: https://www.ibprovider.com/eng/news/n_181010.html
Regards,
IBProvider Team.
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.
Disponível também em Português.
Hello!Just passing to inform that Firebird chocolatey packages are now ready for public usage. :)As easy aschoco install firebird -yto install Firebird 3.0.1 SuperServer.There’s also support for 2.1 and 2.5 releases. As well for Classic and SuperClassic installs.More info at:Best regards!F.D.Castel
Devart company continues to improve their connectivity solutions including ODBC driver for Firebird.
Recently company released new version of it’s driver which now has beta support of Linux and Mac OS. You can download new drivers now
Hi,
I think might be helpful, today for a customer i do the Haversine formulas for Firebird Sql as a stored procedure.
This formula allow you to calculate the distance in meter between two WGS84 datum points(degree points of Earth).
You can call the procedure like this:
SELECT * FROM HAVERSINE_GENERIC(1, 45,474081, 9,179348, 45,456091, 9)
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.
We in IBSurgeon decided to write Firebird Hardware guide in order to provide the necessary knowledge to anyone who wants to choose truly effective hardware for their Firebird database. To do it, you will have to learn some basic details on how Firebird, the operating system and, of course, hardware functions.
http://ib-aid.com/en/articles/firebird-hardware-guide/
Devart company updated its set of ODBC drivers for various databases including Firebird database.
New Firebird ODBC driver gained improved performance and:
Check what our new ODBC drivers can offer to you.
Following the updated release of IBDAC (Delphi data access components for Firebird) Devart released a huge update of it’s dbExpress drivers. Among them you can find updated dbExpress driver for Firebird/Interbase.
Among many improvements and bug fixes those drivers received RAD Studio 10 support and now the trial limitation by 6 columns is removed from the Trial version for Win64 and it becomes a fully-functional Professional Edition.
You can already download new updated dbExpress driver for Firebird now – https://www.devart.com/dbx/interbase/download.html
Devart company released a huge update of all its Delphi data access components including Firebird/Interbase data access components (IBDAC).
IBDAC 5.6 main updates/fixes are:
You can already download new IBDAC 5.6 now and use it in your projects.
Devart team is proud to introduce new Firebird ODBC Drivers.
The most significant features in this version are:
– Drivers fully support standard ODBC API functions and data types, multiple server data types and features.
– Advanced connection string parameters provided to allow any desktop and web applications to access databases from various environments and platforms, that support ODBC.
– Full Unicode support provides capacity to interpret Unicode function calls without the intervention of the Driver Manager.
– Advanced data conversion from DBMS data types to native ODBC data types.
– Support for 32-bit and 64-bit Windows platforms provides capabilities to develop both 32-bit and 64-bit cross-platform database applications (Linux and Mac OS X platforms will be supported in the next version).
ODBC driver for Firebird supports Firebird server and client versions 2.x, 1.x.
