Re: HTML generation with PL/PgSQL - Mailing list pgsql-general

From Scott Chapman
Subject Re: HTML generation with PL/PgSQL
Date
Msg-id 200310232224.19941.scott_list@mischko.com
Whole thread Raw
In response to HTML generation with PL/PgSQL  ("Birahim FALL" <birahim.fall@hispeed.ch>)
Responses Re: HTML generation with PL/PgSQL  (Richard Huxton <dev@archonet.com>)
Re: HTML generation with PL/PgSQL  (Network Administrator <netadmin@vcsn.com>)
List pgsql-general
On Thursday 23 October 2003 11:38, Birahim FALL wrote:

> Is such a product exists (preferably opensource).
> I'm ready to go for python etc, but I really wuld have to re-educate
> myself.....

Bir,
There are a LOT of ways to make web pages with data from Postgres.

I'd suggest you get:

The latest Postgres
Apache2 (http://httpd.apache.org)
Mod_Python (http://www.modpython.org) Get the latest CVS version (3.1.2b at this writing).
Python 2.3.2+ (http://www.python.org)
Draco (http://draco.boskant.nl) 0.99.4 or (Quixote http://freshmeat.net/redir/quixote/18740/url_homepage/quixote)
and Psycopg (http://freshmeat.net/projects/psycopg)
  and whatever few dependencies these have (mxDateTime comes to mind).

Get the latest versions of everything.  That's a complete kit to make Anything You Want.

Draco and Quixote take much different approaches to gluing Python to web pages.  Both are worth a good look, just to
understandtheir ways of doing things. 
Both are different from the rather inelegant way of printing each HTML element using special coding, which Oracle looks
likeit uses.   
Draco has strong logic/presentation seperation. Quixote takes the unique approach of allowing you to embed HTML in
Pythonrather than the more common opposite. 
There are LOTS of other packages to "glue" HTML and databases together in Python.  I wouldn't look anywhere beyond
Python.
I've found Draco to be very approachable and well designed and fairly complete. (You will need the CVS version 3.1.2b
ofmod_python or newer to make it work right). 

Everyone, of course, disagrees on what combination is be the Right Thing.  These are my favorites, for now.
I'm re-educating myself out of Perl, Procedural Programming and other Wrong Things (ducking to avoid flames).
It's a hill to climb but I'm really enjoying it and have Big Plan$ that Postgres will be driving.  :-)

Happy Trails,
Scott

pgsql-general by date:

Previous
From: "Claudio Lapidus"
Date:
Subject: Re: CLUSTER
Next
From: Pavel Stehule
Date:
Subject: Re: Simple SQL