[Vtigercrm-developers] Using a Database

[Dirk Gorny]

Hallo developer,

Using a Database in basic is very easy. If you do only simpel update, select, 
and create , you can use the same sql syntax at nearly all DBMS.
Is an application becommes more power, you nead more complexibility in querys. 
Querys then are not portable.
In former times brainpower was inside the Database presented by normalizing 
and ER-Models.
Something like php or oracle forms, was only for representation.
Today the intelligence is inside the appication. The  choice of a DBMS is not 
a choice for building the models it is to choose the features brought to you 
by the DBMS.
Today mysql is supported and there are "ports" to postges. In future there are 
things to handle like trigger events and do filtering by stored procedures. 
This are only two weaks of a big list where mysql doesn't shine very bright. 
Sometimes it is easyer to get mony out of an Casino then get a dump from myql 
especial with BLOBS.
Allso there is more nead to do other things like suport two DBMS.
Therefore i suggest to build a migration tool to transport the data to a 
postgres database and switch vtiger to postgres as the standard.

Best regards,

Dirk