From owner-freebsd-questions Thu Aug 5 7:53: 6 1999 Delivered-To: freebsd-questions@freebsd.org Received: from mail.rdc1.az.home.com (ha1.rdc1.az.home.com [24.1.240.66]) by hub.freebsd.org (Postfix) with ESMTP id 5A72A154DB for ; Thu, 5 Aug 1999 07:53:03 -0700 (PDT) (envelope-from elgreen@iname.com) Received: from ehome.local.net ([24.9.114.169]) by mail.rdc1.az.home.com (InterMail v4.01.01.00 201-229-111) with SMTP id <19990805145210.NGMD27077.mail.rdc1.az.home.com@ehome.local.net> for ; Thu, 5 Aug 1999 07:52:10 -0700 From: Eric Lee Green Organization: Myself @ Home To: questions@FreeBSD.ORG Subject: Re: SQL Server Recomendation Needed Date: Thu, 5 Aug 1999 07:45:28 -0700 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain References: <3.0.6.32.19990804202848.0079a9d0@we.mediaone.net> MIME-Version: 1.0 Message-Id: <99080507521800.04193@ehome.local.net> Content-Transfer-Encoding: 8bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 04 Aug 1999, Joey Garcia wrote: > work we use DB2 on the AS/400 so I was thiking of using a database > server that's similar to DB2. Then you probably want to use PostGreSQL. MySQL is blazingly fast and perfect for a web back-end, but is woefully lacking in functionality compared to something like DB2. (By "functionality", I mean things like cursors, transactions, triggers, server-side stored procedures, etc. that both PostgreSQL and DB2 have). > 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? PostgreSQL comes with something called "pgaccess" which does some of the "heavy lifting" in this instance. Most new Unix applications today use a web page interface. PHP3 is easy to use and interfaces well with the Apache web server via the mod_php3 interface. I believe this is available in ports and packages already pre-done. For more info: http://www.php3.net http://www.postgresql.org http://www.mysql.org (U.S. mirror of master site) -- Eric Lee Green http://members.tripod.com/e_l_green mail: e_l_green@hotmail.com ^^^^^^^ Burdening Microsoft with SPAM! To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message