[lug] Pointers Needed for Building Web Interface for PostgreSQL

[Hugh Brown]

On Mon, 27 Nov 2006, Bill Thoen wrote:

> I'm looking for pointers/examples on how to build a web interface to a
> PostgreSQL database residing on a Fedora Core 5 system. I don't need
> anything too involved at this point; I just want to see what's involved in
> creating a simple interface that lets authorized users view records in a
> form based view and edit certain fields.
>
> The Googlits I've found so far seem to favor PHP, but I was hoping there's
> something for Perl or even pgsql. Does anyone have any suggestions?
>
> - Bill Thoen

I think you need to decide which programming language you prefer.  I know
you can connect to postgres from perl, java, python, php, ....

Almost always, it involves having the db interaction package installed.
On a RH4 box (which would be mostly similar to a FC5 box) the relevant
rpms are:

perl can use: perl-DBD-Pg
python can use: postgresql-python
php can use: php-pgsql
java uses the postgres jdbc driver

I'm not sure what you mean by pgsql.  So, if you know one language over
another (say perl), then use that.

rpm -ql <package name from above> to find package contents and
documentation.

HTH,

Hugh