HP3000-L Archives

March 2001, Week 5

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Peter Osborne <[log in to unmask]>
Reply To:
Date:
Thu, 29 Mar 2001 12:08:53 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (26 lines)
Hello All,

Now that Mark has ported PostgreSQL, I thought I'd try to add PostgreSQL
support to his PHP 3.0.14 port of a year ago. It was a success, with little
effort and slight tweaking to the Makefile, PHP3 compiled without a hitch on
MPE with PostgreSQL support. I compiled it as a DSO so that it plugs into
WebWise for https or any other version of Apache that supports DSO's.

Once that was complete, I skimmed throught the basic steps in the PostgreSQL
documentation to create a database and then used some examples from php.net
to write the neccessary php.

I now have a html form that allows me to add entries to my PostgreSQL
database as well as a search engine to retrieve data. This all runs on the
e3000! Pretty cool stuff. In addition to all this coolness, php & PostgreSQL
support persistent connections, meaning that once you have created a few
connections to the database, these connections are kept alive in a pool for
later use. This reduces the amount of resources PostgreSQL uses at the
beginning of each request.

Just thought I'd let the e3000 world know.

Peter Osborne
Web Developer
Carleton Technologies

ATOM RSS1 RSS2