Technical Articles
Firebird Mythbusters
New presentation “Firebird Mythbusters” http://www.slideshare.net/mindthebird/firebird-mythbusters
Use it for competitive talks to crush the most annoying myths around
Firebird.
Gentle reminder – we still need localized versions of MindTheBird
presentation “Firebird Intro” and “Why Firebird”.
Best regards,
MindTheBird Team
Firebird Backend working with #Django 1.2
David Elias wrote on django-firebird-dev group
about his backend changes to make Django 1.2 work with Firebird
Web 2.0 programming with Object Pascal (Part 1)
Leonardo posted in his blog about developing web applications using Delphi/FreePascal. The article uses Firebird 2.1 as data source.
Window functions (part3) – new functions
Adriano posted in his blog about new Window functions introduced in Firebird 3.
[...]Now, new window-only functions has been introduced. I’ll separate them in two groups: ranking and navigational. Both set of functions can be used with/without partition/ordering, but them does not make much sense without ordering.[...]
Read the full post here.
Firebird 2.5 – german article
Thomas Steinmaurer made available for public download the PDF of his article about Firebird 2.5, published previously in the Entwickler Magazin.
Window Functions (part2) – cumulative aggregates
adrianosf twiteed
New blog post – Window Functions (part2) – cumulative aggregates – http://bit.ly/8sgfKU.
And here the Hebrew version of the article
Good news for #Debian #kFreeBSD and #FreeBSD
Damyan submited the patches to make Firebird 2.5 buildable on FreeBSD.
You can watch Debian building logs here
Window Functions in Firebird 3
Adriano has published in his blog some information about the implementation of the OVER function in Firebird 3. Really cool.
By the SQL specification, window functions are a kind of aggregation, but which does not “filter” the result set of a query. The aggregated data is mixed with the query result set. That sort of functions [...]
#JIRA 4.0 and Firebird
Here are the notes on connecting JIRA to Firebird. It supplements the official Firebird installation documentation.
#Euphoria Language Demonstration program for Firebird Server using #ODBC
Inside the zip file you will find a nice pdf about why he uses Firebird and Euphoria Language example. I have uploaded the html version of the pdf here (transformed with pdftohtml)
Demonstration program for Firebird Server ODBC access using odbc.e and wxEuphoria with two-tone flexible datagrid. Uses the EMPLOYEE.FDB example database that comes standard [...]
Choosing a File System on Linux for Firebird
Philippe Makowski wrote a nice article comparing the performance of Firebird database on different linux file systems.
Don’t believe benchmarks made by someone other than yourself !
Read it here.
Firebird event listener custom job entry for Pentaho Data Integration
How to add job-event based plugin to Pentaho Data Integration (PDI), aka Kettle
On forums there is a thread with the questions and answers from Pentaho team
Local protocol and multi-core processors
Dmitry Kuzmenko posted in his blog an “interesting” situation detected with the use o gbak + Firebird 1.5 + Local protocol. Read it here.
Firebird ODBC Acrobat and JavaScript
Question of the day on Firebird odbc driver list
has anyone used JavaScript in PDF-Forms with the ODBC driver?
I can’t retrieve any values from the database.
How to Query the Firebird Fisheye
Now in Firebird Fisheye you can create queries on the source code repository
For example here is how to get the changes with “Misc” comments
select revisions from dir /firebird2/src where (is head and comment matches “Misc”) group by changeset return path, revision, author, date, csid

