{"action":"closed","issue":{"url":"https://api.github.com/repos/noah-dev/django_calc/issues/3","repository_url":"https://api.github.com/repos/noah-dev/django_calc","labels_url":"https://api.github.com/repos/noah-dev/django_calc/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/noah-dev/django_calc/issues/3/comments","events_url":"https://api.github.com/repos/noah-dev/django_calc/issues/3/events","html_url":"https://github.com/noah-dev/django_calc/issues/3","id":236879203,"number":3,"title":"Database does not save on Heroku - Switch from SQLITE to Postgres","user":{"login":"noah-dev","id":29388801,"avatar_url":"https://avatars0.githubusercontent.com/u/29388801?v=3","gravatar_id":"","url":"https://api.github.com/users/noah-dev","html_url":"https://github.com/noah-dev","followers_url":"https://api.github.com/users/noah-dev/followers","following_url":"https://api.github.com/users/noah-dev/following{/other_user}","gists_url":"https://api.github.com/users/noah-dev/gists{/gist_id}","starred_url":"https://api.github.com/users/noah-dev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/noah-dev/subscriptions","organizations_url":"https://api.github.com/users/noah-dev/orgs","repos_url":"https://api.github.com/users/noah-dev/repos","events_url":"https://api.github.com/users/noah-dev/events{/privacy}","received_events_url":"https://api.github.com/users/noah-dev/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-06-19T12:46:25Z","updated_at":"2017-06-19T14:10:56Z","closed_at":"2017-06-19T14:10:56Z","body":"As I was testing the app today, I noticed an issue.\r\nAlthough I managed to figure out how to deploy to Heroku, looks like I tripped up.\r\n\r\n**Problem:**\r\nIn the current deployment, the database sits in the root of the Heroku app - however changes to those files do not persist after the Dyno is spun down. (Maybe there are other situations?)\r\n\r\nSo initially, it will appear calculations are saved in the database and can be viewed on other devices. However, once the app goes to sleep (limitations of my free account) the new calculations are lost. The calculations that are there were made on the local server, and were part of the initial commit to Heroku. \r\n\r\n**Solution:**\r\nFortunately Heroku offers a way to persist databases, by implementing a Postgres database. The app, using Django, was configured to use a SQLite database. I've never done this before, but I am going to fix the app by moving from SQLite to Postgres. \r\n\r\nI am currently looking up documentation for 1st) Implementing Postgres on the app 2) Configure Heroku to work with the Postgres database. \r\n\r\n**Progress:**\r\nBecause I've never done this before, it's hard to estimate time - but I am aiming for **9:30 AM** to implement the new changes. "}}
{"actor":{"display_login":"noah-dev"}}