 | News Feed |
Sections
Community Events
|
| feed this: |  |
Harun Yayli's Blog: oci_bind_by_name maxlength is not so optional
posted Friday May 09, 2008 @ 13:45:44
voice your opinion now!
BY CHRIS CORNUTT
Harun Yayli came across a slight problem in his development using the oci_bind_by_name function for one of his queries:
If you think that the maxlength parameter in the documentation of oci_bind_by_name is optional, see this example and think again.
His sample code gave him a "can bind a LONG value only for insert into a LONG column..." error from his Oracle database. His fix was to add that length parameter (his max column length) and all was well. One of his comments (from cj) helps to explain things a bit more:
It makes senses that a length would be required because when the oci_bind_by_name() call is made, there is no data in $$key (a.k.a. $a, $b or $c). Without a length passed, PHP tells the DB to expect a single byte string.
tagged with: ocibindbyname maxlength optional error oracle
Maggie Nelson's Blog: NTILE() - easy way to generate tag clouds
posted Tuesday April 29, 2008 @ 13:44:01
voice your opinion now!
BY CHRIS CORNUTT
For the Oracle users out there looking for an easy way to pull those tags together and make a handy little cloud out of them, Maggie Nelson has posted about a simple Oracle function that can help - NTILE.
For example, check out the documentation for the NTILE Function. Yeah, sounds kind of boring. What good could it be in the wonderful world of web development? After all, who manages employee or sales tables anymore... Answer: generating tag clouds.
Her SQL statement categorizes the tags for you automatically, dropping them in to "buckets" of font sizes. This makes it simple to loop through them (like with a foreach) and output your tags with a little help from some CSS. You can even specify how many buckets you want it to fill (how many different tag values to get and compare).
tagged with: ntile tag cloud tutorial oracle sql order bucket
Christopher Jones' Blog: PHP Connection Pooling Whitepaper with Benchmark Available
posted Friday April 25, 2008 @ 10:23:47
voice your opinion now!
BY CHRIS CORNUTT
Christopher Jones has pointed out a new whitepaper that's been published by oracle about the scalability the connection pooling affords for current versions of PHP.
The whitepaper talks about the changes in the PHP OCI8 1.3 extension, explains some of the concepts behind DRCP and FAN, and gives best practices and tuning tips. It includes a new PHP benchmark which shows up to 20,000 connections being handled by Oracle on commodity hardware using only 2G RAM.
The paper also talks about the FAN support that's built in - the ability for PHP to use the Oracle RAC cluster functionality to make for high availability (switching between nodes). The latest beta with all of this functionality in it can be grabbed from its page on the PECL site.
tagged with: connection pooling whitepaper benchmark rac cluster oracle
Matthew Turland's Blog: PHP, MySQL, and Oracle An Odd Triangle
posted Thursday April 10, 2008 @ 13:04:30
voice your opinion now!
BY CHRIS CORNUTT
A little while back Matthew Turland posted an interesting item to has blog talking about what he calls the "odd triangle" of PHP, MySQL and Oracle.
In [an article from Maggie Nelson in a blog entry], she remarks on the article being MySQL-oriented and how limited MySQL explain plan support is compared to Oracle. I've had some thoughts in my head for a while that are related to these points, so I finally decided to, knock on wood, put pen to paper.
Matthew talks about things he agrees with (Oracle over MySQL when it comes to hierarchal data and set operators) and some of the things that can make Oracle, with all its power, fall by the wayside. This includes its licensing, the administration costs and some of the recent developments between Sun and MySQL.
tagged with: mysql oracle database compare powerful license administration
|