Friday, July 16, 2010

Stunning stats and charts: http://www.ted.com/talks/hans_rosling_shows_the_best_stats_you_ve_ever_seen.html

Airtel's data plans are ridiculous

Airtel offers only 3 data plans with its USB Modem:

1) 350 - 500 MB free- 5/MB
2) 599 - 1GB free - 3/MB
3) 999 - Unlimited

As a customer I need to have more choices depending on my needs. They
don't have any plans for 2GB, 3 GB or 5 GB with lets say 700/800/900
as the cost. Nowadays 1 GB is nothing for surfing and I am forced to
choose the unlimited plan.

Looks like its their strategy to force the customer to choose the
costlier plan!!

Posted via email from Second Thoughts!

Tuesday, July 13, 2010

Some depressing stats on India by Alan Greenspan in 'The age of turbulence'

Below are some of the very depressing facts on India noted by Alan Greenspan in his book 'The age of turbulence'. We, IT people sitting in front of our computers think that the rest of India is also growing like Bangalore. But the picture is not as rosy as we think.
  • Owing to costly labor laws that apply to establishments of ten or more employees, more than 40% of employment in all manufacturing takes place in firms employing 5 to 9 workers. This compares with only 4% in Korea. Productivity in these small firms is 20% of large firms
  • Half of India's homes have no electricity
  • Productivity in farms is only 1/4th of what it is in non-farm areas
  • Rice yields are half of what they are in China and a third of what they are in China
  • A third of crop is reported to rot en route to market due to bad transport
  • Directly and indirectly employment in IT constitutes barely 1% of total employment in India
He notes that only manufacturing-for-export model can liberate the people trapped in villages. I have seen that trend in my village where lot of them have migrated to Bangalore mainly to work in garment industries or other manufacturing industry.

He also quotes Martin Feldstein:
"Cellphone service is widely available in India at low cost because it was regarded as a luxury and therefore left to the market, while electricity is hard to obtain because it has been regarded as a necessity and therefore managed by the government" -- WSJ, 16/2/2006

I have myself seen farmers struggling in my village as they get only around 6 hours 'good' electricity by which they can pump water to the crops. But some elderly people see it in a positive way. They think that with more electricity farmers will drain all the water from the ground (quite a possibility!!)

Posted via email from Second Thoughts!

Thursday, July 1, 2010

How to export only data using mysqldump and grep?

I just found a way to export only data using mysqldump:

mysqldump -u root -p --skip-opt --skip-set-charset --skip-quote-names --skip-tz-utc --skip-add-drop-table --skip-add-drop-table --skip-comments --no-create-info --skip-add-locks --skip-triggers databasename table1 table2 > data.sql

Now data.sql will contain only the insert statements but needs a bit of cleanup:

grep -iv '!4' data.sql > final_data.sql

This should have only insert statements and nothing else.

There might be some other better way!! but this works for me :P
Google