SQLiteNotifier: change detection for real-time event delivery #7

New issue

Closed

opened 2026-02-19 21:28:02 +00:00 by ash · 3 comments

ash commented

2026-02-19 21:28:02 +00:00

Owner

What

Implement StoreNotifier for SQLite.

Options (investigate both)

PRAGMA data_version polling (10-50ms interval)
Trigger + notification table

Requirements

Sub-100ms notification latency
Minimal overhead on write path
Works with WAL mode

## What Implement StoreNotifier for SQLite. ## Options (investigate both) - PRAGMA data_version polling (10-50ms interval) - Trigger + notification table ## Requirements - Sub-100ms notification latency - Minimal overhead on write path - Works with WAL mode

ash added the

enhancement

investigation

labels

2026-02-19 21:28:02 +00:00

ash commented

2026-02-20 08:06:34 +00:00

Author

Owner

Deferred to post-v1. Deferred: polling fallback works. Notifier is latency optimization.

**Deferred to post-v1.** Deferred: polling fallback works. Notifier is latency optimization.

ash referenced this issue from a commit

2026-02-20 08:16:42 +00:00

feat(sqlitestore): add SQLiteNotifier with callback and polling modes

ash closed this issue

2026-02-20 08:16:42 +00:00

ash commented

2026-02-20 08:16:57 +00:00

Author

Owner

SQLiteNotifier implemented with dual strategy: callback-based (instant, via WithStoreNotifier) and polling-based (PRAGMA data_version for multi-process). Tests cover both modes.