Arckive is open-source infrastructure for Arc: declare contracts in Kubernetes, stream typed events into your Postgres, and build apps with plain SQL.
The case study covers how deterministic finality, fast blocks, transactional cursors, and separate announce/query RPCs work together.