[wp-hackers] PostgreSQL port status?

[Tom Barta]

On 10/2/07, Leonid Mamchenkov <leonid at mamchenkov.net> wrote:
> On 10/2/07, usleepless at gmail.com <usleepless at gmail.com> wrote:
> > But as Tom pointed out, (reserverd) keywords are ... well ... kind of
> > reserved. Don't use them as identifiers.
>
> I guess there is an added benefit of forward compatibility in escaping
> fields and table names.  Words which are not reserved now can become
> so in the future.

Ok, so there's at least two options:
 1) Use backticks to escape tables and fields.  This future-proofs
against MySQL reserved keyword changes (how frequently does that
happen?).  It also makes it harder to  use /any other database/ with
Wordpress.
 2) Use non-reserved tables and fields.  If a new version of MySQL
comes out that adds an inconvenient reserved word, then the first
version of WP needs to add backticks or provide a DB upgrade path with
a field rename.

How frequently is a new version of MySQL expected to add keywords that
collide with the WP schema?  It seems to me like this is something
that deliberately hurts any future for cross-platform WP support
(which is an issue that comes up frequently, so it is a real issue for
some people) to avoid a slim chance that some future version of MySQL
will change things.  Just because WP is only targetted towards MySQL
doesn't mean that it should go out of its way to entrench itself in
MySQL for (what I view as) a questionable benefit.

-- 
Tom