Monday, March 29, 2010

AIR PUMP / FILTER DIY


http://www.pet-expo.com/trivia/aquariums-pumps.htm
http://www.petsnpets.com/index.php?main_page=index&cPath=61_82_83

Manufactures of powerheads rate their "pumps" based on gallons per hour (GPH). A rating of 120 GPH means that the pump will move 120 gallons of water in an hour.

To determine the correct powerhead for your system know that most experts conclude that a healthy environment requires that the water be completely circulated at least five to six (5-6) times an hour. Therefore if your aquarium is 20 gallons, you should choose a powerhead that will pump 20 gallons times 5 (20x5) or at least 100-120 GPH. Choosing a powerhead that moves as much as 10 times the actual water volume of your aquarium is certainly acceptable.

************************************************************
http://www.petfish.net/articles/Do-It-Yourself/sponge_filter.php



Material List:

8 inch length of 1/2 inch or 3/4 inch PVC pipe (Lowes, Homedepot) approx $2.00 for a 10 foot pipe
4 inch by 4 inch block of foam rubber (different sizes available from Lowes, Home Depot or Walmart etc) Very cheap.
8 inch length of rigid airline tubing (Available at Petsmart for about $2.00 for a 4 foot length)
Marbles, slate or rocks to use as a weight for the filter
Silicone for glueing the parts together

Notes On Construction:
These filters can be made in bulk quantities faster and cheaper. Be sure to get "open pore sponge", to be sure that's what you have you can try to blow thru the sponge, if you can, it's open pore = good, if you can't, it's closed pore = bad.
Making the uplift tube:
Cut the PVC pipe into 8 inch lengths. On the bottom of the uplift tube drill a few holes to allow the entrance of water into the pipe from the sides. You can either drill holes or use a hacksaw to cut slits, either way is fine.
Silicone the rigid airline tubing on to the inside of the uplift tube. An alternate way to accomplish this is to drill a slanted hole so that the rigid tube can be slightly bent and forced to the bottom of the uplift tube. Natural friction will hold fast the rigid airline tubing.
Cut up the sponge into 4 inch cubes, larger or smaller, it's up to you.
Cut or drill a hole in the sponge to snugly accept the PVC uplift tube. One way to do this is to wet the sponge and freeze it to allow easier drilling. I find that just plunging a razor knife into the dry sponge works quite well. Be very careful.
The sponge is going to naturally float until it is well water logged, that's why the marbles or slate is used as a weight to help hold the sponge on the bottom of the tank.
I prefer to silicone a piece of slate or tile to the bottom of the sponge filter.
(I have found that hot glue will come undone under water, but your luck might be better, or I might have the wrong kind of hot glue)
Now hook your filter up to an airpump and it's ready to start filtering.
A quick way to populate the sponge filter with "good guy" bacteria is to run it a week or 2 in a tank with an established sponge filter. Or squeaze an established sponge filter in the water of the new tank so that the new filter will suck up the bacteria released from the established filter.
These filters are very efficient. One of these in a 10 gallon tank will supply all the filtration required to keep it clean and balanced. The costs of these filters if made in quantities of about 10 at a time will be under $2.00 each. Pretty good deal huh?

Saturday, March 27, 2010

Scripts

http://arunrathod.blogspot.com/search?updated-max=2009-06-10T21%3A41%3A00-07%3A00&max-results=7

Friday, March 26, 2010

Acrylic Aquarium

--------------------------------------------------------------------------------

If you are willing to transport it from Goregaon-E (w.exp. highway) to Yari road, you can get in touch with Shekhar (9987509762, 9869480313) He is quite reasonable and he can also make a nice acrylic hood for you as per your requirement along with lighting fixtures.
His shop (Tanvi Aquarium) is bang on the highway, left hand side if you are travelling north (opposite SRPF camp)
You can give my reference if you want.

http://borneosucker.blogspot.com/search?updated-max=2009-11-03T15%3A49%3A00%2B08%3A00&max-results=7
--------------------------------------------------------------------------------

