Category Archives: SQL
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 … Continue reading
Filed under deployment, rails, Ruby, SQL, Test Driven Development (TDD)
Avoiding Insert Locking With Insert Into
Ran into an issue where shared locks were being applied (for InnoDB) on a statement with this format: insert into a select * from b; While that statement is running, not only does a have some locks applied, but so … Continue reading
Filed under SQL
The Future, Conan?
Why aren’t my fixtures properly loading their ‘registered’ timestamps correctly? Ah, the dreaded Year 2038 issue loads fine: user_registered: ’2038-01-18 21:14:07′ not happy: user_registered: ’2038-01-18 21:14:08′ So, that fixture that I just wanted to have ‘a date way out in … Continue reading
Rubicizing
So far so good. In a fairly short amount of time I have an application with some basic functionality + user management (register, signin, email confirmations, etc). Very simple = very nice. So far I’ve been leaning pretty heavily on: … Continue reading
Filed under Agile Software Dev, rails, Ruby, SQL
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? … Continue reading
Filed under deployment, SQL
