My solution is to create a docker network with the macvlan driver connected to a bridge interface on the host. Then you make the database listen on the bridge or just leave it on all interfaces. Don’t forget to configure the ips.
I can share my config later.
I’m currently building a similar device, which uses miraclecast for screen sharing from a phone or laptop and jellyfin in firefox kiosk mode controlled via the jellyfin app as a idle screen. Also sending media links via kde connect is possible. I still want to implement hypnotix for tv and some kind of intigration with the streaming services of the german public brodcasters. I haven’t thought about dlna but I like the idea.
I’m also using Debian as a base but I’m using LXQT with Wayland insted if Plasma. I tested everythin on a rasberry pi 4b but it’s struggeling. I want to move everything to a rock 5c.
You could try pkexec insted of sudo. Pkexec pops up the password prompt in a window insted of prompting in the terminal.
I’m assuming you’re using the nautilus file manager. I found this post in adding right click actions to nautilus: https://askubuntu.com/questions/210192/how-can-you-add-an-item-to-the-right-click-menu-in-nautilus-without-nautilus-ac#672553 You could make a bash script like shown in the post and use polkit to open the password prompt and run a command as root.
They haven’t implemented the driver for the Fairphone 5 yet. I think it works on the Fairphone 4.
I got a Fairphone so I could run calyxos. The only thing missing for me is the option to stop charging at 80%.
Most phones can, it’s just disabled in software, you can enable it in Androids developer settings.
I’m currently using Astro for that. You can write the pages in markdown, html or one of the many js frameworks. It also allows you to mix them.
By default it generates static websites with out any js, but it allows you to add js where needed. Optional server side features are wip, if you decide to need them later on.
They also have pre made themes on their website if you don’t feel like writing css.