Sorry if this is more a SQL question than a Rails question. I have a
model called Article that have an attribute called date. I want to
retrive from the database the oldest article. And for each month since
then the number of articles. It is for creating an Archives section in a
blog I'm programming.
Do you think it will be better to create a Month model and insert in
each article a pointer to its month?
No. Just use find_by_sql to run a COUNT(*) query grouped by the month. Or see if AR.count can group for you.