Philippe Makowski's blog

About Firebird, Mageia, ...

Articles in the Firebird other category

Tue 05 May 2009

Firebird other

Firebird packages for Fedora, Centos, RHEL

It's official now, I'm the maintainer of Firebird packages for Fedora and Epel (Centos and RHEL packages) and Firebird packages get pushed into Fedora repositories. The good news for Firebird users is that they can get Firebird 2.1.2 from Fedora official ...

Wed 29 April 2009

Firebird other

Lost connections

Last months I saw in various support lists and forum questions about lost connections and Firebird As said in firebird.conf : Normally,Firebird uses SO_KEEPALIVE socket option to keep track of active connections. If you do not like default 2-hour ...

Thu 05 March 2009

Firebird other

From the Firebird support list : semaphores exhausted

Running FirebirdCS-2.1.1.17910-0.amd64 under Linux Fedora core 9 version 2.6.27.15-78.2.23.fc9.x86_64 When thedatabase is under a high load (i.e. over 100 connections) where each connection is doing queries and updates, then merely executing select ...

Fri 30 January 2009

Firebird other

Firebird 2.1.2 on Mips 64

Yesterday I get a small nice box, a Gdium that havea 900 Mhz 64bits Loongson CPU It comes with a Mandriva Linux. I built Firebird 2.1.2 on it, the only point is that I built it with systemICU : 1./autogen.sh --with-system-icu Bingo, I get a fresh build ...

Thu 29 May 2008

Firebird other

Firebird and Suse

May, 20th in the opensuse packaging mailing list, Michal Marek posted the following : We have a firebird (the opensource SQLdatabase) package in the server:database buildservice project ...

Tue 15 April 2008

Firebird other

Heavy load under MacOs X

During the test phase of Firebird 2.1, I played with two new features : global temporary table and monitoring tables. I never stressed Firebird on MacOs X before, and when I tried to do 300 concurrent connections each one using a temporary table and a ...

Sun 09 March 2008

Firebird other

Recalculer la sélectivitité des index

Quelques fois il peut être utile de forcer le moteur à recalculer la sélectivité des index afin de permettre à l'optimiseur de choisir des meilleurs plans de requête et donc de faire les traitements plus rapidement Voici une procédure permettant de ...

Sun 09 March 2008

Firebird other

Comment convertir en majuscule les lettres accentuées

Si on utilise ISO8859_1 comme jeu de caractères, on peut choisir comment convertir en majuscule les lettres accentuées par exemple : 1 2 3 4SELECT UPPER(CAST('aeiouéèàüûôë' AS CHAR(12) CHARACTER SET ISO8859_1) )C_NP, UPPER(CAST('aeiouéèàüûôë' AS CHAR(12) ...

Sun 09 March 2008

Firebird other

Détecter et supprimer des doublons

Il arrive quelques fois que l'on soit obliger de détecter ou supprimer desdoublons dans des tables sur un champ particulier. Cela peut devenir une opération très longue et gourmande en ressources.Heureusement on peut utiliser pour améliorer les ...

Sun 09 March 2008

Firebird other

Vues système SQL-92

Voici quelques définitions de vues système conformes à la norme SQL-92: Lister les contraintes CHECK CREATE VIEW CHECK_CONSTRAINTS (CONSTRAINT_NAME,CHECK_CLAUSE) AS SELECT RDB$CONSTRAINT_NAME, RDB$TRIGGER_SOURCE FROM RDB$CHECK_CONSTRAINTS RC, RDB$TRIGGERS ...