Re: web interface to a relational db

On Oct 21, 2005, at 2:53 AM, Michele Simionato wrote:

> On 10/21/05, Oleg Broytmann <[email protected]> wrote:
>> On Fri, Oct 21, 2005 at 11:35:50AM +0200, Ksenia Marasanova wrote:
>>> Of course you'll still need to write some Quixote code for handling 
>>> requests...
>>
>>    This is exactly what Michele is trying to avoid! (-:
>
> Not at all! I can live very well with writing the Quixote code, I just 
> want to
> avoid to write the HTML-generation code for the CRUD functionality. I 
> must
> really investigate FormEncode and SQLObject and see what is already 
> there ....
>

If you're looking at those, there is also QLime's object relational 
mapper that you may want to explore. Although the site hasn't been 
updated for a while, email support is still alive ;)

It follows the DRY principle so you do not re-define the schema outside 
the database. The following link describes setting up a data lookup to 
a csv file and then switching it to use a database. There is not 
automatic CRUD though.

http://www.qlime.org/0.5.1/qlime_handbook.html#data-access-techniques

Cheers,
Shalabh