tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: PostgreSQL vs MySQL with Tomcat
Date Thu, 15 Jan 2009 23:30:08 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jonathan,

Jonathan Mast wrote:
> * Postgre has more features (sequences and triggers) but also an enormous
> amount of complexity
> * MySQL has much finer authorization control, but lacks some of the big-boy
> features such as triggers
> ** of course a lot has changed in the newer versions of both of these DBMS

N.B. MySQL does have triggers in MySQL 5.0.2 and upward. A sequence can
be implemented using a table with a single AUTOINCREMENT field. Kind of
a hack, but if you /require/ Oracle-style sequence behavior, you can get it.

I totally agree that some "big boy features" seem to be missing from
MySQL. Over the years, they have played quite a good game of catch-up.

- -chris

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAklvxvgACgkQ9CaO5/Lv0PBmxwCfWDH0u/pU4JhsRICqhs0UCgZR
vq4AnRN1oJVRiIwcX05efqqtQUfEMz+o
=vHzs
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message