Re: PostgreSQL Object-Oriented Database?

From: Christophe <xof(at)thebuild(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Object-Oriented Database?
Date: 2009-04-27 14:54:28
Message-ID: C2710A16-DC09-4D38-B36B-ECA6EBA4CD7B@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 27, 2009, at 7:00 AM, Robert Pepersack wrote:
> My agency has a contractor that created a PostgreSQL database that
> he calls "object-oriented". I noticed that the contractor has more
> than one value in a column separated by commas. In the relational
> world, this obviously violates first normal form. When I asked
> about it, he said that it's because PostgreSQL is an "object-
> oriented database". I'm very skeptical.

Without knowing the details of the design, it's hard to comment on the
design's strengths or weaknesses. However, there is nothing about
PostgreSQL that requires any different design than one would use on
any relational database.

Arrays are, sometimes, a good solution for particular problems, and
PostgreSQL has very fluent array functionality, but nothing about
PostgreSQL requires their use versus more traditional relational
designs.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2009-04-27 15:10:42 Re: Which header and lib files to use when compiling libpq-code?
Previous Message Kynn Jones 2009-04-27 14:51:45 Which header and lib files to use when compiling libpq-code?