SQL Anywhere 0.5.1 — storage primitives as chapters

SQL Anywhere 0.5.1 — storage primitives as chapters

Another chapter, not another product. The everyday storage primitives compose
out of plain SQL over the replicated SQLite engine — no Redis/SQS/Kafka running
alongside:

• KV cache with TTL — a table with an expiry column, a lazy-filtering view,
  and a periodic sweep. Durable and replicated, unlike an in-memory cache.
• Durable work queue — a table plus an atomic UPDATE … RETURNING claim and
  a visibility-timeout column: many workers, no double delivery, at-least-once
  redelivery when a worker dies.
• Pub/sub — an append-only topic tailed by cursor; across nodes the
  replication log is the transport, so publish-on-primary / subscribe-on-edge
  works with no broker.

Guide: docs/STORAGE_PRIMITIVES.md. Demonstrated in
examples/storage_primitives.rs and verified by tests/storage_primitives.rs.

Install

docker run -p 8080:8080 -d ghcr.io/kwhorne/sqlanywhere-server:0.5.1

Prebuilt sqld binaries and crsqlite extensions for macOS Apple Silicon,
Ubuntu Intel and Ubuntu ARM are attached below.

Full changelog: https://github.com/kwhorne/sql-anywhere/blob/main/CHANGELOG.md