Monthly Archives: May 2010

SQL Optimization: Union vs. Union All

Everyone should learn the difference between Union and Union All. Knowing it will make you a better programmer, and it’s fairly trivial to understand. SELECT * FROM apples UNION SELECT * FROM oranges When you know for a fact that there will never be any common rows between the apples table and the oranges table, […]

Neptune’s Pride: Things I Learned The Hard Way

I’ve played a few (4 and a half) games of Neptune’s Pride, now. It’s a pretty slow-paced long-term diplomacy/risk-like online flash game. Lots of people have reviewed it, some of them discussing obvious strategy. The following are nuances regarding the game’s mechanics; things I wish I could have found on some nerd’s blog, but instead […]