Developer Forum

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

I think the question should be asked here.

-----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-----

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

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