Issues with SQLite and network shares

[onedr0p]

Hi 👋🏼

I saw that you originally had Postgres and removed it in favor of SQLite, which makes sense to have no external deps for people using your app. However I am curious if you are interested in adding multiple database support? At least being able to support SQLite and Postgres only.

Using postgres gives from flexibility over SQLite which has a long a sordid past especially with trying to store the database on a network file-system.

Sonarr/Sonarr#1886
https://www.sqlite.org/useovernet.html

[kieraneglin]

As of #145 you can now set the following env var to change your SQLite journal mode: JOURNAL_MODE=delete. This should alleviate SQLite issues on network-attached shares.