From owner-freebsd-questions@FreeBSD.ORG Fri Feb 11 23:59:00 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 6DCDF16A4CE for ; Fri, 11 Feb 2005 23:59:00 +0000 (GMT) Received: from prosporo.hedron.org (hedron.org [66.11.182.60]) by mx1.FreeBSD.org (Postfix) with ESMTP id DF85943D2F for ; Fri, 11 Feb 2005 23:58:59 +0000 (GMT) (envelope-from ean@hedron.org) Received: from localhost.hedron.org (localhost.hedron.org [127.0.0.1]) by prosporo.hedron.org (Postfix) with ESMTP id 08ED1C0C5 for ; Fri, 11 Feb 2005 18:59:11 -0500 (EST) From: Ean Kingston To: freebsd-questions@freebsd.org Date: Fri, 11 Feb 2005 18:59:10 -0500 User-Agent: KMail/1.7.1 References: <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net> In-Reply-To: <420D2F12.8020808@comcast.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200502111859.10482.ean@hedron.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 23:59:00 -0000 On February 11, 2005 05:17 pm, Sean wrote: > Jan Branbergen wrote: > >>I would like to install SQL here for my own use, not for any real life > >> > >>currently, round now for learning. > >> > >>Right now plan to install MySQL. > >>Looking through the ports there is numerous version and some say for > >> > >>server, some say for client. > >> > >>Looking for some tips as to what version of SQL and tools to > >>install? > >>Also wondering if anyone can point me towards documentation in my > >>learning efforts? > > > > i would like to suggest PostgreSQL if your objective is learning SQL. > > MySQL only provides a subset. > > > > it is by no means more complicated to install or to get started. > > > > regards, > > > > Jan > > What is the difference between PostgreSQL and MySQL? > From what I see MySQL seems to be more common. =46rom a basic design standpoint, MySQL was designed to be a fast language= =20 compatible RDBMS system. To achieve that goal they cut out a lot of feature= s.=20 Particularly those related to integrity, consistency, and validity checking. Postgres is designed to be a fully functional RDBMS that complies with the = SQL=20 standard. It includes integrity, consistency, and validity checking that=20 MySQL lacks. I also think one of the reasons that MySQL is more common than Postgres is= =20 because when they were both starting out, MySQL got a functional RDBMS out= =20 much sooner than Postgres did and when Postgres did get theirs out, MySQL w= as=20 a lot faster (because of the lack of data validation). Postgres has since=20 closed the gap a lot on the speed issues while keeping the data integrity. On the other hand, there are a lot more tools that make managing a MySQL=20 server easier. =2D-=20 Ean Kingston E-Mail: ean AT hedron DOT org URL: http://www.hedron.org/