Firebird SQL Project Newsletter, Issue 2

Yesterday the second issue of Firebird SQL Project newsletter was delivered to all subscribers. This issue includes announcements of official Firebird channels at YouTube and SlideShare, the full list of materials from Firebird Conference 2011, and also digest of recent community news.
You can read the second issue online.

We strongly encourage you to subscribe to Firebird SQL project newsletter in order to receive new issues in time.

Status of PHP PDO_Firebird as of December 2011

If you have read the previous article about Firebird pdo status then you might now that almost all worked  except binding parameters by name (see  bug #48877).

But as a gift bug #48877 is fixed in svn , and is already in the php  snapshots for 5.4.x,5.3.x and trunk 5.5.x

So it should all work from the mentioned article , There are still some bugs left but it will be fixed until the end of the year : Bugs #47415 and #53280 are already done from my todo list


Help testing TcpRemoteBufferSize parameter

The parameter TcpRemoteBufferSize found in firebird.conf is supposed to set the maximum size of a packet being transfered. The default value for Firebird is 8K, and the maximum accepted is 32767. Theoretically, bigger packets should make the transfer of large resultsets faster (mostly noticed when connection is high latency networks, aka internet).

Recently, I did some tests with this parameter, but wasn’t able to find any differences in the time of a fetchall with a select first 2000 * from some_table_with_no_blobs_and_lots_of_records. A similar test that I did last year, with different FB version and O.S. showed a speed increase of almost 3x in the fetchall time when the packet size was set to 32K, but seems that I cannot reproduce this with my current environment anymore.

If you have some time, please do some tests with this parameter, and publish the results in the comments of this post. Remember to test changing the value at client, at server, and at both, and to mention what Firebird version was used (at server, and client library too, if different). Also, I recommend to run the first select/fetchall at last one time before getting the results, to fill Firebird and O.S. cache and get more accurate results.

If you are a “hardcore” user, you may also want to install Wireshark and have an inside view of the communication process.

PowerConsole 0.9.2 realeased and tested with new FDB python driver

Pavel Cisar   wrote on google plus about the new PowerConsole:
It was tested with new FDB driver (see http://ibphoenix.cz/pwc/ for details),
i.e. I’ve just imported fdb
as kdb and skipped the kinterbasdb initialization. Surprise, surprise,
it works! All issues I was able to find so far were few small bugs in
pwcfb module itself 🙂

So, I released an update to pwcfb that should fix all issues and sets the dependency to FDB.

To install it simply use `easy_install pwcfb` and it should bootstrap it with all necessary dependencies.

Extensive package that enables PowerConsole to work with Firebird databases.

Initial release (0.7.0) of new Python driver for Firebird – FDB is ready for testing

As promised, FDB initial release (0.7.0) is out: http://pypi.python.org/pypi/fdb/0.7.0

It’s almost feature-complete (ready for 95% of users), but it could be
still buggy (it’s beta!), and the code wasn’t optimized for size and
speed. In all other ways it’s ready for wide testing.

What’s missing:

– Distributed transactions
– ARRAY support
– EVENTs support
– Stream BLOBs
– TRACE service
– Documentation (but you can use KInterbasDB one as FDB is as close to
it as possible).
– Python 3.x support (haven’t had time to test it, but it shouldn’t be
hard to make it work there)

What’s new since my last post here:

– Support for stored procedures (proper one according to Python DB API,
behaviour is the same as in KInterbasDB)
– Prepared Statements. It works in exactly the same way as in
KInterbasDB, i.e. you can use explicit PS via cursor.prep(), or use the
internal PS cached for all statements executed via cursor.execute() – it
will detect previously executed command and re-use prepared statement
(cached per cursor instance!).
– Fully implemented cursor.description attribute, i.e. including
precision for DECIMAL/NUMERIC fields. Should now return the same results
as KInterbasDB.
– trans_info/transaction_info and db_info/database_info calls like in
KInterbasDB.
– Better object dependency and lifetime management, so Python memory GC
should be much happier now. I modelled it as much as KDB does it as
possible.

Source code is also in Firebird Project’s Subversion repository:

(KInterbasDB source moved)

Sorry for GIT/Mercurial etc. fans, but Firebird project uses only SVN
for all its code (except old obsolete ones that are still in CVS) and it
would be pointless to create another type of repository for such a small
project. However, you’re free to set up mirrors or local repositories on
GIT or whatever 🙂

Merry Christmas to all
Pavel Cisar
IBPhoenix

[ED: if you want to know how easy is to use , or how compatible it is related to kinterbasdb , read this post ]

Gifts for new members of Firebird Foundation

икони цениSpecial gifts for the new members of Firebird Foundation till December 31, 2011:

– 3 *FREE* FB TraceManager Enterprise licenses (incl. 1 year subscription) for the next 3 members who either renew a VOTING membership or join as a VOTING member

– 3 *FREE* FB TraceManager Standard licenses (incl. 1 year subscription) for the next 3 members who either renew an ASSOCIATE membership or join as an ASSOCIATE member

– 3 *FREE* FBDataGuard licenses for the next 3 members who either renew a VOTING membership or join as a VOTING member

– 3 *FREE* FBScanner licenses for the next 3 members who either renew a VOTING membership or join as a VOTING member

(by “Renew membership” we mean memberships which were excluded from the list there http://www.firebirdsql.org/en/members/)

Hurry up, only 9 gifts for new VOTING members and 3 for new ASSOCIATE members of Firebird Foundation!
Join Firebird Foundation Now!

Using the Firebird 3.0 API with Delphi

Pierre Yager announced on firebird-devel new version of UIB with Firebird 3.0 API support:

Thanks to Vlad, we achieved the translation of the FB3 OO API in UIB
Components for Delphi.

You can checkout the code from SourceForge repository :

https://uib.svn.sourceforge.net/svnroot/uib/trunk

Now, we only miss hints to deal with FbMessage, it seems that the
examples (fbstuff on github) made by Adriano heavily relies on BOOST
and as we don’t have such possibilities with Delphi we must understand
what is exactly an FbMessage and see what we can do.

Thanks for your help, regards,

1 117 118 119 120 121 200