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 — the COMMIT still succeeds. Zero errors, zero data loss. 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. Zero failed transactions.
3	Bank Ledger	3 minutes	Developers, auditors	ACID-critical bank transfers survive primary failure mid-commit. Ledger balances always reconcile.
4	vs PgBouncer	5 minutes	Technical evaluators	Side-by-side comparison: PgBouncer drops connections on failover, HeliosProxy replays them transparently.
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