Let me qualify what I mean by self-sustaining: you'd still have to feed, maybe filter, but you'd reach a balance where you wouldn't make water changes anymore.
I was thinking of something fairly low tech, that would house a shoal of discus, a large school of tetras and a herd of corys. Very understocked I'm guessing, and thickly planted.
NOTE: I'm not planning anything of the sort, but I had a bit of free time at work and my mind started wandering a bit in this direction. I just thought I'd start an interesting conversation.
I was thinking of something fairly low tech, that would house a shoal of discus, a large school of tetras and a herd of corys. Very understocked I'm guessing, and thickly planted.
NOTE: I'm not planning anything of the sort, but I had a bit of free time at work and my mind started wandering a bit in this direction. I just thought I'd start an interesting conversation.

plants change the colour of water, on my heavy planted tanks, no matter how clear (50% weekly and 30% weekly plus5W UV on a 300L tank) the water is, if i siphon it out into a white bucket, its bright green water!