pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Crawford <scrawford@pinpointresearch.com>
To: Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL standards in Mysql
Date: Wed, 27 Feb 2008 10:31:32 -0800
Message-ID: <47C5AC84.1020205@pinpointresearch.com> (raw)
In-Reply-To: <47BF794C.1030004@ultimeth.com>
References: <47BF1B32.2050800@kensystem.com>
	<20080222195720.GL9392@alvh.no-ip.org>
	<dcc563d10802221613s79f9967foa1c0540db9c5b7af@mail.gmail.com>
	<47BF794C.1030004@ultimeth.com>

Dean Gibson (DB Administrator) wrote:
> ...For example, I think phpBB is the only major message board software 
> that supports PostgreSQL (see 
> http://www.phpbb.com/about/features/compare.php ), and in fact has for 
> some time.  Of course, they have a DB abstraction layer (wow, what an 
> concept!), which allows them to easily support a number of DBs.  Of 
> course, what does that tell you about the level of design and 
> professionalism of phpBB versus the others?...

In most cases it tells me is that the developers are willing to limit 
themselves to the lowest-common-denominator of features among the 
supported databases in exchange for the ability to run on a variety of 
backends. This is a perfectly legitimate decision for products where 
only basic database features are necessary.

What I find scary is complex products that have been "ported" from 
something like mySQL to PostgreSQL. This often means that the product 
has severely limited its use of appropriate PostgreSQL features in order 
to remain compatible with the other backends.

Cheers,
Steve




view thread (9+ messages)

Message-ID: <47C5AC84.1020205@pinpointresearch.com>
Permalink:  ../47C5AC84.1020205@pinpointresearch.com/
Also on:    postgresql.org/message-id/47C5AC84.1020205@pinpointresearch.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: scrawford@pinpointresearch.com, postgresql@ultimeth.com
  Subject: Re: SQL standards in Mysql
  In-Reply-To: <47C5AC84.1020205@pinpointresearch.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox