>I realize that SQL isn't exactly the most widely adhered to standard Perhaps!
But then again before the new ANSI SQL standard (particularly the ANSI SQL/92 join syntax changes) this was far worse, MS-SQL 6.5 and Oracle (SQL/86 standard) were horrendous and migrating was not fun, these days though Microsoft's T-SQL, Postgres, and ORACLE all use a very similar dialect, the only really major difference I can think of is T-SQL stored procedures, which have no counterpart in Postgres. In my modest experience though I have noticed the MySQL SQL dialect appears to be less similar. Postgres, IMHO, was held back for many years by not having a windows release version, but its super competitive now and a really rock solid database. There is nothing substantial missing from Postgres that the big (or should I say expensive) guns have. Its enterprise scale and has great tools and extensions (like Slony replication). I personally would not pay for a database when there is Postgres for free. Cheers Peter ----- Original Message ----- From: "Rusty Wright" <rusty.wri...@gmail.com> To: "Tomcat Users List" <users@tomcat.apache.org> Sent: Sunday, 18 January, 2009 08:09:54 GMT +02:00 Athens, Beirut, Bucharest, Istanbul Subject: Re: PostgreSQL vs MySQL with Tomcat 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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
