Re: Re: perl vs php for postgresql

The types of problems that John is having are quite
likely to persist with PHP, as his problems aren't so
much in programming with Perl, as it seems to be with
compiling the requisite Perl modules.  I haven't used
PHP since PHP3, but if I remember correctly it was a
lot more difficult to build a version of Apache that
had a PostgreSQL compatible PHP module than it was to
build DBD:Pg.

John, if you really are trying to build the Perl
module for PostgreSQL you need to get "DBD::Pg"  (not
DBM::Pg).  You will also need the DBI module.  Both of
these can be found on CPAN, and the instructions are
pretty complete (feel free to email me with specific
questions).

I would also second Craig's endorsement of PHP.  It is
exceptionally easy to use, and it performs well
without having to learn to use mod_perl (I prefer Zope
and Python, but that's another story).  The cool thing
about Perl, on the other hand, is that you can use it
for your system adminstration tasks as well (yes, PHP
can be used from the command line, but there is no
better glue language than Perl).  I find myself using
it very frequently for tasks such as importing data
into PostgreSQL and exporting data from PostgreSQL for
use somewhere else.

--- Craig Orsinger
<cjorsinger@m5.earthlink_net.invalid> wrote:
> In article
> <uskO6.1504$5G1.464213@typhoon2.ba-dsg.net>, "John"
> <vze23skh@verizon.net> wrote:
>
> > It seems that I having problems locating the
> DBM:Pg module. I even
> > followed the instructions on compiling postgresql
> to support it.  My
> > perl scripts don't seem to know about a Pg module
> and I have not had any
> > luck finding answers. Is is easier to use php with
> postgresql? Will I
> > have the same kinds of problems?  Thanks for any
> advice.
>
>     I can't comment on the relative ease, but PHP is
> easy to use, at
> least for small projects like mine. I don't mean to
> start a flame war
> here, but Perl's syntax alwasy seemed a little
> obscure to me. I'm used
> to C and C-inspired shells. Not knowing anything
> about PHP, it took
> me about an hour to build a page that would display
> an HTML table
> from select, with color-coded rows. Not too bad for
> an occasional
> programmer.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/