search

mrpaulmason / meetable-api

Meetable API
1 stars 0 forks source link

Manually Accessing Database with Heroku CLI #153

Closed darmai closed 6 years ago

darmai commented 6 years ago

1) If not already completed, set up the Heroku command line tools locally by following these instructions: https://devcenter.heroku.com/articles/heroku-cli 2) Starting from the "Overview" tab of the meetable-api dyno page in Heroku a) Click on 'Heroku Postgres' b) A new page will open for the datastore. On this page, click on the 'Settings' tab c) Then click on the 'View Credentials' button

The last line in the credentials section is the 'Heroku CLI' command for getting into the database. If you are logged in and enter this command in a terminal session, you will be dropped directly into the Meetable DB.

You can then navigate and operate on the DB as you see fit. It is unclear what access privileges are granted to this user but you can definitely view all the tables and edit the data in the tables. So, be careful.

mrpaulmason commented 6 years ago

@amalia 'Places' table is in this database

aamaliaa commented 6 years ago

👍 Thanks, I'm able to access the DB after following these steps.