Water repellant

I'm generally quite fascinated with the process of making something waterproof, which I generally attribute to leaky boots in the snow.  I found this on Core77 today, and must look into it a bit more.  What is this 'super water repellant' stuff made out of?  And how is applied, and most importantly where can I get some.