X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0D7559FB249 for ; Thu, 17 Aug 2006 07:26:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11055-04 for ; Thu, 17 Aug 2006 07:26:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id BD6069F9EF3 for ; Thu, 17 Aug 2006 07:26:07 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GDfH5-0003Cs-8b for pgsql-sql@postgresql.org; Thu, 17 Aug 2006 06:38:55 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 315374172; Thu, 17 Aug 2006 06:26:00 -0400 (EDT) Date: Thu, 17 Aug 2006 06:26:00 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: OT: OpenDatabase Model ? Message-ID: <20060817102600.GA27495@phlogiston.dyndns.org> References: <44E343D6.1010906@solnet.homeip.net> <20060816190724.GE25228@phlogiston.dyndns.org> <44E37A1A.7080006@solnet.homeip.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44E37A1A.7080006@solnet.homeip.net> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.22 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/132 X-Sequence-Number: 26090 On Wed, Aug 16, 2006 at 10:03:38PM +0200, Jesper K. Pedersen wrote: > The opendatabase model actually offered a standard set of table > definitions covering a wide range of data storage. > > Of course this means that the tables would often have stuff you dont > need, and may not have the things you need, but at least there is a > common "thread" in how you different databases look. For the big company Ick. I confess my reaction is mostly aesthetic, but still. Why don't coding practices and column naming conventions get you this? That way, you can make your physical data model resemble your logical data model, rather than pounding with a big hammer on your logical model to make the physical storage you have fit? The database is not a filesystem. If you just need a filesystem and a SQL-like interface to it, use MySQL 3.x. A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner