Yep! Already dabbled and tinkered with the sqlite db behind Pi-Hole after reading another article that provided the steps to perform a sort of ‘factory reset’ on Pi-Hole. Also tried on the “Dark Theme” for the web interface that I found in another conversation.
I tinker with my Emby Media Center’s db which sits on a DBServer that also supports one of the Fantasy Football Leagues I’m a member of. Ive been told that I broke a lot of toys when I was a kid. Then put them back together just so I would know how they worked. Aside from breaking things, I guess some things don’t change. I’m sure a lot of us in tech can relate.
Anyway, all that to say, I don’t have a problem with compiling [and sharing] a list of domains and the applications and companies that are associated with them. Though,… I wonder if I surf enough of the web to compile a list that was meaningful.
I’m just thinking out loud here, but I imagine a meaningful list would be a consolidation of several thousand users. Then, if each user collected/shared their lists, there would still be wild, varied levels of details that each person provides.
I suspect that Pi-hole provides an API for exactly this reason. So that someone with the know-how, willingness and time could develop an addon/plugin that would could deploy agents [for unix, windows, android, etc] to collect an app inventory that also included listening ports from all connected nodes on a users LAN.
While I have experience doing similar things on Wintel platforms. Other platforms would require a learning curve.
Anyway, these are just rambling, musings … I’m sure that security and anti-virus corporations probably already have such lists…