Console’s review
· Reviewed by David Mytton
What we like
Adds pub/sub, task queue, and event streams to SQLite. No need for client polling or a broker. Shipped as a SQLite extension with bindings for Python, Node, Rust, Go, Ruby, etc. Allows an INSERT and enqueue as part of the same transaction (with rollback). Also supports cron.
Tradeoffs
Polling is via a SELECT per millisecond per database, which should be lightweight, but is an extra high-frequency query. Still experimental.