PostgreSQL vs MySQL

PostgreSQL vs MySQL

Post by s » Thu, 25 Mar 2010 17:33:01


PostgreSQL, labelled object-relational database, is it a better alternative
to MySQL ?

I think the question should be asked here.
 
 
 

PostgreSQL vs MySQL

Post by Sm9oYW5uZX » Thu, 25 Mar 2010 18:16:47

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Hello,

I think there is no need of another discussuion about this.
Just read the follow web page:

http://www.yqcomputer.com/

regards,
johannes keler
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)

iEYEARECAAYFAkup2H8ACgkQE++2Zdc7EtfMyACeNQC6qYRXD7Th5cQFt+OQTgvQ
0r0AoJI1CQRbzmaLveqg76UUpnyAyuXV
=ibfH
-----END PGP SIGNATURE-----

 
 
 

PostgreSQL vs MySQL

Post by s » Thu, 25 Mar 2010 19:26:10


Thanks for the info (just never crossed my mind such comparison is
available).
 
 
 

PostgreSQL vs MySQL

Post by zapho » Thu, 25 Mar 2010 22:55:15


I used MySQL for everything for a long time but the landscape has changed in recent years. The 2 factors moving me towards PostgreSQL are:

1. MySQL fragmentation. Sun's acquisition of MySQL and it's subsequent acquisition my Oracle have left the MySQL community fragmented with various forks only muddying the water still further. One has to question Oracle's incentive to commit to improving a product which competes with the periphery of its existing customer base.

2. Too many backends. MySQL's pluggable architecture creates too much choice which dilutes standardisation. If you're writing a book about MySQL do you now have to write a chapter for each backend to account for all the subtle differences? Mixing MyISAM and InnoDB tables within the same schema has always seemed hackish to me.

In contrast PostgreSQL has a stable community, an uncomplicated roadmap and a standard approach to transactions and referential integrity.

zaphod