Entries Filed Under: Oracle
11:13pm June 23, 2008
CakePHP gets Oracle bind variable abilities
One of the problems of using CakePHP with an Oracle database is that CakePHP does not utilize bind variables. One of the advantages of Oracle is that it can cache query results based on queries, as long as those queries use bind variables and not strings. An example of a query using binds looks like:
SELECT * FROM my_table WHERE id = :myBind;
$bingArray = array( 'myBind' => 12 );
When I first started working with Oracle, I was not aware of the [Read More]
Views  1085 Comments  1
Filed under: CakePHP, Oracle, Web Development
9:43am April 25, 2008
PHP and Oracle get connection pooling with Database Resident Connection Pooling
One of the major negatives of using Oracle 10g and PHP to build applications is the obvious lack of connection pooling.
Without pooling, frequent connection creation and destruction can be expensive and crippling to high scalability. Oracle's traditional middle-tier connection pools were not applicable to the multi-process PHP architecture. Caching connections within PHP removed connection creation and destruction costs but did not achieve optimal connection resource utilization, incurring unnecessary memory overhead in the database.
[Read More]
Views  727 Comments  0
Filed under: Oracle, PHP, Web Development
3:07pm March 19, 2008
Updated CakePHP Clob Behavior
Updated: I've released a working version of the oracle connection class that does not need behaviors to utilize bind variables.
We ran into some more issues using the CakePHP Clob behavior that Bobby Borisov and Nedko Penev wrote. Basically, the issue was that the original file used a reference variable to the model that was supposed to be using the behavior. However, it seemed to always doing something very by expanding the model array everytime the behavior was called.

[Read More]
Views  726 Comments  1
Filed under: CakePHP, Oracle, Clob, Behavior
10:41am February 06, 2008
CakePHP Clob Behavior
Updated: I've made some changes to the CakePHP Clob Behavior
Bobby Borisov and Nedko Penev over at chankov.net wrote a great CakePHP behavior to help with handling Oracle clob fields in CakePHP 1.2. For those of you unfamiliar with Oracle, it will only let you insert or update a clob field with less than 4000 characters without using a bind variable. If you need to place a value [Read More]
Views  1007 Comments  3
Filed under: CakePHP, Oracle
12:34pm December 04, 2007
Oracle Powered CakePHP
I've started heavily developing some stuff for work using CakePHP 1.2. We decided to go with the beta version as it currently is because of a number of changes. One of the major changes that we needed was better integration with Oracle.

The only issue with getting Oracle and CakePHP working nicely together is that in the default appconfigdatabase.php file, there is a missing value from the $default and $test arrays. var $default = array( 'driver' => 'oracle', 'persistent' => false, 'host' => '', 'port' => '', 'login' => '', 'password' [Read More]
Views  2922 Comments  3
Filed under: CakePHP, Oracle
12:52pm October 15, 2007
PHP gets upgraded OCI8 Driver
Seeing as how I have started working solely with Oracle 10g at work, I have moved away from monitoring changes to the MySQL database and now watch changes coming from the Oracle camp. One of the biggest issues that the developers and my company face is moving all our code from an antiquated scripting language over to PHP. PHP and Oracle has a decent agreement when it comes to handling database transacations, but it's nothing to write home about. The PHP lacks any form of good database connection pooling when it comes to Oracle.

For sites that get a couple dozen thousand hits a day, [Read More]
Views  592 Comments  0
Filed under: Oracle, PHP
Loading...