Re: how to link Apache and Oracle?

nowayjose_at_telus.net wrote:
> On Fri, 20 Feb 2004 20:15:20 GMT, Hans Forbrich <hforbric_at_yahoo.net>
> wrote:
>
> No worries, Hans, I am not easily offended. You are right, I wasn't
> telling all. Here is the whole deal. I know Oracle database, I have
> been a DBA for over 8 years and I am four times Oracle certified. I
> have a client that is asking me to build an application and it's
> infrastructure. The infrastructure is easy, DB in the backend, all the
> application logic in PL/SQL stored procedures, Apache on the web tier,
> firewall between them. I am also Red Hat Certified Engineer, so all
> the sysadmin and firewall tasks are second nature to me. My only
> problem is that I need to link the web tier to the database. I know
> enough Perl to write DBA and Unix admin scripts but my CGI skills are
> 10 years out of date. I am not afraid to learn Perl methods for
> connecting to Oracle db, but I was wondering if PHP was easier to use
> and learn. The application must be secure, so I need to use SSL and
> somehow preserve session info. Cockies?
>
> The application that I need to write is a very simple OLTP system, all
> I need is to authenticate the users, let them enter the information in
> several forms and log them out.
>
> Hope this time I am clear enough :)
>
> K.

Much clearer. I notice you are also on telus.net (forbrich@ for me) - if near Edmonton we could discuss this over coffee/beer.

Sad that you are stuck in the mid/back-tier split that way, and that you can not get Oracle AS (especially 10g). A lot of your requirements are already completed in the AS, although 9iAS is a pain to install.

CGI is not the way to go. I recommend Perl for several reasons: it's included in the web-stuff that comes along wth Oracle which might make migration easier at a later date; DBI/DBD is included and that pretty well wraps up the connectivity issue; there are a pile of Perl-aware people, but in my experience a lot less PHP aware people.

Personally I'd prefer PSP (PLSQL Server Pages).

JSP (Java Server Pages, not Java Stored Procs) basically embedds Java snippets in an HTML template than uses some J2EE container, such as the OC4J that's part of Oracle, to translate the page into Java servlets on first access.

Ultimately the app you will be writing could probably be handled by Oracle's HTMLDB capability and that is included as part of the database.   Suggest you look at http://marvel.oracle.com when you have a chance.

/Hans
forbrich at telusplanet dot net Received on Fri Feb 20 2004 - 15:05:08 CST