We recently built a chat, and ran into an interesting issue regarding retrieval of chat messages, with an interesting solution. There’s a blog post about it on the Elabs blog: http://www.elabs.se/blog/72-retrieving-the-last-n-ordered-records-with-activerecord