From oracle-l-bounce@freelists.org Tue Apr 12 20:52:54 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3D1qrTl005047 for ; Tue, 12 Apr 2005 20:52:53 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3D1qkem005040 for ; Tue, 12 Apr 2005 20:52:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E0C84939EE; Tue, 12 Apr 2005 19:14:07 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09643-07; Tue, 12 Apr 2005 19:14:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 68C23939D6; Tue, 12 Apr 2005 19:14:07 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=d71w5Cn3Ukdz0BPszk6kfKXIwyXYi+AY6sSBzc6ywMSw9g2HxdSoyTEii8hei0j41XpMZtj44wFmS5ycpw2lKMXfVUoGV4IbCxGv05NooLLgQWmaXGMQXI8UfRxoeLfJ3s7nVVvnkWYqiNkYGjAjsn6B7X7G0dNuCiFWHmPCDwI= Message-ID: Date: Tue, 12 Apr 2005 17:11:41 -0700 From: Jared Still To: jonathan@gennick.com Subject: Re: Universal database interface? Cc: Oracle-L@freelists.org In-Reply-To: <54160938287.20050412102932@gennick.com> Mime-Version: 1.0 Content-type: text/plain References: <54160938287.20050412102932@gennick.com> Content-Transfer-Encoding: 8bit X-archive-position: 18407 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: On 4/12/05, Jonathan Gennick wrote:Here's an interesting proposition: http://www.oreillynet.com/pub > > /a/network/2005/04/11/rsdp.html > Some initial thoughts. He addresses many of the issues in the article, and then attempts to rationalize them: ---- "Many developers are happy to trade runtime performance for cross-platform portability." Maybe the developers are happy, because performance is the DBA's problem, right? ---- "One of the reviewers pointed out that XML-RPC is not a good way to deliver BLOBs. I was not thinking of BLOBs when I wrote this article (my habit has always been to use databases to point to other resources, and to store large files somewhere else). However, it will be possible to send them using Base64 encoding. It's not very efficient, but it will work. If you need to support BLOBs, RSDP may not be a very good way to do this." He may favor the practice of retrieving files from the filesystem, but it seems to me he is ignoring that this is much like his complaint with databases requiring different access methods. Which OS? Which file system? Good practice would dictate putting these in the database. ---- All the data is transported via xml. Better put in those better faster NIC's. ---- I can understand his pain in this matter, but I'm not sure this is the right way to go about mitigating it. No, I don't have a better idea. :) -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l