good topic. I might even try some of these some time. i don't think I have anything better than what's been said, but from what I've seen, the common goldfish is pretty tough, and easy to keep, except that they keep growing. I was surprized that the first suggestion I saw was tho dojo loach. I like them, but that's the one fish i tried that I decided I could probably not keep healthy. Maybe if I didn't live in California...... I don't know. cooler temps would help, I'm sure, but maybe I got a sick or old one anyway. It it didn't last long.
I've seen plenty of sick bettas, but I also hear of them surviving a long time in a tiny bubble of plastic with no food or water changes and presumably little or no air exchange either.
I did have an imprsesive little guppy named Jarjar. (I thought Jared would be good too, but by then we were used to Jar jar.) I had moved everybody to a new tank, or so I thought. Then I found this little fryguy hiding in the gravel when I started cleaning the "empty" tank. I collected him in the same little jar I had collected a lot of the other fry in, only I forgot to take the lid off after aclimatizing and found him still in there after a week of camping. there was a pinhole in the lid, but I don't know how much that helped. I don't know what he could have eaten, if anything. I think he was one of my longest lived guppies too.
Those climbing perches are cool, but I'm not putting one in any of my tanks. Maybe if I had a zoo....
And aren't there dessert pupfish that survive in a cocoon of mucus when their holes dry up? Maybe that's just amphibians...