classify all push device sessions with one bounded SQLite query
use one fail-closed authorization map for unread and deadline delivery
prune idle/revoked/unknown subscriptions while preserving active fan-out
retain subscriptions and delivery checkpoints when the registry is unavailable
Verification
RED: new store and dispatch tests failed for missing bulk behavior
Focused: 68 passed
Full suite: 1406 passed in 70.63s
git diff --check: clean
Closes #725
## What changed
- classify all push device sessions with one bounded SQLite query
- use one fail-closed authorization map for unread and deadline delivery
- prune idle/revoked/unknown subscriptions while preserving active fan-out
- retain subscriptions and delivery checkpoints when the registry is unavailable
## Verification
- RED: new store and dispatch tests failed for missing bulk behavior
- Focused: 68 passed
- Full suite: 1406 passed in 70.63s
- `git diff --check`: clean
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Closes #725
What changed
Verification
git diff --check: clean