as @zwass mentioned a while back, fleet and zentral are two open source projects that implement live query pretty well