Firebird Articles/Documentation Contest

New MindTheBird contest: FB 2.5 features documentation contest

Write articles/documentation about any of the new Firebird 2.5 features and you can win a prize of USD 500 (1st place) or USD 200 (honourable mention prizes).

Rules:

  • Article format should be Word (doc/docx), Open Office or RTF.
  • It must contain minimum of 2.000 words.
  • It must be clear and easy to understand, and if possible, contain practical examples of code using the feature subject of the article.
  • It must be written in English (not generated by automated translation, please).
  • All the submitted articles needs to be licensed under the Creative Commons Attribution License (cc by).
  • All articles will be published at MindTheBird site and at Scribd.com.

Deadline for articles is April 16, 2010. Contest will be judged by Firebird Core developers: Dmitry Yemanov, Vlad Khorsun and Alex Peshkoff.

The authors of the best articles will get money as a prize (needs to have account in PayPal to receive the money).

Materials should be sent to admin@mindthebird.com

Window functions (part3) – new functions

Adriano posted in his blog about new Window functions introduced in Firebird 3.

[…]Now, new window-only functions has been introduced. I’ll separate them in two groups: ranking and navigational. Both set of functions can be used with/without partition/ordering, but them does not make much sense without ordering.[…]

Read the full post here.

Window Functions in Firebird 3

Adriano has published in his blog some information about the implementation of the OVER function in Firebird 3. Really cool.

By the SQL specification, window functions are a kind of aggregation, but which does not “filter” the result set of a query. The aggregated data is mixed with the query result set. That sort of functions are used with the OVER clause. Users of Oracle also knows window functions as analytical functions[…]

1 30 31 32 33 34 78