Hi Mathias, If you will look at the number of views of this post you will see that there is massive interest in MySQL. This is for a number of reasons. One is a lot of hosters support only MySQL. Another is that many people have come to use only MySQL for their applications because in part to the first reason. And many of us have taken to doing our own hosting and running big replcation arrays and sql proxy servers to split data traffic. All of this I cannot do with postgresql. Yes, postgresql is a fine database as far as just a single database. But if you need to scale up it does not have the ability to do this as easily as other databases like MySQL. I've looked at some of the replication methods for postgresql and they have many well-known problems and are no where near what MySQL offers not to mention that they have nothing comparable to MySQL Proxy Server. After I posted in this thread I began to think about the whole issue and created another thread about TinyERP and ADOdb: http://tinyerp.org/forum/topic4545.html . I even spent some time and put together some example code that illustrates how to have a single code base support many databases. Allowing TinyERP to run on bigger more scalable databases will let TinyERP grow with any fast-growing company and will give business owners a comfort level that they do not have to worry about outgrowing TinyERP. Also, if you expect TinyERP to be used for serious business and not just by hobbyists then it needs to run on multiple databases so that it can fit into existing data infrastructures within existing businesses.
Gerry _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
