Date: Wed, 19 Aug 1998 20:59:58 -0700 From: Josef Grosch <jgrosch@mooseriver.com> To: David Hawkins <dhawk@river.org>, isp@FreeBSD.ORG Subject: Re: FreeBSD and Oracle Message-ID: <19980819205958.C17826@mooseriver.com> In-Reply-To: <199808200255.TAA25029@ohio.river.org>; from David Hawkins on Wed, Aug 19, 1998 at 07:55:50PM -0700 References: <199808200255.TAA25029@ohio.river.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Aug 19, 1998 at 07:55:50PM -0700, David Hawkins wrote: > > already exists. The only problem is I don't know if Oracle has a version > > out for FreeBSD yet. > > I don't think they do. That leaves you with a couple of options: > > 1. Run the Oracle SQL server on another Unix machine (Sun, HP, AIX, > etc.) and have the CGI scripts send queries/updates/reads to that port > on the other machine. If you want to use Intel hardware then check > Solaris and see if Oracle/Sybase/Informix have a Solaris 86 port. > True, it's not FreeBSD, but for that ... > There is a Linux port of Informix which can be downloaded now. I have just started to play with it so I can't form an opinion yet. The Linux port of Oracle is due out at "the end of the year". It is possible to get the SCO version of Oracle running on FreeBSD but the installation is vile. > 2. Use a SQL server in the ports collection. You can go ahead and > download one and play with it -- it's not going to be much different > going to one of the big name SQL servers later if you need to. > I believe Best uses msql on their FreeBSD machines. Taking a look in > /usr/ports/databases: > Makefile msql p5-Msql postgresql xmysql > cdb mysql p5-Mysql py-PyGreSQL xmysqladmin > db p5-DBD-Pg p5-Pg tkgnats > gdbm p5-DBI pgaccess typhoon > gnats p5-MLDBM pkg xmbase-grok > > Personally I'd use postgres if I was doing this on FreeBSD. > Once you know SQL (updates, queries, bulk copies, etc.) it's > fairly easy to move to a different SQL server later if you need to. > I use MySQL. It's pretty good but it is not fully ANSI SQL complient. The big things missing are; Triggers, Stored Procedures, Rollbacks, Transactions, and Select Into's. > > Disclaimer: Yes, I work for Sybase. But use Oracle if you want to. > I just don't think it works on FreeBSD -- yet. Maybe you should a bug in your bosses ear about a port to either Linux or FreeBSD ;-) Josef -- Josef Grosch | Another day closer to a | FreeBSD 2.2.7 jgrosch@MooseRiver.com | Micro$oft free world | UNIX for the masses To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?19980819205958.C17826>