• 0 Posts
  • 22 Comments
Joined 7 个月前
cake
Cake day: 2025年6月8日

help-circle
  • Yeah, I wasn’t trying to say SQLite is universally better. I shouldn’t have said best option, I really meant best default. I don’t think the majority of users are running a central db, most will just spin-up docker compose files for each service and end up with multiple SQL versions running.

    I’ve had a lot of problems in the past from software crashes that left sqlite files in a corrupt state

    I have had this issue, but it was always easily recoverable. I haven’t had the same issues with backups, although a lot of the software I use that’s running SQLite has a builtin backup feature, then I just backup that directory to a cloud service.

    Besides that SQLite really doesn’t play nice with NFS, which is the basis for quite a few cloud storage providers. Also a good point, I just don’t think the majority of users are using NFS for their DBs.

    When an app is using an ORM already, I think they might as well make sure it supports both SQLite and a hosted DB like Postgres












  • I also just started the process of migrating to a self hosted music server. I’m using navidrome, but a big feature I want is being able to easily add custom tags to songs that I can later use to search and filter for what I want. Navidrome will only open your library in read-only, which is a smart security measure, but means it cant support this. I’m going to try Koel next and see how that goes.




  • I have all my services behind a reverse proxy and use Crowdsec to monitor and block automated attacks. I also have pocket-id for auth, I use SSO for apps that support it and others just require authentication to access them at all. The docs are pretty solid, it was easy to set up.

    Make sure you know the services running on your server, the most likely way you could get attacked is by just leaving some vulnerable or misconfigured software running and accessible.

    Also I’d probably set up account lockouts on any software you can, I know Jellyfin supports it.