Best site : http://www.aquarticles.com/articles/management/Gopi_Making_an_Acrylic_Aquarium.html

http://www.procurefast.com/index.php?page=shop.product_details&flypage=flypage.tpl&product_id=83&category_id=28&option=com_virtuemart&Itemid=1

http://www.princeplastics.com/eng_careerpopp.htm


Aquarium Height Sheet Thickness
1 to 12 inches 1/4 inch
12 - 18 inches 3/8 inch
18 - 24 inches 1/2 inch
24 - 30 inches 3/4 inch


1mm = just over 1/32 inch
2mm = just over 1/16 inch
3mm = almost 1/8 inch
4mm = 5/32 inch (= a bit over 1/8 inch)
5mm = just over 3/16 inch
6mm = almost 1/4 inch
7mm = almost 9/32 inch (= a bit over 1/4 inch)
8mm = 5/16 inch
9mm = almost 3/8 inch
10mm = just over 3/8 inch
11mm = almost 7/16 inch
12mm = almost 15/32 inch (= almost 1/2 inch)
13mm = just over 1/2 inch
14mm = almost 9/16 inch
15mm = almost 19/32 inch
16mm = 5/8 inch
17mm = almost 11/16 inch
18mm = just over 11/16 inch
19mm = 3/4 inch
20mm = 25/32 inch
21mm = just over 13/16 inch
22mm = almost 7/8 inch
23mm = 29/32 inch
24mm = just over 15/16 inch
25mm = almost 1 inch

Thursday, March 25, 2010

STARTER FISH

http://www.aqadvisor.com/AqAdvisor.php
http://www.fishforums.net/index.php?/topic/277264-beginners-resource-center/
***********************************************
Good Freshwater Fish for Beginners

Here is our list of freshwater fish that would be great for the beginner to start with. For pricing purposes, we used the LiveAquaria.com site.


Anabantids (Bettas and Gouramis) Bettas are also known as Siamese Fighting Fish (as in the fish that will attack its own mirror image). Bettas and Gouramis are beautiful labyrinth fishes meaning that they get air at the surface of the water through a labyrinth organ. The downside with male Bettas is that you can only keep one Betta male in a tank (you can have other fish but no other male Bettas). Gouramis are usually peaceful additions to the community tank. Price range for Bettas is $2.49 to $6.49. Price range for Gouramis is $2.49 to $12.99.
Cichlids. There are so many different Cichlid species, that you will have no problem picking one that suits your aquarium. Cichlids can get large and are territorial during breeding season. They can be prolific in captivity? Price range for African Cichlids is $5.99 to $39.99. Price range for New World Cichlids is $3.99 to $59.99.
Cyprinids (White Cloud Mountain Minnow, Zebra Danios, Rasboras, and Cherry Barbs) These little guys are hardy. You will find tons of color and pattern variations. You will also enjoy watching their schooling behavior. If you had to pick one fish to start with, you could not go wrong with a White Cloud Mountain Minnow. Price range is $1.29 to $7.99.
Livebearers (Guppies, Platies, and Swordtails) These beautiful fish will stay small (under 3 inches for the most part) but that is not the only thing about these guys that makes them a great pick. Brilliantly colored and happy in the community tank, these peaceful fish are extremely easy to keep. Out of all the starter fish, they are the easiest to breed in captivity. Guppies look like they should cost way more than their going price; you'll easily get excited about these fish. Price range is $1.99 to $5.99 to $34.99.
Tetras are so cheap it is practically criminal! Tetras are great additions to the community tank and their vivid colors will attract your attention every time they dart around in their little schools. Price range is $1.49 to $7.99 with most of them in the under $3 range.
Loaches are bottom dwellers that differentiate themselves from most of the fish in this list. They are more secretive; they tend to hang out alone, with many being nocturnal. Loaches require currents in the water as they are stream dwellers in the wild. They will also take care of your snail population if you have a problem with it. Price range is $2.99 to $13.99.

