Thread: RE: Re: Re: Why PostgreSQL is not that popular as My
>"Brett W. McCoy" <bmccoy@chapelperilous.net> writes: >> On Sun, 10 Dec 2000, Matthew wrote: >>> [Matthew] Would it make sense for postgre to have a mysql >>> compatibility module? An add on package (perhaps in contrib) that >>> would add many of the functions that mysql has that postgre does not. > >> I think it would be wasted effort. I would rather the developers focus on >> PostgreSQL, not MySQL, or Access, or whatever. > >I agree that the key developers shouldn't spend much time on such a >thing, but on the other hand this isn't a project that requires a key >developer to get done. If Matthew or someone else feels like spending >time on it, I wouldn't object... 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. Rob Nelson rdnelson@co.centre.pa.us
----- 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