From owner-freebsd-questions Thu Jan 29 09:58:00 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA15238 for questions-outgoing; Thu, 29 Jan 1998 09:58:00 -0800 (PST) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from infowest.com (infowest.com [204.17.177.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA15220 for ; Thu, 29 Jan 1998 09:57:57 -0800 (PST) (envelope-from agifford@infowest.com) Received: from default (homework.infowest.com [207.49.60.254]) by infowest.com (8.8.5/8.8.5) with SMTP id KAA28494 for ; Thu, 29 Jan 1998 10:57:51 -0700 (MST) Message-Id: <3.0.3.32.19980129105750.00865c60@infowest.com> X-Sender: agifford@infowest.com X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.3 (32) Date: Thu, 29 Jan 1998 10:57:50 -0700 To: questions@FreeBSD.ORG From: "Aaron D. Gifford" Subject: Re: ODBC / SQL & Windows NT In-Reply-To: <34D0A228.7CBFD748@tdx.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG X-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe questions" >Hi, > >I would like to be able to use my FreeBSD box as an SQL server, access the SQL >database from shell / perl / C++ etc. on the FreeBSD box itself, and be able >to access the SQL server via a remote Windows NT box (i.e. running ODBC >drviers). > >I've looked at Postgress & mySQL - is what I'm trying to do possible at the >moment with either of these packages, or how close can you get to this >'ideal'? - Does anyone run anything similar? > >I've also heard rumours that mySQL doesn't perform too well under FreeBSD? Can >anyone comment on this (or the performance of Postgress?) > >Thanks in Advance, > >Kp We've been using MySQL for over 8 months now on a FreeBSD 2.2-STABLE box. We love it. MySQL comes with the stuff to do perl access, but we've never used it yet. We use PHP (php.iquest.net and www.php.net) to do dynamic web pages on the fly based on queries to the database, it it has worked extremely well and reliably. As for ODBC access from an NT or Win95 box, that works well too. The ODBC drivers have sure made it easy to the database. As for mySQL performance, we've had no nproblems. I haven't run it against Postgress, so I don't know how it compares. MySQL is certainly superior to mSQL, at least the older mSQL version we were running before MySQL. Aaron out.