Hacker News Reader

It runs fully on the client and is offline first. A listener to PostgreSQL will not work when the device goes offline.

Fair enough, so what about triggers on a sqlite db on the client?

There is a big difference between having a changestream of writes to the database, and observing results of multiple queries.