Maybe a middle-ware layer and just re-route your connection to pgsql? This does support query modification: http://code.google.com/p/proximo/
On Thu, Feb 21, 2013 at 9:01 AM, Steve Alligood <[email protected]>wrote: > the issue is not the mysql versus postgres DBD, it is what they wrote the > sql to be. > > If a product only supports mysql, it will often use mysql proprietary > syntax that will not work in postgres. > > -Steve > > > On Feb 21, 2013, at 7:44 AM, Jason Hall wrote: > > > Well, if you are just using the DBI, then you just change your connect > > string and everything else works. Nobody should be using just a straight > > DBD itself. > > > > On Thu, Feb 21, 2013 at 1:41 AM, Grant Shipley <[email protected]> > wrote: > > > >> Being a non perl developer, I would assume they have an ORM library you > >> could use. > >> > >> -- > >> gs > >> > >> On Feb 21, 2013, at 7:58 AM, DANIEL DAVID EGLI <[email protected]> > >> wrote: > >> > >>> *Does anyone know of a (hacked?) Perl DBD driver that reroutes mysql > >> calls > >>> to pgsql calls? I'm in process of designing a web site that will rely > >>> heavily on postgresql, but I also need to incorporate bugzilla which, > >> last > >>> I looked, relies exclusively on mysql. I'd rather not go through the > >> hassle > >>> of having two different database engines running on the same machine. > So > >> I > >>> figured I'd look into ways of tricking (for lack of a better term) > >> bugzilla > >>> to work on pgsql. Obviously the first method is to rewrite all the > >> bugzilla > >>> files. But that's a LOT of files. I figured it would be a heck of a lot > >>> less work to have a fake DBD::MySQL that in turn calls the function > calls > >>> of DBD::PGSQL for each of it's functions. If anyone knows of a site I > >> could > >>> download such a Perl driver for, I'd be grateful. Or a site where I > could > >>> download a Bugzilla that is already converted to PostgreSQL would be > good > >>> too.* > >>> > >>> * * > >>> > >>> *Thanks!* > >>> > >>> * * > >>> > >>> *--- Dan* > >>> > >>> /* > >>> PLUG: http://plug.org, #utah on irc.freenode.net > >>> Unsubscribe: http://plug.org/mailman/options/plug > >>> Don't fear the penguin. > >>> */ > >> > >> /* > >> PLUG: http://plug.org, #utah on irc.freenode.net > >> Unsubscribe: http://plug.org/mailman/options/plug > >> Don't fear the penguin. > >> */ > >> > > > > > > > > -- > > Jayce^ > > > > Preparing Deseret - UtahPreppers > > ΜΟΛΩΝ ΛΑΒΕ > > > > /* > > PLUG: http://plug.org, #utah on irc.freenode.net > > Unsubscribe: http://plug.org/mailman/options/plug > > Don't fear the penguin. > > */ > > > > /* > PLUG: http://plug.org, #utah on irc.freenode.net > Unsubscribe: http://plug.org/mailman/options/plug > Don't fear the penguin. > */ > -- -- -- Matthew Frederico /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
