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)

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/

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

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

 

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.

New Firebird ODBC drivers released

 

odbc-conformance

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.

More details     Download Firebird ODBC driver

IBProvider 3.18. Better support of MSSQL. Changeover to the new VS 2012 compiler

We are pleased to announce the new release of our OLEDB Provider: version 3.18.

Now in your projects for Firebird and Interbase you can more comfortable work with Linked Server of MSSQL 2012. Hurrah!

In new release:

  • Improved performance of the provider as a linked MSSQL server.
  • Provider compilation with Visual Studio 2012.

Plus:

You can download IBProvider here: Firebird and Interbase driver >>>

1 2 3 4 15