Adim
Reputation: 811
View formatted sqlite results
So I code using ruby on rails and the default database is sqlite, which is amazing for development. there is no setup time, no need for connection etc. What really sucks is the output on the command line. when i do a query to list all the contents of a table for example. I just get a dump of text, unlike when you use MySql, the CLI formats the results of the queries nicely (with headers in a table). I am also aware of "headers on" and the commands you can type to format the results of sqlite but those are temporary and I am looking for a more permanent way to format the results so i do not have to do it every-time.
Upvotes: 0
Views: 53
Answers (1)
Related Questions
- Rails - how can I view my SQLite tables?
- Parsing sqlite3 query responses in ruby
- Viewing table data in SQLite Ruby on Rails
- Rails/Sqlite 3 - Displaying table data on page
- Printing out elements from tables in a database, Rails
- SQLite SELECT not displaying in Ruby console?
- Formatting SQL output in Ruby
- How do you output Ruby on Rails console database resultsets in a pretty format without installing a gem?
- display formatted database contents on view page
- Formatting results from SQL in Ruby On Rails