One of the things making your Heroku hosted database, certainly from a remote box, or a console difficult is the need to get an application running with the Heroku gems. This means also means your system admin team needs to be concerned with Gems too. Here are the steps to gain access to your Heroku data base with a psql console to execute commands. 1) We do need application access and the gem to do this. ➜ words git:(master) heroku config === words Config Vars AWS_KEY: keys AWS_SECRET: secrets DATABASE_URL: postgres://foo:baz@ec2-34-34-34.compute-1.amazonaws.com:5432/foochickenheads HEROKU_POSTGRESQL_GREEN_URL: postgres://foo:baz@ec2-34-34-34.compute-1.amazonaws.com:5432/foochickenheads The line of interest is the DATABASE_URL 2) Now construct a request like this. $ psql “user=foo password=baz host=ec2-34-34-34.compute-1.amazonaws.com port=5432 dbname=foochickenheads sslmode=require” foochickenheads=> With this setup you[…]

To override your root nodes for ActiveModel serializers without a global config use the following. This makes a consistent API for clients regardless of model but still leaves your code flexible. # Controller render json: @liked, root: ‘data’   # Returns a collection like so. { "data" [{}, {}, {}] }