[lug] Pointers Needed for Building Web Interface for PostgreSQL

Bill Thoen bthoen at gisnet.com
Mon Nov 27 16:15:38 MST 2006


Thanks, Hugh... What I meant by 'pgsql' was the built-in language that
comes with Postgres, plpgsql. I'm most familiar with that, but I know
enough php and perl to be dangerous, so I can try the packages you
suggested and see if I can make them work.



On Mon, Nov 27, 2006 at 03:03:36PM -0700, Hugh Brown wrote:
> 
> 
> 
> 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
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: lug.boulder.co.us port=6667 channel=#colug
> 



More information about the LUG mailing list