I am waiting for sqlite support to be merged

Sources of those tweets?

Has anyone tried it? I am thinking about using it on some Raspberry Pi 5.

Yes, in the sense that you are responsible to update the Docker container and often this can lead to vulnerable containers. No, in the sense that it is much easier to scan for dependencies inside a Docker container and identify vulnerabilities. Also most containers are based on Linux distribution, so those distribute the security fixes for specific libraries. All you have to is update the base image.

Dependency-free doesnt mean they dont have dependencies. Its just that they bundle them all in the executable. When there is a security vulnerability in a library on your Linux system the vendor of your distribution (Canonical, Redhat, SUSE) takes care that it is fixed. All dependent software and libraries are then fixed as well. All I say? Not the ones which have been bundled in the executable. First they need to find out that you are affected and then the maintainer has to update the dependency manually. Often they can only do this after there has been a coordinated release of the fix by the major distributors, which can leave you vulnerable no matter how fast the maintainer is. This is the way it is in Windows. (This was a short summary)

Are you just starting out? I got started with home labbing with a Raspberry Pi 2B (1GB RAM!) and an external HDD I had lying around. I host Yarr, Navidrome, backups and a dashboard app Ive written on there and I am quite satisfied. I would really recommend starting small with hardware you already have and then buy new hardware as you go along. I am also using Tailscale. With this you can get your initial setup up and running in a day and save money if it turns out home labbing isnt for you or you dont really need the hardware.

There is plant-it written in Java and HortusFox written in PHP. Both using MySQL. Is there anything available which is written in Go or Rust and uses SQLite?

I chose Navidrome, with which you can stream music from your hard drive. It has very easy setup and it feels just great to stream your own music. I use Tailscale to connect the server to my phone and Ampery as an iOS app.