From owner-freebsd-database Wed Apr 1 05:59:58 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA01923 for freebsd-database-outgoing; Wed, 1 Apr 1998 05:59:58 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from mail.actrix.gen.nz (root@mail.actrix.gen.nz [203.96.16.37]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA01914 for ; Wed, 1 Apr 1998 05:59:54 -0800 (PST) (envelope-from andrew@squiz.co.nz) Received: from [192.168.1.1] (aniwa.actrix.gen.nz [203.96.56.186]) by mail.actrix.gen.nz (8.8.8/8.8.5) with SMTP id BAA06318 for ; Thu, 2 Apr 1998 01:59:44 +1200 (NZST) X-Sender: squiz1@mail.actrix.gen.nz Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Thu, 2 Apr 1998 02:01:41 +1200 To: freebsd-database@FreeBSD.ORG From: andrew@squiz.co.nz (Andrew McNaughton) Subject: Re: Mailing list search interface Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I'm currently re-building a current affairs news web site to use a mysql database. The kinds of search issues discussed regarding the freebsd mailing list archives are among the issues I'm facing, and if the project goes ahead as discussed here, I'd be interested in taking part (though I suspect I'm probably outclassed by other programmers here). As I say, so far I'm using mysql. It seems the discussion here has been about postgreSQL with references to oracle. Can someone give me or point me to a comparison between postgreSQL and mysql. Is the emphasis on postgreSQL due to licensing differences or functional ones? A quick look over the postgresSQL suggests that it has several query language features that mysql lacks (eg sub queries), and the docs place more emphasis on extension. It appears it does not do multithreading. How do they compare on speed? Postgres used to be slow, but I gather that postgreSQL is better. Andrew McNaughton DISCLAIMER: The Entire Physical Universe, Including Andrew McNaughton This Message, May One Day Collapse Back into an ++64 4 389 6891 Infinitesimally Small Space. Should Another Universe andrew@squiz.co.nz Subsequently Re-emerge, the Validity of Statements http://www.squiz.co.nz in This Message Cannot Be Guaranteed. http://www.newsroom.co.nz To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message