DB Abstraction
Posted: 28 Feb 2005, 17:16
How close is this to happening as a road map completion for version 1.0?
I saw you were using adodb which, in theory, should allow Mantis to be ported to use all the databases listed http://phplens.com/adodb/supported.databases.html.
The only hangup I would see is that the SQL is mangled in with the code and thus could prevent abstraction due to slight variations of SQL implementations and/or binding. There are some ADOdb port tips located at http://phplens.com/lens/adodb/tips_portable_sql.htm including "SQL as a Localization Exercise".
My main issue is having to run MySQL just for Mantis as all my other databases are either PostgreSQL or Oracle9i. I wouldn't mind working on the PostgreSQL, SQLite and Oracle 9i (for work) SQL compliance.
It looks like this was attempted before as db_generate.sql for 0.9.12 is actually "mysql.sql" and mssql.sql / pgsql.sql haven't been touched since Mar 4 2004.
Finally, I evaluated several open BT systems and chose Mantis for our system of tracking bugs. We are using this for a major internal telecommunications J2EE project with developers both in the US and India. It is very important to get this working with one of the corporate Oracle servers. Thanks for all the hard work thus far and am waiting for the opportunity to help add this additional functionality.
John 'zariok' Draughn
I saw you were using adodb which, in theory, should allow Mantis to be ported to use all the databases listed http://phplens.com/adodb/supported.databases.html.
The only hangup I would see is that the SQL is mangled in with the code and thus could prevent abstraction due to slight variations of SQL implementations and/or binding. There are some ADOdb port tips located at http://phplens.com/lens/adodb/tips_portable_sql.htm including "SQL as a Localization Exercise".
My main issue is having to run MySQL just for Mantis as all my other databases are either PostgreSQL or Oracle9i. I wouldn't mind working on the PostgreSQL, SQLite and Oracle 9i (for work) SQL compliance.
It looks like this was attempted before as db_generate.sql for 0.9.12 is actually "mysql.sql" and mssql.sql / pgsql.sql haven't been touched since Mar 4 2004.
Finally, I evaluated several open BT systems and chose Mantis for our system of tracking bugs. We are using this for a major internal telecommunications J2EE project with developers both in the US and India. It is very important to get this working with one of the corporate Oracle servers. Thanks for all the hard work thus far and am waiting for the opportunity to help add this additional functionality.
John 'zariok' Draughn