The Perfect Database Server : Firebird 2.5 and FreeBSD 8.1

Here is the guide on installing Firebird 2.5 from FreeBSD 8.1 Ports and creating your first test database also we show you howto install Flamerobin GUI (administation tool) and the PHP driver for it .
This was tested on fresh freebsd 8.1 on a virtual machine

Default transaction in a #php application

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.

Announcement :stable version of Firebird driver for the PHP Codeigniter Framework

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:)

FirebirdDB driver for Codeigniter 2.0 is released Finally!

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”.

Firebird 2.5 compliation with Visual Studio C++ 2008 ( aka #VC9.0 ) on #Windows

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

Firebird PHP Generator 10.3 released

Firebird PHP Generator 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.

#phpBB 3.0.6 released with small firebird changes

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.

1 2 3 4 5 8