-------------------------------------------------------
http://fins.actwin.com/mirror/fish-popular.html
-------------------------------------------------------
Zebra Danios is indeed one of the best choices. There's one time, i've poured in ammonia at the same time as putting them in a 75-gallon tank. Problem was, i overdosed. Probably 3-4 times the MAXIMUM of what an Ammonia Meter can normally measure. 5/6 died instantaneously, but the 6th one never died. This shows how hard a Zebra Danio can really be.
But make sure you have a lid with them. They do jump out. And they super fast.

Another choice is Guppies. I've cycled a tank with 14 guppies before. At the end of the cycle., NONE of them died. It might be luck, or probably because i was paying REALLY close attention to the tank.

I've had 2 guppy fry raised in an ice-cappuccino cup till adult form. I've moved them into a 5 gallon now, 2-years old, still living.

So my conclusion is, Guppies and Zebra Danios are the hardiest freshwater fishes you can find and are best candidates for Fish Cycling. However, I suggest Fishless Cycling, since it's a faster, can put in tons of fishes at once at the end, and no risk of scarifying fish.

********************************
pygmy cories
copper harlequin rasboras
cherry barbs
Cardinal/Neon tetras are about the most common fish that beginners want to include but that we like to advise that people wait on. For some reason they do much better after the tank has aged 6 months regardless of cycling.
Neon tetras don't always do well in new tanks, not sure why but they have a higher death rate in new tanks. If you can avoid adding them first then do.

SMALL TROPICAL FISHES

http://www.aquariumpros.com/articles/fishcyclefw.shtml
http://aqualandpetsplus.com/Minnows,%20Danios.htm

Guppies.
look up cycling a tank before you go off and buy some guppies they WILL DIE if you do not cycle your tank

neon tetras*****
they are middle level swimmers, but you need to buy at least 6 or more as they are schooling fish. there about 1/2 inch or smaller and non-aggressive.
Not good for Cycling

Philippine goby

Zebra Danio
Good for cycling
Danios insist on being in schools. The more the merrier.

albino Corydoras
Catfish Males smaller than 2 inches, females larger
While almost all Plecostomus species feed on algae, they too need a varied diet.
Not to be added w/o cycling

How to do Fishless Cycling

By Cichlid dude at http://answers.yahoo.com/question/index?qid=20090402233249AAdp1hP


Ammonia is introduced into the aquarium via fish waste and uneaten food. The fish waste and excess food will break down into either ionized ammonium (NH4) or un-ionized ammonia (NH3). Ammonium is not harmful to tropical fish but ammonia is. Whether the material turns into ammonium or ammonia depends on the ph level of the water. If the ph is under 7, you will have ammonium. If the ph is 7 or higher you will have ammonia.

Stage 2
Soon, bacteria called nitrosomonas will develop and they will oxidize the ammonia in the tank, essentially eliminating it. The byproduct of ammonia oxidation is Nitrites. So we no longer have ammonia in the tank, but we now have another toxin to deal with - Nitrites. Nitrites are just as toxic to tropical fish as ammonia. If you have a test kit, you should be able to see the nitrite levels rise around the end of the first or second week.

Stage 3
Bacteria called nitrobacter will develop and they will convert the nitrites into nitrates. Nitrates are not as harmful to tropical fish as ammonia or nitrites, but nitrate is still harmful in large amounts. The quickest way to rid your aquarium of nitrates is to perform partial water changes. Once your tank is established you will need to monitor your tank water for high nitrate levels and perform partial water changes as necessary. There are other methods to control nitrates in aquariums besides water changes. For freshwater fish tanks, live aquarium plants will use up some of the nitrates. In saltwater fish tanks, live rock and deep sand beds can have anaerobic areas where denitrifying bacteria can breakdown nitrates into harmless nitrogen gas that escapes through the water surface of the aquarium.

Getting The Nitrogen Cycle Started
There are two ways to get the aquarium cycle started, either with fish or without fish.

Starting The Nitrogen Cycle With Fish
This is not the preferred way to get the nitrogen cycle started because the fish are being exposed to ammonia and nitrites during this process. Many fish can not and will not make it through the cycling process. Often times the fish become stressed and fish disease starts to break out. I wonder what percentage of disease is caused by the cycling of new aquariums?

