399415 - Consider replacing Bugzilla::DB::Schema with SQL::Translator

Status: NEW

(Bugzilla :: Database, enhancement)

Description

[Max Kanat-Alexander]

There's a CPAN module called SQL::Translator that may do everything Bugzilla::DB::Schema does, and supports far more things. I just have to see if it can do everything we need, or if Bugzilla::DB::Schema should just become a subclass of SQL::Translator.

Comment 1

[Frédéric Buclin]

Still another Perl module. I don't think this one is useful. Moreover, its version is 0.08, probably meaning it's far from being complete and stable. AND FYI, it doesn't work with TT 2.15 and newer, see http://search.cpan.org/src/JROBINSON/SQL-Translator-0.08001/Changes, making it incompatible with 99% of Bugzilla installations.

Comment 2

[Max Kanat-Alexander]

(In reply to comment #1)
> Still another Perl module. I don't think this one is useful.

  It's extremely useful. It supports a bunch of backends that we don't support, and it generates CREATE TABLE and ALTER statements for them, which is exactly what Bugzilla::DB::Schema does.

> Moreover, its
> version is 0.08, probably meaning it's far from being complete and stable.

  No, untrue. It's used as a part of DBIx::Class in many Catalyst applications.

> AND
> FYI, it doesn't work with TT 2.15 and newer, see
> http://search.cpan.org/src/JROBINSON/SQL-Translator-0.08001/Changes, making it
> incompatible with 99% of Bugzilla installations.

  That can be fixed. This is an idea for the *future*. I also have to find out exactly what they mean by "doesn't work with TT 2.15 and newer".