Christopher Cashell (topher) wrote,
Christopher Cashell
topher

  • Location:
  • Mood:

Oracle + PostgreSQL + PHP == huge pain

This just boggles the mind. This should absolutely not be this difficult, complicated, or frustrating.

At work, I need a web server (RHEL4) with PHP installed, along with the support libraries for PostgreSQL and Oracle. With the stock RPMs for PHP, adding PostgreSQL support is a piece of cake, you just install the PostgresSQL client libraries and php-pgsql.

So then I go to add Oracle support. I download the Oracle instantclient libraries (we're not running a database on this box, just connecting to an existing one), and figure there's probably a php-oracle or php-oci8 RPM from Oracle to add the PHP glue, right? Wrong. All of the documentation from Oracle describes how to take your RHEL4 box, download Apache, from source, download PHP, from source, and then recompile both.

What the hell? I'm going to have to duplicate this on a dozen machines, and then maintain them. In this day and age of software management, why in the hell am I supposed to recompile major parts of the system from source? And for one little oci8.so? Is this a joke?

So then I find Zend Core, which advertises it's "Universal Database Support", and built-in Oracle module. Wow! Cool! That'll solve this. . . assuming I don't mind using an alternately supplied install of PHP that will no longer be supported with security fixes from my OS vendor, nor do I have any kind of upgrade roadmap for it. But at least I have Oracle and Postgres support, right? Well, erm, no. Actually, the "Universal Database Support" just means that it supports the big guys with money, like Oracle, IBM DB2, and SQL Server. Oh, and MySQL. Wait, what's the obvious exclusion? Where's PostgreSQL? And Zend Core is a binary install, so I can't recompile it to add PostgreSQL support, even if I wanted to?

I went through some crap like this back when I was trying to get Oracle support compiled for Perl a year or two ago, though I'd forgotten how annoying it is. It honestly makes me wonder how in the hell Oracle ever managed to convince anyone to develop against them. This is just asinine.

At this point, I'm really annoyed at Oracle for not offering a php-oci8 RPM from their freakin' "PHP for Oracle" portal page, and at Zend for making it really hard to add any additional extensions that they don't feel you need.
Tags: oracle, php, work
Subscribe

  • Google Buzz.

    This is a (probably temporary) post to attempt to integrate my LiveJournal into Google Buzz.

  • The BEST player in College Football in 2009: Ndamukong Suh

    A lot of people have trouble understanding how good Ndamukong Suh, the Defensive Tackle for the Nebraska Cornhuskers really is. There aren't many…

  • Customer Service done wrong.

    So, after having finally purchased a house, I went to get cable and Internet setup. Like most of the country, I live in an unfortunate area where…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 6 comments