Month: October 2011

Alex Peshkoff Just fixed CORE-3646:

Segmentation fault for a FreePascal program,
that connects to a FB 2.5 database inside a thread.
The segmentation fault just occurs, when there is a
Firebird exception caught inside the thread.

Milan Babuskov wrote on flamerobin-devel:

In the past week or so I have improved our statement history dialog to
allow easier browsing. Now it shows the statements on the left and
when you click them, you get the whole sql on the right. This makes it
easier to inspect the statements and find what you looking for.
Especially if you have a large monitor. Also, the searched term is
marked with red color.

I also added the timestamp of the history file. Functionality is now
good, however, now I’m not sure about this layout. What do you think?

(screenshot attached)

Hajime Nakagami announced on firebird-python list that new pyfirebirdsql release is out :

Hi all

I have released 0.6.0 now.
http://pypi.python.org/pypi/firebirdsql/0.6.0

I’t still alpha status. services and transaction management is incomplete.
0.6.0 is different from 0.5.0 heavily, so I decide to release current snapshot.
I think this release work about services and transaction management
but partially

I hope make patchs from this release, please.

From twitter

I remember when I added the LOWER function to Firebird. I needed to grep (for nod_upper) and change dozens of files…
Now to add even a window function (which the framework is prepared to) it takes just a few localized changes http://bit.ly/uAt3ZP…
Now adding LAST_VALUE and NTH_VALUE.

You can read more about the list of window functions that are already implemented or needs to be implemented on the tracker

A short description of what these functions do :

first_value(value any) return value evaluated at the row that is the first row of the window frame
last_value(value any) returns value evaluated at the row that is the last row of the window frame
nth_value(value any, nth integer) returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row
for ref : http://www.postgresql.org/docs/9.1/static/functions-window.html#FUNCTIONS-WINDOW-TABLE

I see a new Improvement on the feature requests list , any comments ?

http://tracker.firebirdsql.org/browse/CORE-3642

The List of talks for Firebird Conference 2011 is now online

http://firebirdsql.org/en/firebird-conference-2011/