From owner-freebsd-questions Thu Aug 5 12:53:19 1999 Delivered-To: freebsd-questions@freebsd.org Received: from nisser.com (n2000039.telekabel.chello.nl [212.187.0.39]) by hub.freebsd.org (Postfix) with ESMTP id 8545114D7C for ; Thu, 5 Aug 1999 12:52:30 -0700 (PDT) (envelope-from roelof@nisser.com) Received: from nisser.com (roelof [10.0.0.2]) by nisser.com (8.9.2/8.9.2) with ESMTP id VAA40717; Thu, 5 Aug 1999 21:52:00 +0200 (CEST) (envelope-from roelof@nisser.com) Message-ID: <37A9EB10.116C8BB4@nisser.com> Date: Thu, 05 Aug 1999 21:50:40 +0200 From: Roelof Osinga Organization: eboa - engineering buro Office Automation X-Mailer: Mozilla 4.6 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Joey Garcia Cc: questions@FreeBSD.ORG Subject: Re: SQL Server Recomendation Needed References: <3.0.6.32.19990804202848.0079a9d0@we.mediaone.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Joey Garcia wrote: > > At work we use DB2 on the AS/400 so I was thiking of using a database > server that's similar to DB2. I'm not quite sure if DB2 has been open > sourced (because the whole damn Linux thing), but I doubt it. And I also > doubt that there will be a *BSD port of DB2 anytime soon. > > So.... MySQL or PostreSQL? Which would you recomend for a database newbie? Doesn't matter much till you're ready for the advanced topics. But the only thing that's like DB2 is DB2. It has been made available for Linux, maybe it'll run using Linux compatibility mode. > Also, are there any GUI tools that will aid in creating tables and stuff > for either of the two open source databases mentioned? If so, can you > point me to their location? I don't think a GUI will aid much in learning SQL. You're probably better off tapping it in one key at a time. Anyway, before you're ready to create your tables you'll need to learn about normalizing them. Better get Chris Date's Introduction or what's his name's Intro to Date's Intro. Later of course followed by Joe Cello's masterpiece . Roelof PS PostgreSQL indeed has way more functions than MySQL but also more than SQL itself. It being a research project. That may be confusing when you're trying to learn the basics. -- Home is where the (@) http://eboa.com/ is. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message