From owner-freebsd-questions Tue Feb 25 8:12:57 2003 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 6919D37B401 for ; Tue, 25 Feb 2003 08:12:56 -0800 (PST) Received: from mired.org (ip68-97-54-220.ok.ok.cox.net [68.97.54.220]) by mx1.FreeBSD.org (Postfix) with SMTP id BA50943FAF for ; Tue, 25 Feb 2003 08:12:53 -0800 (PST) (envelope-from mwm-dated-1046621573.b13c3d@mired.org) Received: (qmail 16814 invoked from network); 25 Feb 2003 16:12:53 -0000 Received: from localhost.mired.org (HELO guru.mired.org) (127.0.0.1) by localhost.mired.org with SMTP; 25 Feb 2003 16:12:53 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15963.38404.257921.610622@guru.mired.org> Date: Tue, 25 Feb 2003 10:12:52 -0600 To: Trent Nelson Cc: "Philip M. Gollucci" , synrat , questions@freebsd.org Subject: Re: Oracle on FreeBSD In-Reply-To: <20030225091453.GB70361@limekiln.vcisp.net> References: <1046128729.490.8.camel@dethstar> <200302242321.04463.philip@p6m7g8.com> <20030225091453.GB70361@limekiln.vcisp.net> X-Mailer: VM 7.07 under 21.1 (patch 14) "Cuyahoga Valley" XEmacs Lucid X-face: "5Mnwy%?j>IIV\)A=):rjWL~NB2aH[}Yq8Z=u~vJ`"(,&SiLvbbz2W`; h9L,Yg`+vb1>RG% *h+%X^n0EZd>TM8_IB;a8F?(Fb"lw'IgCoyM.[Lg#r\ From: Mike Meyer X-Delivery-Agent: TMDA/0.70 (Pensive) Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG In <20030225091453.GB70361@limekiln.vcisp.net>, Trent Nelson typed: > I'm interested in seeing how well something like PostgreSQL can be > used as a ``drop-in'' replacement for Oracle. If I have clients > connecting via ODBC (Rational ClearQuest), I personally couldn't > care what the underlying database is. Now *that* is something I'd > be interested in seeing a write up for. It's not a drop-in replacement. You have to install the PostgreSQL ODBC drivers on all the clients. Any client-side scripts will have to be changed to use a PostgreSQL wrappers instead of Oracle wrappers. The SQL is probably subtly different as well. SQL may be a standard, but you still get locked into the databases that you can query with it. http://www.mired.org/consulting.html Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message