Spain? check guifi.net ;)
People had LAN Partys playing video games “offline” in the 90s… Setting up a network is easy, the difficulty comes from scaling up to many nodes, and spreading through the geography (e.g. if you were to use antennas for WLAN, they would need a mostly unobstructed vision) which in urban areas gets tricky.
But those “topology” issues can be flattened, e.g. you can always have a raspberry pi (or any device) acting as server in the corner of a neighborhood. A virtual bulletin board, emails, etc. all could be self-hosted locally there and then people could go grab a coffee and consume the local news just like in the middle ages, but with a screen, digital assets and some healthy amount of trolling :P
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!