Yii Framework Forum: Improved Firebird Adapter - Yii Framework Forum

Jump to content

  • (2 Pages)
  • +
  • 1
  • 2
  • You cannot start a new topic
  • You cannot reply to this topic

Improved Firebird Adapter Rate Topic: ***** 1 Votes

#1 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 20 February 2012 - 09:45 PM

Hi gys,
I've updated the Firebird adapter created by idle_sign and then modified by zoggo.
Fixed some errors related to the code generators and autoinc fields (yes, now the adapter detects when a generator is present).
Also the adapter adds some missing variables and makes it compatible with Yii 1.1.10 (and above).
Attached File  firebird_adapter_0.7.tar.gz (6.62K)
Number of downloads: 60

Attached File  firebird_adapter_0.8.tar.gz (5.46K)
Number of downloads: 101

GitHub repository is also available: https://github.com/r...onm/YiiFirebird

If you find bugs, please let me know, in order to fix them and possibly add this files to the Yii core (would be great).

Regards.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#2 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 20 February 2012 - 09:48 PM

This version is very stable. I'm using it for a personal project, nevertheless we need more testing.

Best regards.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#3 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 22 February 2012 - 09:43 AM

If some of you experience speed issues, please let me know.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#4 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 28 February 2012 - 12:49 PM

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)
Attached File  firebird_adapter_0.8.tar.gz (5.46K)
Number of downloads: 101

Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#5 User is offline   hellboy 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 9
  • Joined: 12-July 11

Posted 07 March 2012 - 07:51 AM

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

Quote

Until then, the PHP5 php_interbase driver is the only valid option for PHP and Firebird.


Zend Framework also use php_interbase driver only

Quote

1.8 - 30 January 2008: PDO support development started...and canceled (PHP PDO Firebird extension is in experimental status)

0

#6 User is offline   birger 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 3
  • Joined: 25-May 12

Posted 06 June 2012 - 02:46 AM

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?
0

#7 User is offline   birger 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 3
  • Joined: 25-May 12

Posted 06 June 2012 - 03:06 AM

View Postbirger, on 06 June 2012 - 02:46 AM, said:

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.


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

#8 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 06 June 2012 - 12:34 PM

@birger
I'll take a look at it.

If you find any bug, please report it at the github repository: https://github.com/r...onm/YiiFirebird
Best regards.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#9 User is offline   birger 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 3
  • Joined: 25-May 12

Posted 11 June 2012 - 02:40 AM

View Postrobregonm, on 06 June 2012 - 12:34 PM, said:

If you find any bug, please report it at the github repository


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

#10 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 18 January 2013 - 04:00 PM

This extension can be downloaded from the Extensions page.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#11 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 22 January 2013 - 11:17 AM

Version 1.0RC released.
Feel free to download and report bugs.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#12 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 29 January 2013 - 01:27 PM

Version 1.0RC2 released.
Lots of bug fixes and enhancements implemented.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#13 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 29 January 2013 - 01:29 PM

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

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#14 User is offline   Jay_69 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 50
  • Joined: 27-August 10

Posted 03 February 2013 - 12:44 PM

Hi robregonm

Version 1.0RC2 downloaded. Installed as in readme.

Getting error 'could not find driver'
Have I missed something?

Thank you.
0

#15 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 12 February 2013 - 11:42 AM

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.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#16 User is offline   Jay_69 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 50
  • Joined: 27-August 10

Posted 17 February 2013 - 11:10 AM

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
0

#17 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 19 February 2013 - 04:23 PM

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.
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
1

#18 User is offline   ibmed 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 1
  • Joined: 17-May 11

Posted 21 May 2013 - 07:33 AM

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

#19 User is offline   robregonm 

  • Expert Yii Developer
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 594
  • Joined: 30-July 09
  • Location:Colombia

Posted 19 June 2013 - 05:01 PM

@ibmed
Thanks for you comment. I think I'll add it to the documentation as a "known issue".
Ricardo Obregón

YiiFramework en Español - http://yiiframework.co/ - http://yiiframeworkenespanol.org/ - Yii Code Generator for Bootstrap
http://obregon.co/ - https://1server.co/
PHP 5.5+, nginx 1.7, MySQL(MariaDB & PerconaDB), PostgreSQL 9, Yii 2, CanJS
Follow me: @robregonm & @obregonco & @1ServerCo.
0

#20 User is offline   DubZilla 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 1
  • Joined: 31-August 13

Posted 31 August 2013 - 04:33 PM

Hi robregonm,
Im' trying to use firebird extension with gii, but there is a message when I click on "Crud Generator"

Quote

Alias "ext.YiiFirebird.CFirebirdConnection" is invalid. Make sure it points to an existing PHP file and the file is readable.


SOLVE: folder name in protected\extensions must be YiiFirebird
0

Share this topic:


  • (2 Pages)
  • +
  • 1
  • 2
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users