This only works for simple workstation stuff, not for power users trying to get max performance. My recommend is dual/tripple boot or separate computers.

You could do it with a no sql database but using sql would also be fine. You could use php or node. It’s just REST API that do database calls. The reason to choose a certain tech stack should be based on what you are comfortable with and around cost of infrastructure since it will be small at first and ROI will come later if the project works out. Front end could be anything and React is well supported and mature. If you have to write a custom interactive GUI it will basically be vanilla TS/JS wrapped in React components.