Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Heroku hosting does not support Sqlite3 databases #9

Open
tsainez opened this issue Dec 10, 2021 · 1 comment
Open

Heroku hosting does not support Sqlite3 databases #9

tsainez opened this issue Dec 10, 2021 · 1 comment
Assignees
Labels
bug Something isn't working wontfix This will not be worked on

Comments

@tsainez
Copy link
Owner

tsainez commented Dec 10, 2021

According to the Heroku docs,

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.

This means we need to find another place to host our website, and Heroku will be a temporary deployment.

This may be one of the reasons to use an ORM over direct Sqlite3 database connections...

@tsainez tsainez added bug Something isn't working help wanted Extra attention is needed labels Dec 10, 2021
@tsainez
Copy link
Owner Author

tsainez commented Dec 10, 2021

I just looked more into the issue. We might need to switch from a SQLite database to something like MySQL or PostgreSQL, which could pose a problem.

@tsainez tsainez added wontfix This will not be worked on and removed help wanted Extra attention is needed labels Dec 10, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

2 participants