Certain species are hardier than others and seem to tolerate the start-up cycle better than others. For freshwater tanks, the zebra danio is a very hardy fish that many use to get the nitrogen cycle started. For saltwater tanks, some have reported success using damselfish to get the process started. Again, using fish to cycle is not a good idea and you may be throwing your money (on dead fish) out the window. There is a better way. Read on, young grasshopper.

Starting The Nitrogen Cycle Fishless
There are a few different ways to get this process started. To easily get an ammonia reading from your tank water try the Seachem Ammonia Alert. It sticks inside the tank and has a circle that changes color depending on the ammonia levels in the tank.

Option 1:
Using Fish Food
Drop in a few flakes every 12 hours. As the food decomposes it will release ammonia. You will have to continue to "feed" the tank throughout the process to keep it going.

Option 2:
Use a small piece of raw fish or a raw shrimp
Drop a 2 inch by 1 inch chunk of raw fish or a raw shrimp into the tank. As it decomposes it will release ammonia into the tank.

Option 3:
Use 100% pure ammonia.
Using a dropper, add 5 drops of ammonia per 10 gallons of aquarium water. If you don't get an ammonia reading with your test kit, add some more drops until you start to see an ammonia reading. Keep track of how many drops you've used so you can repeat this process daily. Continue to dose the tank with ammonia until you start to get nitrite readings with your test kit. Once you can detect nitrites you should only add 3 drops of ammonia per 10 gallons of aquarium water, or if you added more drops originally to get an ammonia reading cut the amount of drops used in half. Continue this process daily until you get nitrate readings with your test kit. Do a 30% water change and your tank is ready.

Option 4:
Use gravel and/or filter media from an established and cycled tank
This is the best and fastest way to go. This will seed the tank with all of the necessary bacteria for the nitrogen cycle. "Feed" the tank daily with flake food until you are getting nitrate readings. Depending on how fast you were able to get the gravel and filter media into your tank, you may be getting nitrate readings in only a day or two. There are some drawbacks to this method. Ask your source if they have recently used any copper medications in the tank. If they have and you are planning to have invertebrates in the tank you should probably not use this method. Invertebrates will not tolerate copper. Get a copper test kit to determine if it's safe to use.

Good luck!!!~~~~<><~~~~><>~~~~


To Make Cycling Faster

http://www.bluecrayfish.com/cycle.htm


2. Keep the tank only about 50-65% full. This creates a waterfall effect as the water leaves the filter, and when the water from the filter hits the surface of the aquarium water, there is a great deal of water turbulence, exposing more water to more air more quickly, and leading to increased oxygenation, and thus, faster cycling.

3. Keep the aquarium light on 24 hours per day during cycling. Only do this if you have no pets in the aquarium which need less light, or which need darkness. The increased light leads to faster cycling.

4. Use as many air stones and air pumps as you have access to, which will fit in the aquarium. Keep them all running all the time. This leads to increased oxygenation, which leads to faster cycling. Only do this if you have no pets in the aquarium which need calm, or still water.

5. Keep the filter running the entire time the aquarium is undergoing the cycling process. This increases water flow, and insures that good bacteria build up in the filter material, both of which lead to faster cycling.

--------------------------------------------------------------------
2 Sunset platies require 100 bacteria to process their waste
5ppm of ammonia requires 10000 bacteria to process it's waste.
9900 bacteria would die when you added just 2 sunset platys.

Then when you added 4 shrimp and 4 corys imagine they took around 500 bacteria to process their waste. Well that 100 would have to double 5 times before the ammonia would be kept stable, and then it would take additional times for them to actually remove ammonia+nitrite from the water.

However if you add a large group alltogether then you keep most of your bacteria colony hopefully.
And so when you then add new fish, it should hopefully only need to double once to produce sufficient numbers to process waste.
That way you will never risk seeing an ammonia spike.
Eitherways there is certainly no point in waiting 2weeks, you could add fish every couple of days as it will have definitely caught up by then


