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.
Opinions, experiences and information about SQL and the databases that process it, from a guy who's been at it for over 20 years.
Monday, August 12, 2013
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? :)
Postgres: "The world's most advanced open source database."
MySQL: "The world's most popular open source database."
Telling, isn't it? :)
Subscribe to:
Posts (Atom)