From owner-freebsd-questions Fri Oct 23 02:41:39 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id CAA11920 for freebsd-questions-outgoing; Fri, 23 Oct 1998 02:41:39 -0700 (PDT) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from ns.cityip.co.za (ns.cityip.co.za [196.25.223.140]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id CAA11908 for ; Fri, 23 Oct 1998 02:41:33 -0700 (PDT) (envelope-from wjv@cityip.co.za) Received: from wjv by ns.cityip.co.za with local (Exim 1.82 #2) id 0zWdhz-0005Vf-00; Fri, 23 Oct 1998 11:40:35 +0200 Message-ID: <19981023114035.C21119@cityip.co.za> Date: Fri, 23 Oct 1998 11:40:35 +0200 From: Johann Visagie To: Frank Griffith , freebsd-questions@FreeBSD.ORG Subject: Re: MySQL vs PostgreSQL Mail-Followup-To: Frank Griffith , freebsd-questions@FreeBSD.ORG References: <000701bdfdfc$5c598b00$dcf6a2a5@fgriffth.ctxmort.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.91.1i In-Reply-To: <000701bdfdfc$5c598b00$dcf6a2a5@fgriffth.ctxmort.com>; from Frank Griffith on Thu, Oct 22, 1998 at 03:41:34PM -0500 X-PGP: ftp://ftp.cityip.co.za/users/wjv/pubkey.asc Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Thu, 22 Oct 1998 at 15:41 SAT, Frank Griffith wrote: > > I have just gotten PostgreSQL-6.3.2 compiled and installed > on my FreeBSD 2.2.7 system and I'm starting to learn the > ropes. Not far into my reading, I came across some references > to MySQL. > > Can anyone tell me how these two compare. Should I stay with > PostgreSQL-6.3.2 or try MySQL? Any advice would be appreciated. Without going into too much technical detail, one can probably say that MySQL is the more well-rounded "product" for the moment, but that PostgreSQL's eventual aims are more ambitious. There are numerous differences between the two, and which one will work better under certain circumstances depends very much on those circumstances. My vote is for "if it works for you, stick with it". VERY important is the difference in licensing issues. Postgres is pretty much free in all senses of the word. MySQL you have to pay for if you base a commercial product on it. BTW, for a cute way of giving your Postgres databases a Web front-end, see: http://www.php.net/ -- V Johann Visagie | wjv@CityIP.co.za | Tel: +27 21 419-7878 | ICQ: 20645559 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message