rails console - display active record results in a table

Question

Is there a way to display Active Record results in table format in the script/console environment?

score 37 · Answer 1 · answered Sep 29 '10 at 23:34

37

Yep. There's a gem called hirb that does this very well.

answered Sep 29 '10 at 23:34

Jordan Running

102,619
17
182
182

Thanks, that did the trick! Sorry but I can't vote your answer because I don't have enough reputation. – Power Point Sep 29 '10 at 23:40

Chris Doyle · Answer 2 · 2014-05-21T14:54:57.537

11

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 :)

table_print ruby gem - explore your data

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)

table_print ruby gem - contextualize your data

There's a short intro screencast at http://tableprintgem.com

(full disclosure: I wrote this gem)

edited May 21 '14 at 14:54

answered Nov 05 '13 at 21:32

Chris Doyle

1,029
12
15

Couldn't you do the last thing with normal SQL queries, or the the rails method chain, to get such printouts with other table gems like hirb? – Magne Jan 10 '14 at 14:29
1

I'm a big fan, but you should disclose that this is your gem. – Zach May 20 '14 at 19:01
oh yeah, thanks. *I* know it's mine, sometimes I forget other people aren't in my head :) – Chris Doyle May 21 '14 at 14:54
2

This gem is so easy to use. Thank you! – Sisi Jul 08 '14 at 21:45

rails console - display active record results in a table

2 Answers2