Start with plain old Gramps. It can export to static sites with several different templates. Gramps Web is not easy to host or run. It was designed for some specialized things.

https://gramps-project.org/blog/

I love Fossil-scm. Even host my own instance with my web host. I was considering using github moving forward, but given recent events and decisions by Microsoft, I’ll be sticking with Fossil-scm.

VSCode with Foam. Or go old school with Vim Wiki.

Obsidian now has a native query ability via the Bases core plugin. I’ve barely played with it though.

https://textpattern.com/