It's a rewrite of an app I did awhile ago in php.
I think the biggest gripe I've had with mysql is the problem where I was
violating a unique constraint and it was giving me some generic (completely
useless) error; HY001 I think.
In various ways, which I can't articulate, MySQL just feels to me more
amateurish compared to PostgreSQL. With MySQL things are changed on an
apparently ad-hoc basis and I've heard that they've broken backwards
compatibility more than once.
I realize that SQL isn't exactly the most widely adhered to standard, but MySQL
seems to be more divergent than [most of] the others. When I had that
HYwhatever error, I was completely stumped, so in order to troubleshoot it I
copied the database to an MS SQL Server that I'd been using for something else.
I remember having read somewhere that SQL Server is reasonably close to the SQL
standard and I was amazed at how much work it took to translate my ddl and sql
from MySQL to SQL Server. (Apache DdlUtils and Hibernate could have helped
with the ddl.)
I can't remember all of the various problems I've had with MySQL but here's one
that seems typical; I started using it back when it was (or at least it seemed
to me) more typical to edit user permissions by updating the mysql.users table,
rather than using the GRANT command. So I have these various sql files that
insert stuff in the mysql.users, mysql.db, and mysql.hosts tables and they
have lots of 'y' and 'n' entries. At some point they changed things and they
had to be uppercase. Previously I think they converted them to Y and N, but
suddenly a newer version accepted the lower case with no complaints but didn't
convert them, and they didn't work (it was as if the ys were Ns); I could have
been inserting any random letter or digit apparently. That took some head
scratching to figure out.
I had forgotten that Sun bought MySQL so it should be interesting to see how
that plays out. I heard that they're doing a major rewrite, starting from
scratch, but going to keep it backwards compatible.
Christopher Schultz wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Rusty,
Rusty Wright wrote:
I'm in the process of migrating a MySQL database to PostgrSQL.
Is this to cool-off your DBA's ears? ;)
Seriously, if you could explain why you've decided to switch, I think it
would help a lot of readers understand some of the differences between
these two RDBMSs.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAklyBnIACgkQ9CaO5/Lv0PCuvgCfdZ9j+2Z5cGuk3aQsYFg7VaAO
msIAnR8r+ZmyYeJz2T3Sbzbk9hCEDGlU
=26DN
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
