I'd like to check it out, but they don't seem to like my ad blocker.
I've been in a few discussions here about the pipe idea and I think it's a good one.
Lots of plumbing fitting options for the pipe and valving, but the larger the pipe gets the more rapidly the price goes up. Big pipe fittings are ridiculous.
nice thing with sched40 PVC or ABS is that it is pretty sturdy and is sufficient for tapping NPT hose bibs into an end cap. or putting a valve stem in it to pressurize things a bit.
And speaking of pressure, 4" sched40 has a burst PSI over 700. 6" is over 500. So go ahead and run your tire inflator without concern. Worry much more about the PSI strength of the hose you use for shower or spout attachment.
All numerical values are approximates (go exercise your OCD somewhere else) -
7.5gals / cubic foot of storage.
1gal / 231cu"
8.4 lbs / gall of water.
pi(radius squared) gives area of a circle.
4" pipe, sectional area of 12.5sq", takes about 18" of pipe per gallon stored. 6' pipe = 4gals. 8' = ~20L
6" pipe, sectional area of 28sq", about 8" of pipe to the gallon. 9gals in 6', 12gal in the 8'. But now you are talking about 100-lbs on the roof and typically on the outboard edge, wave bye bye to center of gravity.