Author: mariuz

FYI: The status of the firebird2.5 source package in Debian’s testing distribution has changed.

Previous version: 2.5.1.26349-0~rc1.ds4-5 Current version: 2.5.1.26351.ds4-2

Hello,

Upscene Productions is proud to announce a new major V2 release of FB
TraceManager.

More information on the new release is available here:
http://www.upscene.com/displaynews.php?item=20111101

FB TraceManager is currently the only specialized tool available on the
market, which exposes the new Trace and Audit Services in Firebird 2.5
in a very user-friendly way. The following editions are available:

– Lite Edition (FREELY available)
– Standard Edition
– Enterprise Edition

More information is available in the FB TraceManager section on
our website, including an edition comparison sheet, webcasts etc.:
http://www.upscene.com/go/?go=fbtm

And new, a full product documentation is also available online now:
http://www.upscene.com/documentation/fbtm2/index.html

—
With regards,
Thomas Steinmaurer

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