From owner-freebsd-www  Fri Jan 17 12:12:11 1997
Return-Path: <owner-freebsd-www>
Received: (from root@localhost)
          by freefall.freebsd.org (8.8.4/8.8.4) id MAA22996
          for www-outgoing; Fri, 17 Jan 1997 12:12:11 -0800 (PST)
Received: from ptero.ag.com.br (agsist.ag.com.br [200.255.215.239])
          by freefall.freebsd.org (8.8.4/8.8.4) with SMTP id MAA22991
          for <freebsd-www@freebsd.org>; Fri, 17 Jan 1997 12:12:04 -0800 (PST)
Received: from ricardo.ag.com.br (ricardo.ag.com.br [10.0.0.2]) by ptero.ag.com.br (8.6.12/8.6.12) with SMTP id SAA22075; Fri, 17 Jan 1997 18:11:28 -0200
Message-ID: <32DFE9F4.31BC@ag.com.br>
Date: Fri, 17 Jan 1997 18:07:00 -0300
From: Ricardo AG <ricardag@ag.com.br>
Reply-To: ricardag@ag.com.br
Organization: AG Sistemas
X-Mailer: Mozilla 3.0Gold (Win95; I)
MIME-Version: 1.0
To: John Fieber <jfieber@indiana.edu>
CC: Ade Barkah <mbarkah@hemi.com>, "Jordan K. Hubbard" <jkh@time.cdrom.com>,
        freebsd-www@freebsd.org
Subject: Re: Test CGI interface... (was: Re: cvs commit: www/data comm...)
References: <Pine.BSI.3.95.970117141501.22331H-100000@fallout.campusview.indiana.edu>
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:

> 
> > a. I chose Postgres, but mSQL is likely sufficient. Regardless, this
> 
> 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.

I agree tottaly with you. Please, wait until Mon, Jan 20. I'm working
had on this, with a C script and a plain text file.

> Now for the bad news: This scheme presents some problems for
> mirroring.  Unless the system can be easily duplicated (not
> likely considering many mirrors won't even run cgi scripts), it
> will be yet another portion of the web pages that people have to
> trek all the way back to freefall to get, which is something to
> be avoided whenever possible.  Heck, I am at a well connected
> site in Indiana and have a hard time getting through sometimes!

I think that I can turn the CGI script into a HTML-generator automata,
that create the pages every time the database changes, even to remove
the old "new" flagged entries (I believe that the "new" flag must remain
for one month, not more)

> This does not necessairly mean ditching the database idea.
> Rather, it means generating static copies of the pages during
> daily regeneration process.  Of course, could still a problem for
> people who want to mirror the web source and generate their live
> pages locally.

Oops! You had stolen the words from my mouth!! :)

Best regards,

Ricardo