From owner-freebsd-www Fri Jan 17 15:25:37 1997 Return-Path: Received: (from root@localhost) by freefall.freebsd.org (8.8.4/8.8.4) id PAA04664 for www-outgoing; Fri, 17 Jan 1997 15:25:37 -0800 (PST) Received: from hemi.com (hemi.com [204.132.158.10]) by freefall.freebsd.org (8.8.4/8.8.4) with ESMTP id PAA04659 for ; Fri, 17 Jan 1997 15:25:33 -0800 (PST) Received: (from mbarkah@localhost) by hemi.com (8.8.4/8.7.3) id PAA03166; Fri, 17 Jan 1997 15:48:32 -0700 (MST) From: Ade Barkah Message-Id: <199701172248.PAA03166@hemi.com> Subject: Re: Test CGI interface... (was: Re: cvs commit: www/data comm...) To: jfieber@indiana.edu (John Fieber) Date: Fri, 17 Jan 1997 15:48:32 -0700 (MST) Cc: jkh@time.cdrom.com, freebsd-www@freebsd.org In-Reply-To: from John Fieber at "Jan 17, 97 02:45:46 pm" X-Mailer: ELM [version 2.4ME+ PL22 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-www@freebsd.org X-Loop: FreeBSD.org Precedence: bulk John Fieber wrote: > For this application, I'd strongly put in a plug for mSQL, > or even a perl script that chews up a one-record-per-line > flat file. [...] > Now for the bad news: This scheme presents some problems > for mirroring. [...] This does not necessairly mean ditching > the database idea. Rather, it means generating static copies > of the pages during daily regeneration process. Yeah. I can't seem to think of a good way to integrate the database for mirroring. Since the database doesn't actually change constantly, a live CGI isn't really needed, of course. We should just make static pages daily as you suggest. I've adapted a new version that uses a '|' delimited flat-file. The http://freebsd.hemi.com/gallery.html has been updated to use this version in CGI mode. The output is identical to the Postgres version (i.e., I haven't put in any new features.) Now, like the old one, this new version can be called as a CGI, or can be called directly from the command line to facilitate creating static pages. That is, one can call it with: ./flat-query.cgi category=Commercial > gallery-commercial.html and simply distribute the .html file. =-) Makes it easier for people who'd like to build from source, too. > I'd add another date field "checked". We should be either > manually or automagically verifying the entries periodically and > that could be useful. Good idea. I'll add "checked" and a boolean field "disabled" (for new entries, and old links with problems.) If this looks like the way to go, then I'll write a simple program to manipulate the flat- file. Cya, -Ade ------------------------------------------------------------------- Inet: mbarkah@hemi.com - HEMISPHERE ONLINE - -------------------------------------------------------------------