PostgreSQL to MySQL

Discussion for TimeTrex open source community developers.
Locked
oscar13
Posts: 1
Joined: Tue Nov 17, 2009 5:20 pm

PostgreSQL to MySQL

Post by oscar13 »

Guys,

My platform is Ubuntu 9.10, and I ran the "TimeTrex_Standard...bin" file using the express install.
My group started using the product with excitement then I noticed others using MySQL (my choice DB).
I scoured the forum until I found out how to setup MySQL by using the .ZIP install (wish I had found that earlier).

M Question:
Is it possible to export the TimeTrex PostgreSQL database to MySQL database?

If so, how do I go about that?

Please point to docs if available.

Thanks.

-obj
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: PostgreSQL to MySQL

Post by shaunw »

There isn't anyway to switch from PostgreSQL to MySQL without great difficulty, nor would we recommend doing it. While TimeTrex supports MySQL, there is a reason why PostgreSQL is the default database in our automated installers, its faster, offers more features, more stable and much more robust. MySQL doesn't offer a single technical advantage over PostgreSQL, yet it offers many disadvantages.

MySQL accounts for a tiny percentage of the overall installs of TimeTrex, yet it accounts for over half of the database related issues. In fact our forum search engine won't even let you search for just "mysql" because it returns too many results, while PostgreSQL only returns about 130.
Locked