Secure a free DB

[rivernews]

Steps:

• Better to use django app to create table schemas.
• Then try to dump data from aws-rds to heroku's
• Then connect to heroku's database again from Django.

Useful Links:

• Useful SQL commands to list tables.

[rivernews]

Using Heroku as Database Store w/o deployment

• Create an app on heroku
• Create add on "postgres" on that app
  • Note down the credentials
  • Put credentials in Django as comment. For now keep the aws rds credentials, don't delete them we'll still need them)
• Follow this post to dump and restore data between 2 databases, in Django's way.
  • In case the migration failed and the Heroku's database is polluted, use Django's wipe database to clear all content, then retry.
• Runserver and see if you succeed. If so, clean up the artifacts like out.json.