Frankenstein’s ActiveRecord: How to stitch together complex ActiveRecord queries from simple parts has some great tips and techniques for working with your database using ActiveRecord. It includes some less well-knows Postgres features for grouping and manipulating data.