sqlite with sql subscriptions using corrosion

[gedw99]

https://github.com/superfly/corrosion

https://superfly.github.io/corrosion/api/index.html

you get subscription queries
you get HA because the DB is multi master SQLITE.

@dosco have a look.

[gedw99]

github.com/scizorman/go-ndjson can consume the change feed.

[dosco]

it's very hard to figure out which queries these change feed map to smart polling with batching is a more efficient, simpler and flexible approach.