

+1 I use it to on all of my devices for sharing 1 folder, just set one as introducer, and keep adding nodes (e.g. phone, Work mini, laptops, PC, …) Once you have that set, start adding folders as needed for specific cases (e.g. a folder shared among all mentioned except for Work mini.)
Yes, I think the problem description fits for moving from static website to having a database and a web service ( with or without javascript, could be just forms, check htmx.org ). For example, if you know Python you could go and check Django. But there are many other ORMs, all aiming to make working with databases easier. Btw, I am not expanding the ORM acronym because it would only add noise. OP should look into that, and understand why these ‘frameworks’ are called like that… Good luck!