Thread: Perl and Postgres

Perl and Postgres

From
"Brian C. Doyle"
Date:
Hello all,

Where can I look to find out more about developing a web based interface
via Perl.. Currently I do it all via PHP but do to resources available for
a project I have I need to convert over to perl.. I check the Postgres
Doc's and there were no examples to help get me started.  Any thing
appreciated.



Re: Perl and Postgres

From
"Roderick A. Anderson"
Date:
On Wed, 26 Sep 2001, Brian C. Doyle wrote:

> Hello all,
>
> Where can I look to find out more about developing a web based interface
> via Perl.. Currently I do it all via PHP but do to resources available for
> a project I have I need to convert over to perl.. I check the Postgres
> Doc's and there were no examples to help get me started.  Any thing
> appreciated.

"Programming the Perl DBI", Decartes, Bunce, Oreilly
"Perl Cookbook", Christiansen & Torkington, Oreilly
"Advanced Perl Programming", Srinivasan, Oreilly

Yes I am a bit of an Oreilly fan!

And a few suggestions:

Normalize, normalize, normalize.
(de-normalize portions if needed)

Put as much of the application logic in the database as you can.

Don't re-invent the wheel, use as many perl modules as you need.


Cheers,
Rod
--
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler


Re: Perl and Postgres

From
Michael
Date:

Perl and Apache are old lovers.

http://perl.apache.org/

This is Stas Bekman guide -- it was more help than the O'Rielly book on
Apache modules.

http://perl.apache.org/guide/

You most likely want to you Apache::DBI.


On Wed, 26 Sep 2001, Brian C. Doyle wrote:

> Date: Wed, 26 Sep 2001 08:35:03 -0400
> From: Brian C. Doyle <bcdoyle@mindspring.com>
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Perl and Postgres
>
> Hello all,
>
> Where can I look to find out more about developing a web based interface
> via Perl.. Currently I do it all via PHP but do to resources available for
> a project I have I need to convert over to perl.. I check the Postgres
> Doc's and there were no examples to help get me started.  Any thing
> appreciated.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


Re: Perl and Postgres

From
"Jeff Eckermann"
Date:
This probably seems ludicrously obvious, but: you need to have the DBI and
DBD::Pg modules installed on your system.
The definitive source is "perldoc DBI", though this is not nearly as easy to
read as the other sources mentioned.

----- Original Message -----
From: "Roderick A. Anderson" <raanders@tincan.org>
To: "Brian C. Doyle" <bcdoyle@mindspring.com>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, September 26, 2001 8:59 AM
Subject: Re: [GENERAL] Perl and Postgres


> On Wed, 26 Sep 2001, Brian C. Doyle wrote:
>
> > Hello all,
> >
> > Where can I look to find out more about developing a web based interface
> > via Perl.. Currently I do it all via PHP but do to resources available
for
> > a project I have I need to convert over to perl.. I check the Postgres
> > Doc's and there were no examples to help get me started.  Any thing
> > appreciated.
>
> "Programming the Perl DBI", Decartes, Bunce, Oreilly
> "Perl Cookbook", Christiansen & Torkington, Oreilly
> "Advanced Perl Programming", Srinivasan, Oreilly
>
> Yes I am a bit of an Oreilly fan!
>
> And a few suggestions:
>
> Normalize, normalize, normalize.
> (de-normalize portions if needed)
>
> Put as much of the application logic in the database as you can.
>
> Don't re-invent the wheel, use as many perl modules as you need.
>
>
> Cheers,
> Rod
> --
>                       Let Accuracy Triumph Over Victory
>
>                                                        Zetetic Institute
>                                                         "David's Sling"
>                                                          Marc Stiegler
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>