From owner-freebsd-questions@FreeBSD.ORG Sat Feb 12 00:07:47 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 0C18D16A4CE for ; Sat, 12 Feb 2005 00:07:47 +0000 (GMT) Received: from out006.verizon.net (out006pub.verizon.net [206.46.170.106]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7D2E143D2D for ; Sat, 12 Feb 2005 00:07:46 +0000 (GMT) (envelope-from leblanc@keyslapper.org) Received: from keyslapper.org ([68.163.189.143]) by out006.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050212000745.XXPH28674.out006.verizon.net@keyslapper.org> for ; Fri, 11 Feb 2005 18:07:45 -0600 Received: from localhost (localhost [127.0.0.1]) by keyslapper.org (Postfix) with ESMTP id 79B8611C58 for ; Fri, 11 Feb 2005 19:07:44 -0500 (EST) Received: from keyslapper.org ([127.0.0.1]) by localhost (keyslapper.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26459-07 for ; Fri, 11 Feb 2005 19:07:36 -0500 (EST) Received: by keyslapper.org (Postfix, from userid 1001) id C812D11BCA; Fri, 11 Feb 2005 19:07:36 -0500 (EST) Date: Fri, 11 Feb 2005 19:07:36 -0500 From: Louis LeBlanc To: freebsd-questions@freebsd.org Message-ID: <20050212000736.GE22856@keyslapper.net> Mail-Followup-To: freebsd-questions@freebsd.org References: <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net> <200502111859.10482.ean@hedron.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="vtzGhvizbBRQ85DL" Content-Disposition: inline In-Reply-To: <200502111859.10482.ean@hedron.org> X-PGP-Key: http://www.keyslapper.net/~leblanc/leblanc-at-keyslapper-net.asc User-Agent: Mutt/1.5.7i X-Virus-Scanned: amavisd-new at keyslapper.net X-Authentication-Info: Submitted using SMTP AUTH at out006.verizon.net from [68.163.189.143] at Fri, 11 Feb 2005 18:07:45 -0600 Subject: Re: SQL Questions (MySQL or PostgreSQL?) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: freebsd-questions@FreeBSD.org List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 12 Feb 2005 00:07:47 -0000 --vtzGhvizbBRQ85DL Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Then again, you could just ride the fence and install them both . . . I'd also suggest you start with MySQL though. As mentioned previously, it's the more commonly used DB. I started with PostgreSQL, and wound up having to install MySQL anyway because I wanted to try some apps that requred it. No big deal, they listen on different ports, and if you aren't running anything "real life" you won't notice them on a reasonably modern system. Besides, there are more MySQL books out there. Lou On 02/11/05 06:59 PM, Ean Kingston sat at the `puter and typed: > 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. >=20 > From 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 featu= res.=20 > Particularly those related to integrity, consistency, and validity checki= ng. >=20 > Postgres is designed to be a fully functional RDBMS that complies with th= e SQL=20 > standard. It includes integrity, consistency, and validity checking that= =20 > MySQL lacks. >=20 > I also think one of the reasons that MySQL is more common than Postgres i= s=20 > because when they were both starting out, MySQL got a functional RDBMS ou= t=20 > much sooner than Postgres did and when Postgres did get theirs out, MySQL= was=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. >=20 > On the other hand, there are a lot more tools that make managing a MySQL= =20 > server easier. >=20 > --=20 > Ean Kingston >=20 > 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.o= rg" >=20 --=20 Louis LeBlanc FreeBSD-at-keyslapper-DOT-net Fully Funded Hobbyist, KeySlapper Extrordinaire :) Please send off-list email to: leblanc at keyslapper d.t net Key fingerprint =3D C5E7 4762 F071 CE3B ED51 4FB8 AF85 A2FE 80C8 D9A2 Factorials were someone's attempt to make math LOOK exciting. --vtzGhvizbBRQ85DL Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (FreeBSD) iD8DBQFCDUjIr4Wi/oDI2aIRAtxoAJ9bc1L9K0R+z8uynsaRV0GF/Z9LbwCdHdKN DXWIItHzMp0q6T55NOoT8O0= =7JNN -----END PGP SIGNATURE----- --vtzGhvizbBRQ85DL--