From owner-freebsd-questions Tue Feb 25 10:44:34 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 77B4637B401 for ; Tue, 25 Feb 2003 10:44:33 -0800 (PST) Received: from netmail01.services.quay.plus.net (netmail01.services.quay.plus.net [212.159.14.219]) by mx1.FreeBSD.org (Postfix) with SMTP id 69DBC43F85 for ; Tue, 25 Feb 2003 10:44:32 -0800 (PST) (envelope-from trent@limekiln.vcisp.net) Received: (qmail 11340 invoked from network); 25 Feb 2003 18:44:31 -0000 Received: from limekiln.vcisp.net (212.159.16.110) by netmail01.services.quay.plus.net with SMTP; 25 Feb 2003 18:44:31 -0000 Received: by limekiln.vcisp.net (Postfix, from userid 1001) id C9F722DE; Tue, 25 Feb 2003 18:44:30 +0000 (GMT) Date: Tue, 25 Feb 2003 18:44:30 +0000 From: Trent Nelson To: Mike Meyer Cc: "Philip M. Gollucci" , synrat , questions@freebsd.org Subject: Re: Oracle on FreeBSD Message-ID: <20030225184430.GA73776@limekiln.vcisp.net> References: <1046128729.490.8.camel@dethstar> <200302242321.04463.philip@p6m7g8.com> <20030225091453.GB70361@limekiln.vcisp.net> <15963.38404.257921.610622@guru.mired.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <15963.38404.257921.610622@guru.mired.org> User-Agent: Mutt/1.5.1i 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 On Tue, Feb 25, 2003 at 10:12:52AM -0600, Mike Meyer wrote: > 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. Perhaps I should have been more specific. I'm interested in how far you can get (i.e. what queries will work, what ones won't) before you reach a complete road-block. With regards to ODBC, changing the driver being used by the application's '*odbc.ini' configuration fi- le is sufficient for modifying the database being interfaced to, is it not? i.e. the application simply calls standard ODBC functions which the individual database drivers implement. Trent. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message