so i've been told via another dev for another piece of software, quote "sqlite databases need to be on local storage" and while i love using portable softwares whenever possible (which i keep them all in a dropbox folder), i always weigh the tradeoffs.
If theres an extra load involved, a risk of corruption, or something that makes this non-ideal or problematic i'll swap over to the installed version. Able to shed some light if he was painting with a broad brush/being overly cautious or if this is in fact a safer/smarter alternative (to not run things that use db out of dropbox?)
thanks!
voidtools portable + dropbox folder
Re: voidtools portable + dropbox folder
Storing your Everything.db in the cloud would be fine.
While Everything is running, the database is stored in memory.
The database is only saved to disk when you exit Everything.
Database location
While Everything is running, the database is stored in memory.
The database is only saved to disk when you exit Everything.
Database location
Re: voidtools portable + dropbox folder
okay, that makes sense thank you.
the application/workflow i was referring to was calibre portable intertwined with readarr. apparently one or the other modifies the database in not that fashion and it causes issues. that or the readarr dev/contributor was just incorrect.
as always i appreciate your time and help
the application/workflow i was referring to was calibre portable intertwined with readarr. apparently one or the other modifies the database in not that fashion and it causes issues. that or the readarr dev/contributor was just incorrect.
as always i appreciate your time and help
Re: voidtools portable + dropbox folder
He's wrong ànd right at the same time. Sqlite databases should be stored on local storage as they are disk-based databases (every read or write to the database goes to disk).
But the Everything database is not a sqlite database. It lives in RAM and - as @void already pointed out - is read from disk at startup and written to disk at shutdown. In the meantime the database on disk is ignored (you could even delete it when Everything is running).
A sqlite database on cloud storage *can* cause timing issues.
Re: voidtools portable + dropbox folder
gotcha, when i got the news from him... i knew this used/kept a db. I did a quick google and some mentions seemed to insinuate it was sql and so i proceeded to ask as i want to avoid issues.
now that i know it wont cause issues here i know i can leave it. as for readarr's integration with calibre im not as confident so I imagine thats best left local.
I know the calibre library itself is fine on cloud storage. tons of people have theirs there. however the crux of my issue was wanting to use calibre portable vs the installed version. i keep my portables in cloud storage and I guess whatever kind of db calibre keeps is the kind that shouldnt be there. or.. something. It goes above my head at least at this point.
readarr itself's db is kept in programdata and as such unaffected so im unsure if he was referring to calibre, or somehow readarr's db getting corrupted due to info it was getting from calibre. (though it should just should just be placing files and issuing commands to calibre so i wonder if it was all paranoia)
now that i know it wont cause issues here i know i can leave it. as for readarr's integration with calibre im not as confident so I imagine thats best left local.
I know the calibre library itself is fine on cloud storage. tons of people have theirs there. however the crux of my issue was wanting to use calibre portable vs the installed version. i keep my portables in cloud storage and I guess whatever kind of db calibre keeps is the kind that shouldnt be there. or.. something. It goes above my head at least at this point.
readarr itself's db is kept in programdata and as such unaffected so im unsure if he was referring to calibre, or somehow readarr's db getting corrupted due to info it was getting from calibre. (though it should just should just be placing files and issuing commands to calibre so i wonder if it was all paranoia)