Via Lattanzio,23 Milano
+39 02 36592025
info@synaptica.info

Categoria: Firebird SQL

Firebird Performance Tour 2019 – Prague

  Synaptica has always adopted Firebird as its main database environment for the realization of many solutions from embedded iot products to Web solutions with thousands of daily accesses. Firebird proved to be a great tool, flexible and easy to manage. For this reason we could not miss the appointment to meet the creators (Dmitry…
Leggi tutto

smartFB a free tool for Interbase & Firebird

SmartFB is a free SQL client for Interbase and Firebird made for internal / educational use. As we think it will be useful we decided to make it available for download. It is in “beta” version, but I think it could be useful, so you can download it from the following links: – Download Windows…
Leggi tutto

Firebird 3.0 & Ubuntu Server 18.04

Primo test di porting database alla versione Firebird 3.0 che è la versione ufficialmente afficancata ai pacchetti di distribuzione standard di Ubuntu nella versione LTS attuale 18.04. Le differenze tra la versione 3.0 di FB e le precedenti sono moltissime. Ma i passaggi sono abbastanza semplici per effettuare il porting dalle versioni precedenti alla attuale…
Leggi tutto

Firebird Sql Tips… Enable or Disable all trigger via sql

To enable and disable all triggers of a database i do two procedure : Enabling all database trigger:

Disabling all database trigger:

Firebird SQL & Interbase list of all foreign keys

With that simple peace of code you can retrive the full list of all “FK” Foreign Key of an Interbase or Firebird DB.

The Haversine formula in Firebird SQL => Calculate distance between two 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:

The result wil be aprox 14Km, the…
Leggi tutto