Re: Re: perl vs php for postgresql - Mailing list pgsql-general

Jason,

Thank you for the insightful post. I did make a typo when I typed DBM. I
guess I was frazzled and really meant DBD.  Since I eventuall want to open a
socket and send some data to/from the database, you have made me realize (or
remember) why I was using perl in the first place. Thanks.

-John

"Jason Earl" <jdearl@yahoo.com> wrote in message
news:20010522194855.88731.qmail@web10008.mail.yahoo.com...
> 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly