I've already asked on the subreddit for Joplinapp but could use more input please:
I was using the flatpak version of Joplin. Everything in my home directory got nuked which included the Joplin flatpak files. What I did was use photorec to try and restore the files. I have about 200 .sqlite files which have all been renamed fxxxxxxxxx.sqlite with photorec during recovery so I can't just search for database.sqlite.
I tried opening every single one after another in a sqlite viewer and couldn't find the Joplin db unfortunately. Three of the files did have mentions of my notes but I think that was just flatpak or linux logging something. I then tried opening them manually in notepad (on my win10 machine since my Linux one is out of commission atm) and comparing it to a fresh Joplin db.
Is there any chance it could be saved as another file extension? A lot of the .sqlite files I see are malformed and could be from various applications/packages.
I was in the process of using joplin when the delete happened so maybe it's a sqlite temp file somewhere if it saves it as another extension before writing it to the database.sqlite?
Thanks! I really don't want to lose months worth of notes, most of which I wouldn't even remember because that's why I was using a note taking app in the first place.