databases - Synaptica srl

Interbase 2019

per Ivan Revelli
in Senza categoria
on Agosto 6, 2019

In questo Agosto Embarcadero annuncia la nuova versione del noto database relazione Interbase : Interbase 2019. Interbase è molto utilizzato dagli sviluppatori Delphi dato che in ambito multi piattaforma (iOS,Android,Windows,Mac OSX, Linux) credo sia l’unico database relazionale distribuibile anche su piattaforme iOS / Android, le versioni di interbase per la distribuzione in ambito mobile sono…
Leggi tutto

Firebird Performance Tour 2019 – Prague

per Ivan Revelli
in databases, databases, databases, databases, databases, databases
on Dicembre 4, 2018

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

per Ivan Revelli
in Articoli, Articoli, Articoli, Articoli, Articoli
on Ottobre 31, 2018

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

per Ivan Revelli
in Articoli, Firebird SQL, Firebird SQL, Firebird SQL, Firebird SQL
on Ottobre 29, 2018

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

Orace Tips – Recursive query

per Ivan Revelli
in oracle
on Ottobre 26, 2016

select PK_ID
from USERS
start with FK_USER_PARENT = PK_USER
connect by prior PK_ID = FK_USER_PARENT;

select PK_ID

from USERS

start with FK_USER_PARENT = PK_USER

connect by prior PK_ID = FK_USER_PARENT;

Firebird Sql Tips… Enable or Disable all trigger via sql

per Ivan Revelli
in Senza categoria
on Marzo 9, 2016

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

create procedure SP_ENABLE_ALL_TRIGGER
as
begin
  /* Procedure Text */
   update RDB$TRIGGERS set RDB$TRIGGER_INACTIVE=0
    where RDB$TRIGGER_NAME
    in(
    select
    A.RDB$TRIGGER_NAME
    from RDB$TRIGGERS A left join RDB$CHECK_CONSTRAINTS B ON
    B.RDB$TRIGGER_NAME = A.RDB$TRIGGER_NAME where ((A.RDB$SYSTEM_FLAG = 0)
    or (A.RDB$SYSTEM_FLAG is null)) and (b.rdb$trigger_name is null)
    AND (NOT(A.RDB$TRIGGER_NAME LIKE 'RDB$%'))
    );
  suspend;
end

create procedure SP_ENABLE_ALL_TRIGGER

begin

/* Procedure Text */

update RDB$TRIGGERS set RDB$TRIGGER_INACTIVE=0

where RDB$TRIGGER_NAME

in(

select

A.RDB$TRIGGER_NAME

from RDB$TRIGGERS A left join RDB$CHECK_CONSTRAINTS B ON

B.RDB$TRIGGER_NAME = A.RDB$TRIGGER_NAME where ((A.RDB$SYSTEM_FLAG = 0)

or (A.RDB$SYSTEM_FLAG is null)) and (b.rdb$trigger_name is null)

AND (NOT(A.RDB$TRIGGER_NAME LIKE 'RDB$%'))

);

suspend;

end

Disabling all database trigger:

create procedure SP_DISABLE_ALL_TRIGGER
as
begin
  
   update RDB$TRIGGERS set RDB$TRIGGER_INACTIVE=1
    where RDB$TRIGGER_NAME
    in(
    select
    A.RDB$TRIGGER_NAME
    from RDB$TRIGGERS A left join RDB$CHECK_CONSTRAINTS B ON
    B.RDB$TRIGGER_NAME = A.RDB$TRIGGER_NAME where ((A.RDB$SYSTEM_FLAG = 0)
    or (A.RDB$SYSTEM_FLAG is null)) and (b.rdb$trigger_name is null)
    AND (NOT(A.RDB$TRIGGER_NAME LIKE 'RDB$%'))
    );
  suspend;
end

create procedure SP_DISABLE_ALL_TRIGGER