subject: mysql to pgsql Perl DBD shortcut
steve at betterlinux.com
Thu Feb 21 09:01:05 MST 2013
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.
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.
>> On Feb 21, 2013, at 7:58 AM, DANIEL DAVID EGLI <ddavidegli at gmail.com>
>>> *Does anyone know of a (hacked?) Perl DBD driver that reroutes mysql
>>> 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,
>>> I looked, relies exclusively on mysql. I'd rather not go through the
>>> of having two different database engines running on the same machine. So
>>> figured I'd look into ways of tricking (for lack of a better term)
>>> to work on pgsql. Obviously the first method is to rewrite all the
>>> 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
>>> 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
>>> * *
>>> * *
>>> *--- 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.
> Preparing Deseret - UtahPreppers
> ΜΟΛΩΝ ΛΑΒΕ
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 4808 bytes
Desc: not available
Url : http://plug.org/pipermail/plug/attachments/20130221/f5873d2f/attachment-0001.bin
More information about the PLUG