[ic] HTML in SQL database

George Osvald interchange-users@icdevgroup.org
Fri Oct 11 19:56:00 2002


>You can serve pages from a database table, we will call it "files" for the
>purpose of discussion. It should have the following fields:

>    code base_code page_text show_date expiration_date base_page

>The code is the page name (sans .html extension), and "page_text" is
>the content. The rest of the fields are unimportant in this context.

>Then put in catalog.cfg:

>        PageTables   files

>At that point, whenever you request a page for display this will be
>looked at first and that record delivered instead of the file.

>Before anyone asks, it is not documented. I doubt anyone has used it
>except for me. It has the ability to do a "teleport" mode, whereby
>you can select a page based on a point in history, but I will not explain
>that here (nor likely ever). That is what the extra fields are for.



I have been serving the whole web site from database using ZOPE for about four 
years now and I love the concept. Updating the site is a question of 
uploading a couple of files and everything else is done automatically. I am 
however forced by circumstances to change for IC (Perl v Python problem) and 
I need something really flexible.



-- 

Regards,

George Osvald
OK Studio ®
http://www.okstudio.com.au
Email: mail@okstudio.com.au