From owner-freebsd-www  Thu May 15 09:14:35 1997
Return-Path: <owner-freebsd-www>
Received: (from root@localhost)
          by hub.freebsd.org (8.8.5/8.8.5) id JAA26438
          for www-outgoing; Thu, 15 May 1997 09:14:35 -0700 (PDT)
Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1])
          by hub.freebsd.org (8.8.5/8.8.5) with ESMTP id JAA26428;
          Thu, 15 May 1997 09:14:29 -0700 (PDT)
Received: from localhost (jfieber@localhost)
	by fallout.campusview.indiana.edu (8.8.5/8.8.5) with SMTP id LAA28062;
	Thu, 15 May 1997 11:14:07 -0500 (EST)
Date: Thu, 15 May 1997 11:14:06 -0500 (EST)
From: John Fieber <jfieber@indiana.edu>
To: Mark Mayo <mark@quickweb.com>
cc: Doug White <dwhite@resnet.uoregon.edu>,
        John-Mark Gurney <gurney_j@resnet.uoregon.edu>,
        "Jonathan M. Bresler" <jmb@FreeBSD.ORG>, webmaster@FreeBSD.ORG
Subject: Re: help! apache doesn't send cgi's output...
In-Reply-To: <Pine.BSF.3.95q.970515094343.16513A-100000@vinyl.quickweb.com>
Message-ID: <Pine.BSF.3.96.970515110135.311G-100000@fallout.campusview.indiana.edu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-www@FreeBSD.ORG
X-Loop: FreeBSD.org
Precedence: bulk

On Thu, 15 May 1997, Mark Mayo wrote:

> Take a look at PostreSQL as well, if you're in the market for a free
> database! I've just switched and I like the PostreSQL much more than mSQL.

PostgreSQL is better for many reasons, but one consideration for
CGI applications is there is a much larger overhead involved in
starting up a "backend" to service a request than with mSQL.  If
you have big complex queries PostgreSQL is a clear winner, but
for simple databases and simple queries, mSQL may be better just
because of the lower startup overhead.

There may ultimately be postgresql server running on
www.freebsd.org to support the mailing list archives.  The
freewais-sf software works pretty well for keyword type queries,
and can work for thread retrieval but the performance is
unacceptable.  I think postgresql should prove much more suitable
for that task. 

> More features, quicker, and a cleaner C API (IMHO). I'm quite impressed.
> http://www.postresql.org  for the info. Oh, a much friendlier license as
                ^^

That should be www.postGresql.org.  :)

Alas, I'm still running Postgres95-1.08 because PostgreSQL 6.0
crashes and burns when I try to load in one of my databases (see
http://fallout.campusview.indiana.edu/mapfinder).  I have not yet
had a chance to investigate why. 

-john