search

tsainez / bobchat

Social media network for University of California, Merced students.
MIT License
1 stars 0 forks source link

Heroku hosting does not support Sqlite3 databases #9

Open tsainez opened 2 years ago

tsainez commented 2 years ago

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 commented 2 years ago

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.