Interbase Stored Procedure Grammar

One of our customer recently wanted to perform some heavy duty computations on his Interbase Stored Procedures (analysis and transformations).
Instead of plunging head on in an ad-hoc tool, we started to build a general parser. So we had to start-off with a BNF grammar. We already presented a simplified Sql grammar for the main INSERT, UPDATE, DELETE and SELECT requests. So we extended this grammar to handle the stored procedures as well.

Most of the grammar applies to Firebird as well. You can read the full article here.

Poll about auto-index stats update in FB

Dear users,
I work at a project related to a possibility to have the index statistics auto-updated and humbly I ask your opinion. Please feel free to vote below.
TIA,
m. Th.

PollPub.com Vote

How do you look a possible implementation of Auto update index statistics in Firebird?

Very useful.
It would be nice, but I can live without.
Indiferent.
I preffer my own custom way to update the statistics.
No, I’m against it.
What is this about? (or I don’t know what ‘statistics’ are)

View Results

Poll powered by PollPub.com Free Polls

SEFIP now uses Firebird

SEFIP is an application used by almost 1.5 millions of companies in Brazil to collect/pay social welfare tributes. It is distributed by Caixa Econômica Federal (a federal bank), and in its latest version (8.3) it replaced InterBase 6.0 with Firebird. With this change, Firebird embedded installed servers base in Brazil grow in some millions.

You can find the announcement here (in portuguese – self extract exe containing a PDF file).

Who is better?

A quite interesting message/answer posted by Ann Harrison in the Firebird-Architect discussion list.

Re: [Firebird-Architect] Firdbird 2.0 vs the World
Posted by: “Ann W. Harrison”
Date: Thu Dec 28, 2006 8:55 am ((PST))

rvbyron wrote:
open source databases, however, the list is not very extensive. Further,most of the comparisons are not referencing Firebird 2.0, but an earlier version of Firebird.

Do you want to speak at fisl 8?

Reaching its 8th edition, the International Free Software Forum stands
as a remarkable spot in the Brazilian and International FOSS event’s
calendar. On this coming edition, we strived to improve the quality of
the event’s program, and to adequate it to the suggestions of the
former years researches. To achieve it, we overhauled the event tracks,
including and merging tracks as needed.
Read more here.

PS: Deadline for papers submissions is 7-Jan-2007.

New version FreeAdhocUDF

Today 2006-12-21 the new version adhoc20061221 is ready for download at ftp://ftp.adhoc-data.de or http://www.ibexpert.com/download
Also there is a new website for all around the FreeAdhocUDF at
http://www.udf.adhoc-data.de.

The new version is the first (and only?) UDF-library which supports all the new features in FireBird 2.0 (f.e. returning of NULL in UDFs). The new version is also the first UDF-library compatible and tested on InterBase2007.
There are now 295 functions in the FreeAdhocUDF. The FreeAdhocUDF returns the same values in Windows and Linux and in InterBase and FireBird so you can Backup/Restore from Windwos to Linux and from InterBase to FireBird.

1 73 74 75 76 77 100