Firebird official newsletter

The first issue of the Firebird Project official newsletter is being sent right now! All the people that have subscribed to it should be receiving it in their email box in a few minutes. If you did not subscribe yet, just to go the project site main page and fill your email in the subscription widget at the left sidebar .

A web version of the report also can be viewed online, but I strongly suggest you to subscribe to the newsletter.

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 126 127 128 129 130 207