Its being done for one npub only, in the client. That really isn't much to ask of a device made in the last 20 years. Even sqlite should be near-realtime, I should think...