rails console - display active record results in a table
Also check out http://tableprintgem.com. It's an efficient way to view a list of structured data, making it easy to scan and compare across large swaths of records (and for many people, it's a comfortable return to the SQL command line output of yesteryear :)
The most powerful feature of table_print is the ability to see your data in the context of other objects it relates to. You can reference nested objects with the method chain required to reach them. This example is showing data from three different tables:
- name from the Author table (reached through author.name)
- title from the Book table (reached through author.books.title)
- caption from the Photo table (reached through author.books.photos.caption)
There's a short intro screencast at http://tableprintgem.com
(full disclosure: I wrote this gem)