How do I check the records of my heroku database?

ruby-on-rails ruby database hosting heroku
Justin Meltzer picture Justin Meltzer · Apr 28, 2011 · Viewed 28.6k times · Source

I've just deployed my application to heroku and pointed my custom domain to the heroku servers. How can I check the records in my heroku database?

Answer

Andre Schweighofer picture Andre Schweighofer · Apr 28, 2011

You can use heroku run rails console and look at your records with Model.all or any other method.

If you want to backup the database look at heroku PG backups, you then can import your database on your local machine and look at it there. Depending on your db adapter you could use sqlite browser for sqlite3 or phpmyadmin for MySQL.

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Difference between rake db:migrate db:reset and db:schema:load

The difference between rake db:migrate and rake db:reset is pretty clear in my head. The thing which I don't understand is how rake db:schema:load different from the former two. Just to be sure that I am …

Read More
Rails :include vs. :joins

This is more of a "why do things work this way" question rather than a "I don't know how to do this" question... So the gospel on pulling associated records that you know you're going to use is to use :…

Read More