Your question is IPv6 vs IPv4 Need. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Tell me about why you would need IPv6 over IPv4 and what tradeoffs matter in practice.
Use the endpoint and connection observation data to produce a PostgreSQL comparison of IPv4 and IPv6 operational characteristics.
address_family, endpoint_count, nat_dependency_pct, observation_count, success_rate_pct, and avg_latency_ms.| Column | Type | Description |
|---|---|---|
| endpoint_idPK | INT | Unique endpoint identifier |
| endpoint_name | VARCHAR(100) | Endpoint display name |
| address_family | VARCHAR(30) | Endpoint address family, such as IPv4 or IPv6 |
| nat_required | BOOLEAN | Whether the endpoint requires NAT |
| Column | Type | Description |
|---|---|---|
| observation_idPK | INT | Unique connection observation identifier |
| endpoint_id | INT | Endpoint identifier associated with the observation |
| connection_succeeded | BOOLEAN | Whether the connection attempt succeeded |
| latency_ms | NUMERIC(10,2) | Observed connection latency in milliseconds |