Improved Firebird Adapter

robregonm · February 22, 2012, 2:43pm

If some of you experience speed issues, please let me know.

robregonm · February 28, 2012, 5:49pm

New version available

This new version is compatible with Yii 1.1.9 and above.

It is recommended you use the latest version of pdo-firebird (at least version 5.3.10)

2602

firebird_adapter_0.8.tar.gz

hellboy · March 7, 2012, 12:51pm

Why do you use PDO? It’ still in alpha state.

Zend Framework also use php_interbase driver only

birger · June 6, 2012, 7:46am

I’m using the Firebird adapter for my first Yii problem and it seems to work ok.

However, I encounter a problem with decimal fields. They are readed from the database just fine. But when I update a record with a decimal the value is devided by 10000. So 5 becomes 0.0005 when posted to the database. When I edit the record again the value is devided by 10000 again which turns it into 0.

Any idea what I am doing wrong?

birger · June 6, 2012, 8:06am

I changed the fields to FLOAT in the database and that seems to work.

robregonm · June 6, 2012, 5:34pm

@birger

I’ll take a look at it.

If you find any bug, please report it at the github repository: https://github.com/robregonm/YiiFirebird

Best regards.

birger · June 11, 2012, 7:40am

Thanks for looking at it. If I find anything else I will post it on github.

robregonm · January 18, 2013, 9:00pm

This extension can be downloaded from the Extensions page.

robregonm · January 22, 2013, 4:17pm

Version 1.0RC released.

Feel free to download and report bugs.

robregonm · January 29, 2013, 6:27pm

Version 1.0RC2 released.

Lots of bug fixes and enhancements implemented.

robregonm · January 29, 2013, 6:29pm

Good news:This extension will be pushed to Yii core as soon as the final version 1.0 of the extension is released.

Jay_69 · February 3, 2013, 5:44pm

Hi robregonm

Version 1.0RC2 downloaded. Installed as in readme.

Getting error ‘could not find driver’

Have I missed something?

Thank you.

robregonm · February 12, 2013, 4:42pm

Hi Jay_69,

Are you using PHP 5.3.10+, and Yii 1.1.13?

There are some known issues mainly when PHP version is not 5.3.10 or above.

And, last Yii version fixes some bugs when loading 3rd party Db extensions (like Yii.Firebird)

Please, let me know, if you get some progress on this.

Regards.

Jay_69 · February 17, 2013, 4:10pm

Hi robregonm,

Sorry could not test on other versions.

Our project uses Firebird as local db and syncs with MySql site db, so we decided not to use direct connect to Firebird db from the site.

Set up http server and used cross domain requests instead.

But anyway I will keep your extension on a list.

Cheers

robregonm · February 19, 2013, 9:23pm

Release Candidate 4 is available to download.

This new version includes several bug fixes and enhancements.

Feel free to download and report issues.

And remember, as soon as this extension is stable, then a pull request will be done to Yii repo.

ibmed · May 21, 2013, 12:33pm

Just in case anybody else had the same problem…

The Yii Firebird adapter worked fine with Apache, but it just silently crashed under the FreeBSD+Nginx+PHP-FPM installation.

So if you’re on a FreeBSD system and using PDO_Firebird along with PHP-FPM, make sure you have the LINKTHR option enabled for your PHP5 (lang/php5):


LINKTHR=on: Link thread lib (for threaded extensions)

Hope it will help

robregonm · June 19, 2013, 10:01pm

@ibmed

Thanks for you comment. I think I’ll add it to the documentation as a “known issue”.

dubzilla · August 31, 2013, 9:33pm

Hi robregonm,

Im’ trying to use firebird extension with gii, but there is a message when I click on “Crud Generator”

SOLVE: folder name in protected\extensions must be YiiFirebird

Vingadero · November 26, 2013, 5:53pm

Hello

Great extension, thats exactly what I was looking for.

All is working fine, I can run queries, commands… but (always the but…)

When I try to make a model via gii it’s says: “Table does not exist.”

Any hint?

Regards,

Vingadero · November 26, 2013, 6:24pm

I found something… I’m using Firebird 1.5 (for compatibility issues).

And the following query not runs on FB1.5


(SELECT 1 FROM RDB$TRIGGERS

                        WHERE RDB$SYSTEM_FLAG = 0

                        AND RDB$RELATION_NAME=upper(\'' . $table->name . '\')

                        AND RDB$TRIGGER_TYPE = 1

                        AND RDB$TRIGGER_INACTIVE = 0

                        AND (UPPER(REPLACE(RDB$TRIGGER_SOURCE,\' \',\'\')) LIKE \'%NEW.\'||TRIM(rel.rdb$field_name)||\'=GEN_ID%\'

                            OR UPPER(REPLACE(RDB$TRIGGER_SOURCE,\' \',\'\')) LIKE \'%NEW.\'||TRIM(rel.rdb$field_name)||\'=NEXTVALUEFOR%\'))

                    AS fautoinc

Just fixed to always pass


0 as fautoinc

, and will change manually on model when needed.

Now is all good.

Thx!