ffnodestats

Idea and stuffs:

database storing connection snapshots, consisting of:
UnixTimestamp RouterMAC(ID) ClientMAC

possible requests to database:

>routers(from,to) -> unique router MACs
>clients(from,to) -> unique client MACs

>router_clients(from, to) -> macs of unique connected clients to router in that time span

for a router graph time/clients just do multiple router_clients(from,to) requests for different spans
and visualize the length of the client array

client_connections(from, to) -> return an array of connections in form of {routerMAC, fromStamp, toStamp}
this works by assuming that if a client is missing in a snapshot or changed routers, the connection was lost

for a timeline of the client:
use client_connections(from,to)
visualize ;)

for a timeline of router where you see when which client connected:
use router_clients for a span
for each client use client_connections for that span and filter for connections to that router
visualize