subject: mysql to pgsql Perl DBD shortcut

Matthew Frederico mfrederico at gmail.com
Thu Feb 21 09:30:40 MST 2013


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 <steve at betterlinux.com>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 <gshipley at gmail.com>
> 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 <ddavidegli at gmail.com>
> >> 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


More information about the PLUG mailing list