Re: Re: Re: Why PostgreSQL is not that popular as My

----- Original Message -----
From: "Robert D. Nelson" <RDNELSON@co.centre.pa.us>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Matthew" <matt@ctlno.com>; "pgsql-general"
<pgsql-general@postgresql.org>
Sent: Monday, December 11, 2000 3:23 PM
Subject: RE: [GENERAL] Re: Re: Why PostgreSQL is not that popular as My


>
> my2post anybody?
>
> Considering all the apps that have mysql code or mysql/php code in them,
> something that would go thru and fix code that wouldn't work, but wouldn't
> optimize either, and alert to code that doesn't have functional
equivalents
> that points to a FAQ they can look at or submit questions to, now that I'd
> love.

What I've done for my last couple of PHP/db projects is hack a little perl
script that generates SQL and PHP code to build data structures. That way
you just tag a field as indexed/unique and type phonenum and let the script
generate for the target db/lang.

At the moment, of course, too much tends to be hardwired :-(

Should be expanded and turned into a proper open-source package really -
there are plenty of people who try to support a lot of databases (twig
springs to mind). Haven't really got the round tuits at present, but if
anyone wants the code they're welcome to it.

- Richard Huxton