From owner-freebsd-questions@FreeBSD.ORG Fri Feb 11 22:30:27 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 17D7816A4D0 for ; Fri, 11 Feb 2005 22:30:26 +0000 (GMT) Received: from lorna.circlesquared.com (host217-45-219-85.in-addr.btopenworld.com [217.45.219.85]) by mx1.FreeBSD.org (Postfix) with ESMTP id 39AB743D4C for ; Fri, 11 Feb 2005 22:30:17 +0000 (GMT) (envelope-from peter@circlesquared.com) Received: from localhost.circlesquared.com (localhost.circlesquared.com [127.0.0.1])j1BMUBer074302; Fri, 11 Feb 2005 22:30:13 GMT (envelope-from peter@circlesquared.com) From: Peter Risdon To: rsh.lists@comcast.net In-Reply-To: <420D2F12.8020808@comcast.net> References: <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net> Content-Type: text/plain Date: Fri, 11 Feb 2005 22:30:11 +0000 Message-Id: <1108161011.23699.98.camel@lorna.circlesquared.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit cc: Jan Branbergen cc: "freebsd-questions@freebsd.org" Subject: Re: SQL Questions (MySQL or PostgreSQL?) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Feb 2005 22:30:27 -0000 On Fri, 2005-02-11 at 17:17 -0500, Sean wrote: > > What is the difference between PostgreSQL and MySQL? > From what I see MySQL seems to be more common. They are completely separate projects. Postgresql grew out of an academic project (ingres), mysql was developed by a commercial organisation because of limitations and license issues with another sql database system (MiniSQL) that isn't in much use now. Mysql was developed for speed rather than features. And it is fast. It's catching up on the feature front but Postgresql is a more complete implementation of sql and is usually considered to be an upgrade from mysql. For example, the excellent web-based accountancy system SQL-Ledger uses postgresql at least in part because of its earlier implementation of transactions - vital for an accounts package. However, mysql is at the heart of all the LAMP (Linux, Apache, Mysql, PHP) and WAMP (Windows, etc) projects that are around nowadays. Mysql is a very good place to start. Less of a learning curve than Postgresql (IMHO), better documentation (online at least) and more widely used. Postgresql is an excellent dbms and well worth a look. But if you're starting out, I think mysql is the place to be. Peter.