From mboxrd@z Thu Jan 1 00:00:00 1970 Received: (from majordomo@localhost) by pauillac.inria.fr (8.7.6/8.7.3) id JAA00655; Fri, 30 Jan 2004 09:21:38 +0100 (MET) X-Authentication-Warning: pauillac.inria.fr: majordomo set sender to owner-caml-list@pauillac.inria.fr using -f Received: from concorde.inria.fr (concorde.inria.fr [192.93.2.39]) by pauillac.inria.fr (8.7.6/8.7.3) with ESMTP id JAA00367 for ; Fri, 30 Jan 2004 09:21:37 +0100 (MET) Received: from mg.ihep.su (mg.ihep.su [194.190.161.38]) by concorde.inria.fr (8.11.1/8.11.1) with ESMTP id i0U8LaP07503 for ; Fri, 30 Jan 2004 09:21:36 +0100 (MET) Received: by mg.ihep.su (Postfix, from userid 65436) id 3C6E8B56A1; Fri, 30 Jan 2004 11:21:35 +0300 (MSK) Received: from mg.ihep.su (localhost [127.0.0.1]) by mg.ihep.su (Postfix) with SMTP id A81C7BC509; Fri, 30 Jan 2004 11:21:34 +0300 (MSK) X-Mailbox-Line: From vsl@ontil.ihep.su Fri Jan 30 11:21:34 2004 Received: from ontil.ihep.su (ontil.ihep.su [194.190.161.63]) by mg.ihep.su (Postfix) with ESMTP id 107CEB56A1; Fri, 30 Jan 2004 11:21:33 +0300 (MSK) Received: by ontil.ihep.su (Postfix, from userid 1001) id 26DD5FCC3; Fri, 30 Jan 2004 11:21:33 +0300 (MSK) Received: from localhost (localhost [127.0.0.1]) by ontil.ihep.su (Postfix) with ESMTP id 2315AFC2F; Fri, 30 Jan 2004 11:21:33 +0300 (MSK) Date: Fri, 30 Jan 2004 11:21:33 +0300 (MSK) From: Vitaly Lugovsky To: Josh Burdick Cc: Richard Jones , Inria Ocaml Mailing List Subject: Re: [Caml-list] PostgreSQL-OCaml 1.0.1 In-Reply-To: <4019F0B1.6050204@gradient.cis.upenn.edu> Message-ID: References: <20040128232131.GA22126@fichte.ai.univie.ac.at> <20040129200653.GA14321@redhat.com> <4019F0B1.6050204@gradient.cis.upenn.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=2.8 required=5.0 tests=IN_REP_TO,QL_SENT_FROM_MY_DOMAINS version=2.20 X-Spam-Level: ** X-Loop: caml-list@inria.fr X-Spam: no; 0.00; vitaly:01 lugovsky:01 ontil:01 ihep:01 caml-list:01 1.0.1:01 dbi:99 abstraction:01 ocaml:01 ocaml:01 interfaces:01 overhead:03 wrote:03 btw:03 differences:04 Sender: owner-caml-list@pauillac.inria.fr Precedence: bulk On Fri, 30 Jan 2004, Josh Burdick wrote: > If there's going to be a "new improved version", I think > maybe it should work with multiple databases. ODBC, JDBC, and > DBI all attempt this. It was already discussed here. The conclusion was: BAD IDEA. No way to work efficiently with different DBs using the same approach. Btw., I don't have any problems providing support for MySQL, PostgreSQL and Oracle from one OCaml application - but the abstraction is on a higher level then JDBC-like interfaces provides. > "select * from customers"-type queries, against any database, > without totally re-working your OCaml code. No way. Too much differences in the way how DBs returns the query results (e.g., consider the postgresql asyncronous messages). More layers converting values would just give much more overhead, without any significiant advantages. ------------------- To unsubscribe, mail caml-list-request@inria.fr Archives: http://caml.inria.fr Bug reports: http://caml.inria.fr/bin/caml-bugs FAQ: http://caml.inria.fr/FAQ/ Beginner's list: http://groups.yahoo.com/group/ocaml_beginners