[lug] Pointers Needed for Building Web Interface for PostgreSQL

[Hugh Brown]

Andrew Diederich wrote:
> Hello Bill,
> 
> Monday, November 27, 2006, 2:10:17 PM, you 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.
> 
> Had you thought about Django (http://www.djangoproject.com/)? It's a
> python web-framework. I haven't personally set it up yet, though it
> may have all of the pieces in Fedora already. The thing that they
> really trumpet is the automatic admin interface. You tell it about the
> data model (and they have tools to discover your existing data model
> already) and it creates pages where you can see and modify the
> database information. The tutorial for that part is
> http://www.djangoproject.com/documentation/tutorial2/
> 
> As I recall, you get authentication for free, as well.  You'd want the
> dev version -- it's currently one of those products where the "stable"
> version is too old.
> 
> Basically, I've been trying to cajole people into trying it out so I
> can see how well it works.
> 
>> 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?
> 
> 

I just helped a professor set django up for a class.  He was deciding 
between sqlite and postgres but was expecting to need to install the 
python db driver for either db.  I'm not positive that he needed to for 
postgres.  He ended up using sqlite and he did have to add the python db 
driver for it.  My very brief exposure to it made me think it was a web 
server written in python that was far more lightweight than apache and 
had an obvious python affinity.

Hugh