Entries Tagged as ‘deployment’

February 28, 2010

MySQL Triggers w/Rails

I recently incorporated db-triggers with a Rails app to maintain some counts that were otherwise fairly expensive to retrieve.  Rails wasn’t super-pumped about the idea (what with the “keep all the logic in the app” approach and all), but sometimes… you know… you know better than your framework. Some things I was aiming for: Set them [...]

March 31, 2006

What Time(stamp) is it?

The app I am currently developing (in Java, not the Ruby tutorial I’ve been talking about) relies on a timestamp to report only the most recent activity to it’s clients. So, why was it not properly reporting our test data? After some deliberation I ran the simple statement: select distinct trim(current_timestamp) from xxx.yyy Why the [...]