JSAbrahams / Academic-Journal

📚 A journal to keep track of notes
MIT License
1 stars 1 forks source link

[BUG] Cannot read database if Zotero is open #30

Open JSAbrahams opened 4 years ago

JSAbrahams commented 4 years ago

Describe the bug Refreshing the database connection does not do anything.

To Reproduce

  1. Make sure Zotero is open
  2. Load application, observe that references have not been loaded
  3. Close Zotero
  4. Refresh connection with database, note that nothing happens

Expected behavior -[ ] A connection should be established. -[ ] On boot, if a connection cannot be established, we should prompt the user to retry, giving a hint that we might need to close the other application

Additional context Fixes #19 Ideally, we should be able to read form the sqlite database even if Zotero is accessing it. In theory, sqlite does allow mutiple reads concurrently, however, if Zotero is continually writing to the database we are out of luck, as sqlite is not designed for concurrent reads and writes.