Make the installer MySQL independent

[NilsLindenberg]

One step on the way to database abstraction is the necessity to make the installer less mySQL dependent. This means:

- renaming the config entries from mysql_host etc. to something like dbms_host (DBMS = Database management system) and add an entry dbms_name

- moving the sql-queries from the installer somewhere like mysql_install.sql (similar for upgrades).

- changing the description of the database config and add the possibility to choose a DBMS, even if the only entry for now is mysql.

Related tickets

• #90 - MySQL 5+ issue: mysql_* vs. mysqli_*
• #978 - Proposal for using PDO

Related links

•  http://wikkawiki.org/DatabaseAbstraction (ADODB)

[BrianKoontz]

I agree, the current setup should be DB-agnostic in the event support is provided for other DBes in the future. Bumped to milestone 1.2 for further discussion.

[AndreasHeintze]

As I said before, please try out the ezSQL database abstraction, it's fantastic great! Check it out here:  http://www.jvmultimedia.com/portal/node/6

[GeorgePetsagourakis]

All these where great 3 years ago. Nowadays PDO is the way to go.