No worry on choice of database since I can only use MySQL since it's already set-up by DBA and unlikely I can request any other database.

That does not stop me from strongly recommending PostgreSQL instead of MySQL and its forks. *SCNR* ;-)

I've explained the reasons elsewhere:

• Re^2: What is your favourite Linux or cross-platform database?
• Re^2: Perl and Database
• Re^2: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?

Alexander