Prevent Django SQLite db from being overwritten while pushing to Heroku

by

Heroku does not provide a persistent filesystem.

Most Heroku applications that I have worked on use PostgreSQL for their database, so this isn’t a problem. But SQLite is just a file sitting in a directory somewhere, so every time you deploy your database will be lost.

The easiest solution is probably to migrate from SQLite to PostgreSQL, which is very well supported on Heroku (and in Django) and will not lose data every time you deploy.

If you’re firmly committed to SQLite you may have some other options:

  • Back your database file up before each push and restore it after your push.
  • Add your production database to your Git repository, so it will be deployed along with your application (note that I don’t recommend this).
  • Many users use Amazon S3 to store other types of assets. You may be able to use a similar procedure with your database, though I suspect there will be some very significant security risks doing so.

More Related Contents:

  1. git push Heroku main – error: src refspec main does not match any
  2. Heroku: Django database file lost on every dyno restart
  3. Django: Deploying an application on Heroku with sqlite3 as the database
  4. Heroku – Handling static files in Django app
  5. Getting ‘DatabaseOperations’ object has no attribute ‘geo_db_type’ error when doing a syncdb
  6. Using Heroku for Django Media Files
  7. Heroku app database resetting
  8. ImportError: No module named ‘_sqlite3’ in python3.3
  9. Django: What are the best practices to migrate a project from sqlite to PostgreSQL
  10. Django static files on heroku
  11. Django: sudden DB reset after Heroku sleep
  12. Different db for testing in Django?
  13. Applying bootstrap styles to django forms
  14. Using a UUID as a primary key in Django models (generic relations impact)
  15. Django ManyToMany filter()
  16. How do I deal with this race condition in django?
  17. django – pisa : adding images to PDF output
  18. Initial populating on Django Forms
  19. Django, Retrieve IP location
  20. Django multiple and dynamic databases
  21. How to limit queryset/the records to view in Django admin site?
  22. Django ManyToMany model validation
  23. Django – Overriding the Model.create() method?
  24. How to create a Django queryset filter comparing two date fields in the same model
  25. Multiple images per Model
  26. Redirect on admin Save
  27. Effects of changing Django’s SECRET_KEY
  28. Error: Cannot pull with rebase: You have unstaged changes
  29. Authorization Credentials Stripped — django, elastic beanstalk, oauth
  30. Django query case-insensitive list match

Leave a Comment