Re: HTML generation with PL/PgSQL

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 understand their ways of doing things.
Both are different from the rather inelegant way of printing each HTML element using special coding, which Oracle looks like it uses.
Draco has strong logic/presentation seperation. Quixote takes the unique approach of allowing you to embed HTML in Python rather 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 of mod_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