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 SAA24872; Wed, 16 Apr 2003 18:00:20 +0200 (MET DST) X-Authentication-Warning: pauillac.inria.fr: majordomo set sender to owner-caml-list@pauillac.inria.fr using -f Received: (from xleroy@localhost) by pauillac.inria.fr (8.7.6/8.7.3) id SAA25245 for caml-list@pauillac.inria.fr; Wed, 16 Apr 2003 18:00:19 +0200 (MET DST) 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 OAA12299 for ; Sun, 13 Apr 2003 14:23:11 +0200 (MET DST) Received: from mailgate.rz.uni-karlsruhe.de (mailgate.rz.uni-karlsruhe.de [129.13.64.97]) by concorde.inria.fr (8.11.1/8.11.1) with ESMTP id h3DCNBX26428 for ; Sun, 13 Apr 2003 14:23:11 +0200 (MET DST) Received: from rzstud4.stud.uni-karlsruhe.de (exim@rzstud4.stud.uni-karlsruhe.de [193.196.41.36]) by mailgate.rz.uni-karlsruhe.de with esmtp (Exim 3.36 #1) id 194gVr-0002fz-00; Sun, 13 Apr 2003 14:23:11 +0200 Received: from uu9r by rzstud4.stud.uni-karlsruhe.de with local (Exim 3.36 #1) id 194gVq-0006sS-00 for caml-list@inria.fr; Sun, 13 Apr 2003 14:23:10 +0200 Date: Sun, 13 Apr 2003 14:23:10 +0200 From: Michael Neumann To: caml-list@inria.fr Subject: Re: DBI (was : [Caml-list] sybase interface?) Message-ID: <20030413122310.GA23723@rz.uni-karlsruhe.de> Mail-Followup-To: Michael Neumann , caml-list@inria.fr References: <200304091535.10307.mwohlwend@web.de> <20030411.191844.43121468.debian00@tiscali.be> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4i X-Spam: no; 0.00; stud:99 dbi:99 caml-list:01 sybase:99 vitaly:01 lugovsky:01 troestler:01 postgres:01 sourceforge:01 python's:01 api:01 apis:01 generic:01 ate:99 pragmatic:01 X-Spam: no; 0.00; stud:99 dbi:99 caml-list:01 sybase:99 vitaly:01 lugovsky:01 troestler:01 postgres:01 sourceforge:01 python's:01 api:01 apis:01 generic:01 ate:99 pragmatic:01 Sender: owner-caml-list@pauillac.inria.fr Precedence: bulk Vitaly Lugovsky wrote: > On Fri, 11 Apr 2003, Christophe TROESTLER wrote: > > > A while ago, it was said on this list that a common database > > interface > > (? la Perl DBI) would be nice. > > Nice? May be. But impossible. E.g., for Oracle you have to use > prepared statements with variables substitution, when in > Postgres there is no need to mess with this stuff - performance > is good enough if you create a new statement for every request. > > Postgres have asyncronous messages. OCI don't. Other database > interfaces could be even more different... IMHO many people just want to issue their SQL commands and get back the resulting rows, without writing too much code. And they don't use many of the special features, like asynchronous messages etc. If someone want's to start a DBI-like interface, please also have a look at Ruby/DBI (I'm the creator of it). http://ruby-dbi.sf.net And it's DBI specification: http://ruby-dbi.sourceforge.net/DBI_SPEC.html Also take a look at Python's DB API. > > Are there people interested on this list? Personally I don't > > have Even if I'm not a OCaml guy, I'd like to help with the interface as much as I can. > > much time to contribute but as I will be soon in need of using > > DB, I > > am willing to make an effort. > > I have no problems in using two quite different APIs in a > mid-layer - Oracle and Postgres. And I don't think I'll ever will > try to use any kind of generic interface. I ate this shit with > JDBC, and I don't want it any more... You can't compare JDBC with DBI. DBI is a very pragmatic approach to a database interface, without much overhead (in terms of additional code), whereas JDBC doesn't help write less code. I don't like to read hundreds of pages, before I can issue a simple SQL statement. With DBI, it's just 5 lines of code. Regards, Michael ------------------- 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