I also used liveQuery for about 5 seconds and seemed notoriously bad

Nowadays I am mostly using indexdb but in the same way hodlbod does it: only to hydrate an in-memory cache and flush dirty pages regularly -- it's way too slow for sync operations.