ANN: FB TraceManager V2.0.0 released

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

Statement history dialog layout in Flamerobin

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)

#python firebird driver pyfirebirdsql 0.6.0 is released

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.

Adriano Fernandes added new Window functions from the SQL:2008 standard

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

1 120 121 122 123 124 200