Aquaponics sounds like the way to go. See "Backyard Liberty: The smart, easy way to food independence", available on the Interrnet.
Dr, Arthur B. Robinson, a research chemist at the Oregon Institute of Science and Medicine, recommends a ration of one part soybeans, two parts corn and two parts wheat (by weight). Plus vitamin C and salt (sodium chloride). The vitamin C can be omitted if some of the wheat is sprouted. Stored in a cool, dry place as whole grains, this ration will last for decades and costs very little. This ration is in the FEMA public literature, according to him.
If you do not have a well, check out LifeSaver at
http://www.lifesaversystems.com/I have one of their jerry cans.
Where to be when TSHTF? Near a military base. Preferably a Marine camp.