LOL
Waterdrop's lead-up to this sounded like we were heading for the great debate
The First Sera Denitrator was around in the late 1980s and cost about $400AU. Its newer form was still available a couple of years ago in my LFS for a similar price.
They are a very simple device, so simple in fact I don't know where they get off charging so much money for them. Mine (the first model) was a brown plastic case with a number of partitions in it. In the partitions were plastic filter fibres designed to hold bacteria. The fibres look a lot like the Eheim filter fibres used in canister filters. The case had small hooks moulded onto it that allowed the filter to hang on the edge of an aquarium. I ran mine along the back of the tank. The filter is about 2ft long, 14inches high & 4inches wide.
Water was dripped in one end and went up and down thru the chambers before dripping out the other end. Each day I would drop in a carbon tablet and that fed the anaerobic (lacking oxygen) bacteria living in the filter. The bacteria used the carbon to help break down the nitrates and convert them into nitrogen gas among other things. The end result was clean water, (free of nitrates).
I worked out over time I only had to add 1/4 tablet each day because the load on my tank was pretty low anyway. I also used ethanol for a while and that worked too. Ethanol is alcohol and the bacteria use the carbon in it to help their processes.
The newer models were more square rather than rectangular. They worked on exactly the same principle with water dripping in, anaerobic bacteria eating the nitrates and clean water dripping out the other end.
I recon you could make one out of an old external canister filter. Just have some media in it and have the inlet pipe a couple of inches higher than the outlet/ return hose. Drip water into the inlet pipe and gravity will do the rest. You don't even need the motor running for it.
It takes about 48 hours for the water in the filter to become anaerobic and a couple of weeks before the bacteria have built up in numbers. It's a bit like cycling a tank except you get anaerobic instead of aerobic (requiring oxygen) bacteria living in the filter. Then you require a carbon source.
The carbon tablets were pretty expensive to. They cost about $25AU per container and they only held about 30 tablets, I think. I know it was quite expensive running it hence the reason I only used 1/4 tablet and then went on to Ethanol.
Marine tanks have been using another way of removing nitrates. They use big pieces of live rock. The rock is aerobic on the outer 1-2 inches but becomes anaerobic once you get in more than 2 inches. In the middle of these rocks live anaerobic denitrating bacteria that convert nitrates into nitrogen gas.
They also use deep sand beds which consist of a 5-6inch layer of sand that becomes anaerobic below the surface. Again the top layer of sand is aerobic but everything below an inch or two, (depending on how coarse the sand is) becomes anaerobic. The water slowly passes thru the rock or sand and the bacteria convert the nitrates.
I believe a similar thing could be achieved in freshwater using a sump (tank under the main tank) that is full of big pieces of porous rock. The water would pass thru this and eventually denitrating bacteria would become established and help keep the water clean.
The other way of removing nitrates is to grow plants. In marine tanks sumps are often used to grow macro algae that utilise vast amounts of nutrients. This limits the amount of nitrates that can build up. In freshwater tanks plants are often grown but it is usually only in the heavily planted tanks that we see a major reduction in nitrate levels. A sump could be used to grow plants in tanks that have vegetarian fishes or fishes that dig them up.
Many floating plants are superb at utilising nitrates. Duck weed and Azolla are considered a scourge by many aquarist but I love them both. They do an impressive job at removing nutrients from water. Water Hyacinth is one of the best plants for using nutrients.