How to create archive list?

It might vary between databases, but in MySQL you could do something like:

:select => "DATE_FORMAT('%m/%Y') as month_year,COUNT(posts.id) as count" :group => "month_year" :order => "month_year"

That's just off the top of my head, but the idea is to use a GROUP BY clause on month.