Heroku app database resetting

by

As stated by @DanielRoseman you should not use SQLite on heroku, because SQLite runs in memory, and backs up its data store in files on disk.
Let me quote from the heroku doku:

SQLite runs in memory, and backs up its data store in files on disk. While this strategy works well for development, Heroku’s Cedar stack has an ephemeral filesystem. You can write to it, and you can read from it, but the contents will be cleared periodically. If you were to use SQLite on Heroku, you would lose your entire database at least once every 24 hours.

Even if Heroku’s disks were persistent running SQLite would still not be a good fit. Since SQLite does not run as a service, each dyno would run a separate running copy. Each of these copies need their own disk backed store. This would mean that each dyno powering your app would have a different set of data since the disks are not synchronized.

Instead of using SQLite on Heroku you can configure your app to run on Postgres.

It is really easy to use postgres in django. You only have to change the database adapter in your settings file:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'mydb',                     
        'USER': 'myuser',
        'PASSWORD': 'password',
        'HOST': 'localhost',                      # Empty for localhost through domain sockets or           '127.0.0.1' for localhost through TCP.
        'PORT': '',                      # Set to empty string for default.
    }
}

There is also a tutorial on how to setup a django application on herku in their docu section:

https://devcenter.heroku.com/articles/django-app-configuration

More Related Contents:

  1. Prevent Django SQLite db from being overwritten while pushing to Heroku
  2. Heroku – Handling static files in Django app
  3. Getting ‘DatabaseOperations’ object has no attribute ‘geo_db_type’ error when doing a syncdb
  4. Using Heroku for Django Media Files
  5. git push Heroku main – error: src refspec main does not match any
  6. Heroku: Django database file lost on every dyno restart
  7. Django static files on heroku
  8. Extending the User model with custom fields in Django
  9. log all sql queries
  10. How to define two fields “unique” as couple
  11. Creating a extended user profile
  12. How to filter empty or NULL names in a QuerySet?
  13. How to view corresponding SQL query of the Django ORM’s queryset?
  14. Unique fields that allow nulls in Django
  15. How to use the request in a ModelForm in Django
  16. Django – iterate number in for loop of a template
  17. How to convert a Django QuerySet to a list?
  18. Django: accessing session variables from within a template?
  19. Django: Can class-based views accept two forms at a time?
  20. Django: Redirect logged in users from login page
  21. How do I add a Foreign Key Field to a ModelForm in Django?
  22. Can I call a view from within another view?
  23. Django: implementing JOIN using Django ORM?
  24. how to show datepicker calendar on datefield
  25. Django removing object from ManyToMany relationship
  26. Log in / Sign up directly on home page
  27. Authorization Credentials Stripped — django, elastic beanstalk, oauth
  28. How to use if/else condition on Django Templates?
  29. Django query case-insensitive list match
  30. Django/DRF – 405 Method not allowed on DELETE operation

Leave a Comment