I'm quite new to mantis, but i've been on #mantishelp channel on irc
since few days. My company is starting to use Mantis for its own
development department (around 20 projects).
I really like Mantis for its simple (though informative) look, so i
wanted to help a bit
The biggest discussion was getting Mantis to work on many databases ,
and few solutions were coming out : AdoDB and Pear::DB were some
technologies that could be adopted.
Between the two, I would personnaly prefer PEAR::DB, as it's not so huge
in size and above all is going to be included in standard php distribs.
As a proof is better than a long discussion, i have taken the first step
to Pear::dB adoption, that is a simple port. The file attached
transforms the wrappers from using mysql php extension to use the pear
extension. Simple replace the old core_database_API.php file with that
new one, and it should work fine.
Next step would be to solve sql queries incompatibilities between
servers (such as LAST_INBSERT_ID thing, which is local to MySQL, and can
be converted to sequences thorugh peardb (where mysql sequences are
emulated, and supported natively on other platforms)), but it's maybe
the step coming next.
Best regards, and keep up good work on such good ideas