i have a account in issue-tracker, the username is 'flyingfb', the email address is not exist. who can tell me how can i get the password

Posted by: china_lmf <at> yahoo.com


Firebird Language Reference - Firebird needs your help

Hi All,

The Firebird Project is pleased to announce that the Firebird 2.5 
Language Reference is now available in Russian. It can be downloaded via 
the Firebird SQL documentation page 

Why is it only available in Russian? Moscow Exchange (www.moex.com), one 
of the biggest Firebird users in the world, and IBSurgeon 
(www.ib-aid.com) sponsored the documentation development in their native 
language as well as using the Russian speaking Firebird core developers 
to oversee the work and ensure its quality.

The next step is to extend this documentation to cover Firebird 3.0's 
new features, on which work is already taking place. However this work 
is also in Russian.

In order to translate the Firebird Language Reference into English, the 
Firebird Documentation Project needs additional funds.

It needs approximately $7000 US Dollars to translate almost 500 pages of 
Firebird documentation into English using a professional translation 
service, to ensure the quality of translation.

To get the Firebird 2.5 and 3.0 Language Reference in English in the 
first quarter of 2015, please help the Firebird Project now with a 
donation via PayPal (please use button Fund Docs):

All money donated will be used translate the Firebird documentation and, 
if the $7000.00 amount is exceeded, the money will then be used for 
further development of other sections of the documentation e.g. the 
"Firebird Operations Guide" etc.

Alexey Kovyazin

Posted by: Alexey Kovyazin <ak <at> ib-aid.com>


My apologies

   On the conference Pavel Zotov named me as an author of conflict-less scheme of stored 
aggregates. I didn't interrupt him and now I'm sorry because I, actually, picked up this 
schema in firebird-support list years ago. IIRC, it was Ann Harrison, who came up with it.
   I don't want to be blamed for plagiarism.


   WBR, SD.




ANN: Video on best practices using the Trace API and FB TraceManager in high load scenarios


the video is available here (~ 24min):

In this video I discuss different aspects on how to use the Firebird 
Trace API and FB TaceManager in high load (production) scenarios.


With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

Posted by: Thomas Steinmaurer <ts <at> iblogmanager.com>


SSL 3 is dead, killed by the POODLE attack

After more than a week of persistent rumours, On (Oct 14) we finally learned about the new SSL 3 vulnerability everyone was afraid of.

Security Labs: SSL 3 is dead, killed by the POO... | Qualys Community

Posted by: mapopa <at> gmail.com


Node Firebird Pure Java Script driver 0.2.0 is released with many features and fixes

New version v0.2.0 supports

  • added auto-reconnect
  • added sequentially selects
  • events (attach, detach, row, result, transaction, commit, rollback, error, etc.)
  • performance improvements
  • supports inserting/updating buffers and streams
  • reading blobs (sequentially)
  • pooling
  • database.detach() waits for last command
  • better unit-test
  • best of use with http://ww w.totaljs.com/


Posted by: mapopa <at> gmail.com


Nice interview with the author of Sqitch

As you might now Ștefan Suciu created a Firebird port for sqitch https://github.com/theory/sqitch/blob/master/lib/sqitchtutorial-firebird.pod

Bellow is a interview with the author of Sqitch 


Posted by: mapopa <at> gmail.com

Community email addresses:
  Post message: Firebird-general <at> yahoogroups.com
  Subscribe:    Firebird-general-subscribe <at> yahoogroups.com
  Unsubscribe:  Firebird-general-unsubscribe <at> yahoogroups.com
  List owner:   Firebird-general-owner <at> yahoogroups.com

Shortcut URL to this page:


Zend server/php caching results

Hi All,

Zend  did a sales pitch to us this morning and we weren't the most impressed. Everyone we talk to who delivers solutions PHP+Mysql web applications seem to be obsessed with full page caches, op-code caching, and results caching. But they don't seem to mean the same thing as us when they say "application". Our history was migrating delphi apps to PHP around 2001 and we treat our app like an app that just happens to be using HTML+browser to render the UI. Firebird rocks for this and always has - the databases sit in OS disc cache for all practical purposes, queries are fast, and application logic is light.

Whilst I can see the benefit of full page caching to something like a shopping cart application, I simply can't imagine a single page in our app that a user would be happy to visit one second, and then the next we could be sure it hadn't changed - especially since they usually visit information repeatedly exactly when they are changing it, and old data that has become static through age is rarely accessed - so I've dismissed whole page caching. 

However, on every single page access there's a number of system options tables and caption tables that we hit that rarely change, and even if they do it's sort of OK if it takes seconds to propagate out the data to users, so I can see the potential for caching specific results. Most of our pages take about a second to load, and of that most of it is accessing data, and the "static" tables account for about 10ms. My gut feeling is that we simply shouldn't worry about caching results, but my colleagues aren't as convinced. Modern processors eat the load we throw at them, and 1s to a user is the same as 0.5s or 1.5s. Any longer begins to be noticeable, but doing magic to save 20ms seems like over optimisation.

I'm beginning to doubt myself, so here's the questions.

1. Are we the only people who think of PHP+Firebird as producing apps just like good old Delphi+Interbase?

2. Do people [on any stack] bother to cache query results as a matter of course?

3. If we've got servers with 30GB+ of database that are all OS-read-cached and PHP/Apache is happily sitting in < 1GB of memory, should we even be worried about op-code caching? Why is the PHP world obsessed with caching and load balancing?

4. I've been "happy" with php for 14 years, have I been mad and should we have been using Zend Server all along? [I respect your opinions more than any other forum even though it's nothing to do with firebird!]

Ta you lovely bunch,


Posted by: wobbleian <at> yahoo.co.uk


ODBC documentation

   Hello, All.

   I wonder why ODBC documentation exists in CVS sources, but not in "Documentation" part 
of web-site?..


   WBR, SD.




NETProvider on github

Github model for contributions really works 

There are quite a few pull requests closed and merged for .NET Provider 


ps: posted on support by mistake 

Posted by: mapopa <at> gmail.com


Unhandled exception at 0x77EBB852

Dear All,
              Faction the exception like this,
Unhandled exception at 0x77EBB852 (ntdll.dll) in fsql.exe: 0xC0000005: Access violation writing location 0x00090F80

when i rung the application from vs2013 then this exception in not raised, other wise when i rung dirctly from bin then it show me the above highlighted exception.

Can anybody help me.


M Waqas Shahid

Posted by: mwaqas_shahid <at> yahoo.com