From owner-freebsd-www  Wed May 14 22:11:16 1997
Return-Path: <owner-freebsd-www>
Received: (from root@localhost)
          by hub.freebsd.org (8.8.5/8.8.5) id WAA29761
          for www-outgoing; Wed, 14 May 1997 22:11:16 -0700 (PDT)
Received: from gdi.uoregon.edu (gdi.uoregon.edu [128.223.170.30])
          by hub.freebsd.org (8.8.5/8.8.5) with ESMTP id WAA29753;
          Wed, 14 May 1997 22:11:11 -0700 (PDT)
Received: from localhost (dwhite@localhost) by gdi.uoregon.edu (8.8.5/8.6.12) with SMTP id WAA18847; Wed, 14 May 1997 22:11:10 -0700 (PDT)
Date: Wed, 14 May 1997 22:11:10 -0700 (PDT)
From: Doug White <dwhite@gdi.uoregon.edu>
X-Sender: dwhite@localhost
Reply-To: Doug White <dwhite@resnet.uoregon.edu>
To: John-Mark Gurney <gurney_j@resnet.uoregon.edu>
cc: "Jonathan M. Bresler" <jmb@FreeBSD.ORG>, webmaster@FreeBSD.ORG
Subject: Re: help! apache doesn't send cgi's output...
In-Reply-To: <19970514153146.26267@hydrogen.nike.efn.org>
Message-ID: <Pine.BSF.3.96.970514220515.18483A-100000@localhost>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-www@FreeBSD.ORG
X-Loop: FreeBSD.org
Precedence: bulk

On Wed, 14 May 1997, John-Mark Gurney wrote:

> > 	would be nice to be able to search the database using 
> > 	miniSQL ;)
> 
> well.. it shouldn't be that hard to adapt to SQL...  just never done
> any SQL programming... Doug, you have an easy example to use?

I have ancient stuff I wrote last year that's quite crusty but would serve
as a decent start to the mSQL C API.  The API is quite straightforward,
actually -- the worst part is that you have to stick together strings for
the queries and you know how well C does string manipulation (wink wink).. 

> I was thinking about creating an index along side this databae so that
> we could do indexing/sorting easier...  if someone is interested in the
> source for the cgi... just mail me... you'll be surprised how simple it
> is... :)

mSQL would do that for you.  Disadvantage is that someone has to run the
daemon, but it's quite small and requires no user intervention once
running, and it's very, very fast.

Doug White                              | University of Oregon  
Internet:  dwhite@resnet.uoregon.edu    | Residence Networking Assistant
http://gladstone.uoregon.edu/~dwhite    | Computer Science Major