Right,

I've got some time available during my work to put towards completing the db api patches from around the 17th March.

I'm going to be using this time to get the new db layer in MSSQL, PGSQL and MYSQL into a fully working and tested state.

I'd like some feedback/help on 7 things:

a) Would it be helpful/useful to add a SQLITE 'test' layer (that we can use for non-db specific tests for some edge cases maybe) if that would be useful - i.e. do we have a case where it would be useful to have a sqlite database with 10,000 projects in that we could use to test performance via phpunit of our api's without having to generate it into the various databases? Or do you guys feel it would be better not to do this - as we'd we better inserting 10,000 test projects into a {mysql|pgsql} database and doing it that way.

b) Do we want a sqlite option for mantis (with obvious drawbacks of why you wouldn't want to do this as an end user normally)?

[Regarding a+b, I already had a sqlite handler coded before for the sake of ease when trying to test other bits (as everything is basically a varchar in sqlite )]

c) DB2 - previously we've "supported" this platform. My understanding is it's possible to download a vm/free/evaluation version of DB2. Does anyone on the dev-team or this list have some pointers on this database engine? (It was either db2 or oracle that I managed to download and couldn't work out how to create a db!)

d) ORACLE - previously we've "supported" this platform. My understanding is it's possible to download a vm/free/evaluation version of DB2. Does anyone on the dev-team or this list have some pointers on this database engine? (It was either db2 or oracle that I managed to download and couldn't work out how to create a db!)

e) MYSQL - What is the minimum version that we want to support?

Current versions of mysql (there policy doesn't seem to be that clear) I think are 5.1, 5.5, 5.6

f) MSSQL - What is the minimum version that we want to support?

Current versions of MSSQL are:

SQL2005,
2008,
2008R2,
2012

g) PGSQL - What is the minimum version that we want to support?

Current versions of PGSQL are:

9.3.3 Feb. 20, 2014 Notes
9.2.7 Feb. 20, 2014 Notes
9.1.12 Feb. 20, 2014 Notes
9.0.16 Feb. 20, 2014 Notes
8.4.20 Feb. 20, 2014 Notes

8.4 Becomes END OF LIFE July 2014