From owner-freebsd-questions@FreeBSD.ORG Sat Feb 12 08:43:29 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 BD32D16A4CE for ; Sat, 12 Feb 2005 08:43:29 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1EE0443D49 for ; Sat, 12 Feb 2005 08:43:29 +0000 (GMT) (envelope-from linicks@gmail.com) Received: by rproxy.gmail.com with SMTP id 34so341607rns for ; Sat, 12 Feb 2005 00:43:28 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=tA1AOuybBCDHQrKpVmQ2eNwBxcKXnsxBODw/4626HShZkVjq/XZo1kzW6rwD1zS3wS74fmU1KuuxBHiTiq2+86kMo0JPo6y6E6MR0MhUJvBXzQYG96eFEhVzJtP/YFIYzjQz0bsajhneLm0g5GYts/BJ4nHZx6Fb702Cqb7dUlQ= Received: by 10.38.179.13 with SMTP id b13mr85187rnf; Sat, 12 Feb 2005 00:43:28 -0800 (PST) Received: by 10.38.8.20 with HTTP; Sat, 12 Feb 2005 00:43:28 -0800 (PST) Message-ID: Date: Sat, 12 Feb 2005 01:43:28 -0700 From: Nick Pavlica To: Ean Kingston In-Reply-To: <200502111859.10482.ean@hedron.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net> <200502111859.10482.ean@hedron.org> 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 Reply-To: Nick Pavlica List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 12 Feb 2005 08:43:29 -0000 I have used both of these databases on critical production servers with great results. I would suggest that you play around with both of them. --Nick On Fri, 11 Feb 2005 18:59:10 -0500, Ean Kingston wrote: > 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. > > From a basic design standpoint, MySQL was designed to be a fast language > compatible RDBMS system. To achieve that goal they cut out a lot of features. > Particularly those related to integrity, consistency, and validity checking. > > Postgres is designed to be a fully functional RDBMS that complies with the SQL > standard. It includes integrity, consistency, and validity checking that > MySQL lacks. > > I also think one of the reasons that MySQL is more common than Postgres is > because when they were both starting out, MySQL got a functional RDBMS out > much sooner than Postgres did and when Postgres did get theirs out, MySQL was > a lot faster (because of the lack of data validation). Postgres has since > 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 > server easier. > > -- > Ean Kingston > > E-Mail: ean AT hedron DOT org > URL: http://www.hedron.org/ > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" >