Monday, August 12, 2013

Some good SQL tips

Two very nice articles on SQL tips for Java developers, or anyone who uses SQL, really: 

10 Common Mistakes Java Developers Make When Writing SQL

10 More Common Mistakes Java Developers Make When Writing SQL 

In Part 2, one tip is always to use ANSI joins. I tend to agree, but I just want to note that I have run into situations where the "old style" was required by Oracle. Maybe someone can correct me if this doesn't apply anymore, but back about 7 years ago when I really dug into materialized views, I found that query rewrite required the older syntax. Always thought that was a bit odd.

Tuesday, August 06, 2013

The world's most [x] open source database.

I'm working with both Postgres and MySQL at the moment, so I have documentation pages open for each. I just randomly noticed how similar their respective slogans are.

Postgres: "The world's most advanced open source database."
MySQL:  "The world's most popular open source database."

Telling, isn't it? :)