subject: mysql to pgsql Perl DBD shortcut

Michael Torrie torriem at gmail.com
Thu Feb 21 11:16:04 MST 2013


On 02/21/2013 10:44 AM, Paul Seamons wrote:
> Steve is right on here.  I doubt bugzilla is using an ORM - if they had 
> you could swap out db backends.  They are likely using straight DBI.  In 
> that case *most* stuff should just work cross db, but things like my $id 
> = $dbh->{'mysql_insertid'} are not going to fly.  Only way to fix that 
> is to hack up the driver to catch access to that key.  I don't think it 
> would be too much work for this this particular one.  But if there are 
> other mysql specific syntax pieces you are hosed.  I doubt bugzilla does 
> to much table creation - or if they do you could just hijack that step.

>From what I read in the docs, buzilla supports MySQL, PostgreSQL,
SQLite, and Oracle out of the box.  So they are definitely using an
abstraction layer.


More information about the PLUG mailing list