Release of IBProvider v5

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.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Firebird x InterBase

Historical overview

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.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Firebird Chocolatey package available

Hello!
 
Just passing to inform that Firebird chocolatey packages are now ready for public usage.​ ​:)
 
As easy as
choco install firebird​ ​-y
 
to 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
1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 3.67 out of 5)
Loading...

The Haversine formula => Calculate distance between to WGS84 Points

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)
1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 5.00 out of 5)
Loading...

Read “Firebird Hardware Guide” to effectively choose hardware

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/

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 5.00 out of 5)
Loading...

New Firebird ODBC driver 1.2 released

Devart company updated its set of ODBC drivers for various databases including  Firebird database.

New Firebird ODBC driver gained improved performance and:

  • Compatibility with Microsoft Visual Studio is improved
  • Compatibility with Microsoft Office is improved
  • Compatibility with Microsoft SQL Server Management Studio is improved
  • Compatibility with Crystal Reports is improved
  • Compatibility with ClikView is improved

Check what our new ODBC drivers can offer to you.

Download Firebird ODBC driver 1.2

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

New Firebird dbExpress drivers released

banner_dbx

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

 

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Released a new version of Firebird Delphi data access components (IBDAC)

banner_dac

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:

  • RAD Studio 10 Seattle is supported
  • INSERT, UPDATE and DELETE batch operations are supported
  • Now Trial for Win64 is a fully functional Professional Edition
  • Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
  • Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
  • SQLMonitor behavior on using similar objects is fixed
  • Bug with endless reconnection in assigned connection is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed
  • Bug when working with databases having charset NONE is fixed

You can already download new IBDAC 5.6 now and use it in your projects.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
1 2 3 15