Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:
” Database Workbench 5.7.0″
This new release brings you PostgreSQL 12 support and fixes to the Firebird and MySQL modules.
Database Workbench 5 comes in multiple editions with different pricing models, there’s always a version that suits you!
Upscene Productions is happy to announce the next major version of their test data generator tool:
“Advanced Data Generator 4”
A fast test-data generator tool that comes with a library of real-life data, can generate data to your database,
script or data files, many filling options, templates and much more.
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:
We are proud to introduce the fifth version of our basic product for working with Firebird and InterBase.
IBProvider v5 inherits all the best from IBProvider v3 and dramatically improves the quality of implementation of the OLE DB components.
For the last few years, the main development line of IBProvider was fixing problems that prevented its stable operation. First of all, we had to fix problems not related to the provider itself — we rewrote the client for Firebird and the standard pool of OLE DB connections. It took a lot of time and resourses, but it was worth it.
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…
Read full text of IBProvider v5 release.
With Best Regards, IBProvider Team.
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)
