By default, the transactions are IBASE_WAIT, so it waits until the record is no longer edited. You have to start a transaction with the IBASE_NOWAIT option to get an immediate response in a deadlock situation.
One example is a php application waiting for desktop app (administration tool) to finish the transaction
When I try to update a record that’s edited in a desktop app or IBexpert, and there is a deadlock, ibase_execute just hangs, does not return any value nor raises an exception.
Carlos wrote on firebird-php group : I’ve developed a stable version of a Firebird driver for the PHP Codeigniter Framework . Good feedback has been received from the Codeigniter community so far, and hope this could be useful for more developers working with PHP and Firebird.The sources are available at bitbucket here and any issues can be reported here
or at my blog here and for the English readers …
Thanx, live long and prosper…
Carlos García Trujillo
ps: seems that the driver is quite popular in such a small timeframe
I am happy that my driver for # firebird # codeigniter already are used by people from around the world in so little time:)
Here is the announcement on Codeigniter Forums
I have developed a FirebirdDB driver for Codeigniter 2.0
you can get it at BitBucket here
Code Igniter seems to be a cool PHP framework
CodeIgniter is most often noted for its speed when compared to other PHP frameworks. In a critical take on PHP frameworks in general, PHP creator Rasmus Lerdorf spoke at frOSCon in August 2008, noting that he liked CodeIgniter “because it is faster, lighter and the least like a framework”.
I have wrote the steps in compiling php_interbase.dll with using the Firebird 2.5 binaries here but if you want to debug the Firebird client dll or the engine you should follow these steps (requires full Firebird 2.5.x compilation)
If you want to build only Firebird 2.5 with a free beer compiler i have created a video where i describe and show the steps that you need to follow
Team Jaws announces the release of Jaws 0.8.13
Note: This release fixes some security issues, all users are encouraged to
ps: it does have support for firebird by default
SQL Maestro Group is happy to announce the release of Firebird PHP Generator 10.3, a frontend to generate high-quality Firebird PHP scripts for the selected tables, views and queries for the further working with these objects through the web. The software comes in both Freeware and Professional editions.
New release introduces autocomplete and WYSIWYG editors, nested master-detail presentations, support for right-to-left languages, project-level events and a lot of other new features. There are also versions for other DBMS (MySQL, PostgreSQL, SQLite, Oracle, etc).
Read full press-release.
We are very pleased to announce the availability of the phpBB “Fast and Furrious” 3.0.6 package. This release fixes numerous bugs, introduces some major features, as well as improves stability and performance.
Firebird related changes:
Changed minimum requirement for Firebird DBMS from 2.0+ to 2.1+.
ps: i like the new ACM (Cache) plugins for APC , XCache
The cache system provides an API for caching frequently used data, it provides an interface for user code to cache data and an interface for the DBAL to cache query results.
The CakePHP development team is happy to release the alpha build of
In an effort to increase product stability we are happy to announce the availability of the fourth release candidate for the next release – phpBB 3.0.6.
This fourth release candidate contains mostly regression fixes. Everyone able to should test this release and report critical bugs (those, stopping the operation of the forum) and issues to the bug tracker or directly to the developers.
Short notes on how to compile Firebird extension (called interbase) on Windows 32 bit (the same ideas can be used for 64 bit too)
I have used Visual Studio c++ compiler 2008 (aka Vsc 9)
By default php developers on windows don’t have the firebird extension enabled in php 5.3.0 and the required dll (fbclient)
we try to fix that the vodoo spell is to
kill one compile firebird stable with vsc9 and send them the instructions how to do the kill compiling but we have the recipe for that too and maybe we can kill compete with microsoft sql server on windows too if they let us