HeliosProxy Demos

Five self-contained demos that showcase HeliosProxy’s capabilities. Each runs entirely in Docker and requires no external infrastructure.

Prerequisites

Docker and Docker Compose v2
psql (PostgreSQL client)
curl
jq

Demo Index

#	Demo	Duration	Audience	What It Proves
1	Impossible Query	60 seconds	Executives, investors	Kill the primary mid-transaction — with `tr_mode = "transaction"` the uncommitted work is replayed on the new primary and the session continues; a COMMIT whose outcome is unknown returns `08007` and is never retried. Transaction Replay in action.
2	Chaos Failover	5 minutes	DevOps, SREs	Continuous random failures (kill nodes, network partitions, disk pressure) while a pgbench workload runs. Sessions stay connected; only statements whose outcome is unknown surface an error.
3	Bank Ledger	3 minutes	Developers, auditors	ACID-critical bank transfers keep their sessions through primary failure; uncommitted transfers are replayed, in-flight COMMITs are reported (`08007`) rather than retried, and ledger balances reconcile.
4	vs PgBouncer	5 minutes	Technical evaluators	Side-by-side comparison: PgBouncer drops connections on failover; HeliosProxy keeps the sessions alive, re-runs interrupted reads and replays uncommitted transactions.
5	Lag-Aware Routing	5 minutes	Developers, DBAs	Induce replication lag and watch reads automatically reroute to healthy standbys. Read-your-writes consistency guaranteed.

Quick Start

Each demo is a single docker compose up away:

# Demo 1: Impossible Query (60s marketing wow)
cd impossible-query && docker compose up -d && ./demo.sh

# Demo 2: Chaos Failover (5-min stress test)
cd chaos-failover && docker compose up -d && ./chaos.sh

# Demo 3: Bank Ledger (ACID integrity proof)
cd bank-ledger && docker compose up -d && ./demo.sh

# Demo 4: vs PgBouncer (competitive comparison)
cd vs-pgbouncer && docker compose up -d && ./compare.sh

# Demo 5: Lag-Aware Routing (educational)
cd lag-aware-routing && docker compose up -d && ./observe.sh

Cleanup

Each demo uses isolated Docker volumes. To tear down any demo:

cd <demo-directory>
docker compose down -v

Port Ranges

Each demo uses a distinct port range to avoid conflicts:

Demo	Client Port	Admin Port	PG Ports
Impossible Query	26432	29090	25432, 25442
Chaos Failover	36432	39090	35432, 35442, 35452
Bank Ledger	46432	49090	45432, 45442
vs PgBouncer	56432	59090	55432, 55442
Lag-Aware Routing	66432	69090	65432, 65442, 65462