#time-zones

• Ruby Time Object Time Zone Bug

  https://justatheory.com/2007/08/ruby-time-zone-bug

  Indexed 10/14/2025

• Intelligent MySQL Configuration

  https://justatheory.com/2006/04/intelligent-mysql-configuration

  James Duncan Davidson’s Configuring MySQL on MacOS X post earlier today reminded me that I wanted to blog about the configuration I came up with while installing MySQL 5 on my box. Nothing has irritated me more than when MySQL’s syntax has violated the ANSI SQL standards in the most blatant ways, or when transactions have appeared to work, but mysteriously not worked. Yes, I use Duncan’s settings to make sure that the MySQL box on my PowerBook only listens on local sockets, but I additionally add this configuration to /etc/my.cnf:

  Indexed 4/2/2026

• Need Help Reducing View Calculations

  https://justatheory.com/2007/11/reducing-postgres-view-calculations

  Indexed 1/5/2026

• Validating Time Zones in PostgreSQL

  https://justatheory.com/2007/11/postgres-timezone-validation

  Indexed 4/7/2026

• Always Use TIMESTAMP WITH TIME ZONE

  https://justatheory.com/2012/04/postgres-use-timestamptz

  Indexed 4/15/2026