Rails3 SQL logging output in a separate file

Question

I'd like to have all my ActiveRecord SQL logging to have redirected in a different file. It's kinda messy to have it on the console or in the log/development.log.

How to do that? I'd love to have it in a log/development_sql.log file.

Thanks

Answer 1

ActiveRecord::Base.logger = Logger.new('log/development_sql.log')