If I’m the only one doing it then I’d prefer to stick with sqlite. But the reality is that everyone I work with does these kinds of things in excel, and it’s a shitshow. Yes, u could say ‘don’t blame the tool’, but it’s ms shoving it down our throats and they could’ve done much better with the time they had.
I get that. But it’s a case that’s just so incredibly common. Tagging/categorization. We end up with multiple columns like ‘cat 1’, ‘cat 2’, etc. Or doing pivot tables. I guess to me there’s pretty much always something that can do the job better, but the reality is that in the corporate setting I operate in everybody uses Excel.
Excel is such an incredible piece of shit. There’s many reasons to hate it for me, but what i hate the most is not being able to do relationships in any meaningful way. So often i need to have one to many relationships and this garbage makes it impossible. Data consistency? Nope. Opening a csv? Fuck you! Why the fuck are there online tools that are better at this shit? You had 40 years ffs. No amount of AI is going to fix this turd. God I hate Excel.
I would greatly appreciate a bit more detail on your setup, is your calibre library simply a folder synced through next cloud?
I did this about a year ago, and started with tailscale. But for some bizarre reason, tailscale would cause my entire internet connection to drop. I had the internet provider come out 5 times to fix it, i got a new router twice, they even checked for cable problems between my house and the neighbourhood switch. All to no avail. I would lose internet connection several times a day until i would reboot my router. I then found someone on their forum mention that tailscale was causing problems, so i turned it off. The problems stopped. I found no way to mitigate this.
I ended up running wireguard, which works great for me, but does have a bit of a learning curve. I have rented a tiny cloud server which is the central hub, and all of my services run in podman with their own wireguard config. I run my own dns for the lacal domains. It took me a bit of effort, but is now running very stable.