Archive for January 2010

Ooh la la: Paperclip et les European S3 buckets

Posted by Rob Anderton on January 31st, 2010 @ 09:48 – 24 comments

Tagged with aws, buckets, european, paperclip, patch, permanentredirect, rails development, s3

At the end of my last blog about Paperclip I mentioned that you need to do some patching if you want to use European S3 buckets to store your files. The problem was introduced when Paperclip made the move from RightAWS to Marcel Molina’s AWS::S3 gem. Unfortunately despite several forks containing patches to AWS::S3 and a 4 month old bug report nothing has been done to officially fix the problem.

So my fellow Europeans, what are we to do?

Conditional duplicate key updates with MySQL

Posted by Rob Anderton on January 18th, 2010 @ 23:30 – 4 comments

Tagged with duplicate key, insert, mysql, query, update

In one of our larger Rails apps the sheer volume of data we process means we’ve had to rely more and more on direct SQL queries, denormalised tables and summary tables to speed things up. When updating summary tables we typically use ON DUPLICATE KEY UPDATE, a MySQL extension to INSERT statements since version 4.1, that allows a record to either be inserted or updated in one query.

uk ruby on rails, exalead, aws, consultancy