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 up with [...]

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 [...]