Luckily I have reread the article on cycling. I had inconveniently forgotten that the nitrite had to be getting to zero within 12 hours also. I couldn't understand why the nitrite level wasn't going down when the ammonia was disappearing after 12 hours. I now realise we are only half way through cycling!

I wasn't aware that the bacteria would be dying if they weren't being fed by ammonia so I will take your advice and once we are fully cycled we will virtually fully stock. Thanks again.

*************************************************************

) Buy liquid testing kits for ammonia and nitrite
2) Buy pure ammonia (from a hardware store or department store)
3) Add enough ammonia to the tank to read 5ppm (parts per million) or5 mg/l (milligram per litre) on the test kit.
4) Test every day for ammonia and always add enough ammonia to keep the levels at 5ppm or 5 mg/l
5) Keep testing until you see the levels of ammonia reach zero within 12 hours of adding new ammonia
6) Start testing for nitrite and ammonia, and keep adding new ammonia if you need to
7) Keep testing for both until they both reach 0 after 12 hours
8) Do a very large water change (90%)
9) Add fish

*************************************************

Friday, March 19, 2010

Remove ^M characters at end of lines in vi

To remove the ^M characters at the end of all lines in vi, use:

:%s/^V^M//g

The ^v is a CONTROL-V character and ^m is a CONTROL-M. When you type this, it will look like this:

:%s/^M//g

In UNIX, you can escape a control character by preceeding it with a CONTROL-V. The :%s is a basic search and replace command in vi. It tells vi to replace the regular expression between the first and second slashes (^M) with the text between the second and third slashes (nothing in this case). The g at the end directs vi to search and replace globally (all occurrences).

Thursday, March 18, 2010

sql-excel

Well, if you are on unix then using the method in the link that I posted.
You need to list down the names of the tables in a file suppose list.txt
you can use the following shell script to generate spool of various tables in xls files.
cat list.txt | while read a
do
echo "spooling $a"
sqlplus username/password@string <set feed off markup html on spool on
spool /home/oracle/$a.xls
select * from $a;
spool off
set markup html off spool off
EOF
done


set feed off markup html on spool on
spool c:\salgrade.xls
select * from salgrade;
spool off
set markup html off spool off

Tuesday, March 2, 2010

Playback

A final note, make sure you adjust your display resolution to the native resolution of your TV. Most TV’s are 720p or 1080p, which in computer resolution terms are 1280x720 or 1920x1080, respectively. This will ensure the highest quality picture for you and your family.

Read more: http://www.brighthub.com/electronics/home-theater/articles/36197.aspx#ixzz0gzlvYTs3


DMI has quickly become a popular request for users who read about all the features it brings - most notably its ability to carry both audio and video over a single cable. Since most older systems do not include an HDMI port, the first step needed will be to upgrade your graphics card to a new one that does. For graphics solutions there are two players: Nvidia and ATI. Both manufacturers produce video cards with HDMI ports (or DVI ports with HDMI adapters), but Nvidia does not have it’s own sound chip on board. What that means is that the Nvidia is merely a pass-through of the S/PDIF audio. If you only have a 5.1 surround sound setup, then this is acceptable. For users with newer 7.1 surround sound setups, ATI will be the only graphics card of choice. The ATI contains a dedicated sound chip on-board which allows for support of up to 7.1 multichannel audio over the HDMI cable.

The other critical piece of information necessary is to ensure you have an available port on your motherboard to support the video card. You can refer to your motherboard or computer documentation for this information if you do not know. Basically, there are two standards. These are the older AGP connection and the newer PCI-Express. Any computer built in the last 2-3 years should have a PCI-Express slot. If you only have AGP, upgrading may be more difficult as the number of AGP cards with HDMI ports is quite limited and may cost more. If that’s the case, you may be better suited for a complete system overhaul or re-purchase.

Read more: http://www.brighthub.com/electronics/home-theater/articles/36197.aspx#ixzz0gzmoOchO