Category: General news

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/

Firebird 2.5.1 Final packages are available in Debian Sid repository

The various command line manuals – gfix, gstat, gsec, gbak and fbmgr – have been updated to Firebird 2.5 specification. In the case of fbmgr it was only a few spelling mistakes that were corrected.
I’ve uploaded the html and pdf versions to the online repository. One thing I noticed when testing, the PDFs are ok but the HTML files seem to need a refresh on every page. Has anyone else noticed this when a new HTMl documents is uploaded?
Try hitting this link and see if you get the 11 October 2011 version:
If you don’t see 11 October 2011, click refresh. Now click on the link to go to Command Line Options. Under the password option do you see a fetch_password option? If not, click refresh.

I found this morning that I had to manually refresh every page in each of the updated manuals – which I’ve never had to do before.

Cheers,
—
Norman Dunbar