Noah the Survivor

We trace three episodes in the midrashic life of Noah,  his father’s hope for him (Rashi: inventor of the plow), his wounding by the lion (either inside or on exiting the ark) and subsequent impotence, and his planting of the vineyard (with Satan) and inebriation.How do these connect and how do they inform him and us as to the dark side of technology as a solution to the cursed ground?