Month: January 2011
Habarisoft announces FireAlarm open source monitoring for the Firebird #RDBMS
Today Habarisoft announced the start of the FireAlarm project, a monitoring solution for the Open Source RDBMS Firebird.
FireAlarm checks Firebird servers for high load situations, caused by software failures or denial of service (DOS) attacks, and helps developers or database administrators to detect performance bottlenecks. It is written in the Java programming language and released as open source.
Quick Start Guide to index optimisation
Below a five point Quick Start Guide to index optimisation, courtesy of Pavel Cisar.
From Oracle to FireBird – a comparison of functions
We have made an comparison of functions between Oracle and FireBird to avoid the nice (but incomplete) UDF-library UDF4Ora. Most of the Oracle functions are similar to FireBird- or FreeAdhocUDF-functions. Here you find a complete liste of comparison.
If you are interested in one (or more) not presented functions send an eMail to help@freeadhocudf.org.
Christoph Theuring / FreeAdhocUDF.org
Core changes:plugin manager merged in trunk , stored procedures speedup in 2.5.1
Dimitry fixed one bug with stored procedures slowdown in some cases :Tuned the code a little in order to avoid redundant retrievals. As a side effect, it downgrades three-way joins to two-way ones, thus helping the optimizer to choose a good plan in the worst (zero selectivity) cases. This should resolve CORE-2933 (Very slow execution of a script that creates a lot of metadata) and CORE-3237 (Slow compilation of stored procedures) without tweaking the optimizer constants.
New plugin manager was committed to trunk. Use it for all types of plugins.
Alex Peshkoff Fixed binary packages build. No more CS/SS difference. No more linux RPMs on SF (now they are created on each distro anyway)
Another interesting bug fixed in the future 2.5.1 is CORE-2756 :substring from timestamp – unexpected result
crypt-o software powered by firebird
While on firebird-architect there was a serious discussion about encryption i found on the web the following software that uses firebird
Crypt-o will help you to organize and store securely any kind of valuable information, such as logins, passwords, customers or employees lists, access codes, credit card numbers, PIN codes, files, etc.
Crypt-o is a secure Client/Server solution for creating custom databases, which is designed for use in enterprise networks. The data is reliably stored in Firebird SQL Server database and is encrypted using AES encryption algorithm with 256-bit key. Crypt-o client applications access the Crypt-o Server using secure SSL connection.
Pictures from Firebird course
Kelver Merlotti posted (a few moths already) about the Firebird course and took pictures of one happy event:
Good morning! Saturday was a party in the course of # Firebird, to celebrate my birthday
Really nice guys! Following pictures:
Relax, firebirdsql.org main website is back online
Now you can access the main website , we hope that is faster now 🙂
4 key distinctions of the new IBProvider v3.4 that make your applications faster
4 key distinctions of the new IBProvider v3.4 that make your applications faster:
Please read details here: Firebird driver become faster
django-firebird switched for #django 1.2/1.3 support only in svn trunk
The django-firebird trunk was updated with new version. It supports django 1.2 and I hope what support the next 1.3 release too.
I was using this version on production web app and all work fine for
now.[ED:also firebirdsql.ro works ok with it]
The prior django-firebird implementation with support for django 1.1 was tagged
Please, feel free to check it out and report any issue.
Any feedback is wellcome.

