11 Apr

Weekend at Nature Discovery Centre – Sundarvan, Ahmedabad


– A Nature Discovery Centre is like a small zoo located in the heart of the city Ahmedabad. I heard about and decided to appear personally.

How to reach Sundarvan:
Located at very odd place, I mean on a regular Satellite road you will never even notice anything like “Sundarvan” exists.

Things to do:
Sundarvan will hardly take 2 hours of yours to get you closer to nature.

Various species of birds including Peacock, ducks, love birds…; reptiles like snakes and crocodile and small mammals like rabbit, guinea pig etc you can see.
You can also check the traditional puppet show. Main attraction here is the 15 minute snake show.

Puppet Show at Sundarvan

Puppet Show at Sundarvan

At the entrance, you get to see the Ducks, a lot of them. Though the warning is given people still feed them and some of the arrogant visitors even exchange hot words with the zoo keeper when opposed.
Duck At Sundarvan

Duck At Sundarvan

I never knew something called “Love Birds” actually exists and one should actually go and visit Sundarvan to know why they’re called “Love Birds” :) Anyways they’re really colorful & beautiful & full of love :).

Love Birds At Sundarvan

Love Birds At Sundarvan

Next to it was the Rabbit’s cage which was very stingy and dirty. It was not at all in proper condition and I felt pity for them :(

A better looking Rabbit At Sundarvan

A better looking Rabbit At Sundarvan

I saw almost 5-6 peacocks, our National Bird. But guess what, I saw a lot of street dogs running behind them. I find Sundarvan is not at all safe for those Peacocks :(.

Indian National Bird at Sundarvan

Indian National Bird at Sundarvan

Best part of Sundarvan is the snake show hosted at the end of the visiting hour every weekend.

Sundarvan also has a small collection of fishes  & tortoises but with unclear glasses it’s all stopping the view. Same goes for the snake’s cages.
Well I had a lot of hopes from my visit. I even liked the efforts being done to maintain this but I’m very much disappointed by the condition of the Sundarvan. A lot needs to be done.

Web: sundarvan.org

Jodhpur Tekra, Satellite Road
Ahmedabad – 380 015
Phone : 079 – 26923148

Tuesday to Friday: 04.00 PM to 06.00 PM
Saturday and Sunday: 09.30 AM to 12.00 Noon and 04.00 PM to 06.00 PM
Monday Closed.

Wish to visit it again.

18 Feb

Extreme Movie Review-Yeh Saali Zindagi (2011)

Yeh Saali Zindagi…

Hmm… So how do you feel if I start my review from the time when the director decided to make ‘Yeh Saali Zindagi’!! That’s what happened with me; it takes too long to start the “actual”: Yeh Saali Zindagi & till that time I had lost my interest.

The movie is a story of Arun (Irfan Khan) and his one sided love for Priti (Chitrangda Singh). Arun is a partner in financial firm who first saw Priti, a club singer, during his “work” and instantly fell for her.
He helped her in escaping some financial problems initially…and as usual tried to “get closer”. In the mean time he found her “busy” with the future son-in-law of some minister; but still you know: Love Is Blind, Deaf and Dumb… and more…

The story further includes a linked-story of Kuldeep (Arunoday Singh), a local gangster and his annoyed wife Shanti (Aditi Rao Hydari). Shanti wanted Kuldeep to stay away from his such gangsta-work or from her. With help of a police-man, Kuldeep decided to “do-it” one last time and leave the violence forever.

Kuldeep & gang had plans to kidnap minister’s daughter & son-in-law but endedup kidnapping Shanti & minister’s son-in-law.
The screen displays “The Night… It all went wrong”; when they kidnap them the movie actually starts (walking). Then the story goes on and on all about how Arun kept on helping Priti until the end and how Kuldeep gets through the business.
As per the natural “predictability” of Hindi movies, you can guess, it almost all went correct.
Except Arun takes a gun-shot by “diverted” bullet but survives in the end…

I’m not sure why people liked it but I cannot tolerate complete one hour of timepass before the actual movie starts. There is nothing in the movie which is worth. The movie is full of abusive language as the script demands and unpredictably favourable ends of problems.

A few quotes (unimpressive) from ‘Yeh Saali Zindagi':
“Zindagi pe mera koi zor nahi ye to mereko samaz me aa gaya tha par kuldeep ko nahi”
“Ishq ka ek problem hai, agar ek ki lagi to dusre ki to lagni hi hai”

You’re good if you haven’t seen this; and you will get nothing by watching ‘Yeh Saali Zindagi’

01 Feb

Mad WWE Fan Destroying Kid With Chokeslam | Don’t try this

There are a lot of speculations around WWE and its effect on kids.  I personally love watching the Stars and their action and dedication towards the World Wrestling Entertainment! Though many people out there do oppose the game. They say, it increases the violence in people and fan following.

The show do warn every-time: ‘Don’t try this’ at home or at school!! But you cannot control unguided rockets :)

It goes like people start following the WWE stars; Kane, Undertaker, John Cena and the list goes on…
soon end-up in copying them without knowing the realities and hard-work behind! and ultimately ruining the WWE’s name.
In such cases if the problem is not addressed well & the child is not taken care of, it’s really a problem.
When the child grows up with such mentality, it will be something extremely tragic as happened below…

Check out how a mad WWE Fan, who is so much inspired by Kane and his Chokeslam, that he literally destroys the baby.

So mind it always…


21 Jan

Kedar’s Blog Performance Statistics-Year 2010

This post is dedicated to blog performance and statistics by analytical numbers.
So, how did the blog perform in 2010? Below is the simple statistics to explain the blog performance throughout the year.

Where did the readers came from?

Country or Territory Visits
United States 10,950
India 10,166
United Kingdom 2,628
Canada 1,395
Germany 1,286
France 1,021
Australia 958
Netherlands 797
Italy 694
Japan 668

What posts you liked the most?

Popular Blog Page Visits
load-delimited-data-csv-excel-into-mysql-server/ 5,724
mydumpsplitter-extract-tables-from-mysql-dump-shell-script/ 2,727
load-delimited-data-csv-excel-into-mysql-server 2,380
mysql-stored-procedure-split-delimited-string-into-rows/ 2,250
mysql-stored-procedure-to-generate-extract-insert-statement/ 1,873
mysql-search-through-all-database-tables-columns-stored-procedure.php 1,720
blog 1,573
search-through-all-databases-tables-columns-in-mysql/ 1,395
simple-shell-script-to-monitoring-disk-space-on-a-linux-machine/ 1,302
working-with-editplus-text-editor-regular-expression-how-to/ 1,063

What people search and land here?

Popular Keyword Visits
csv to mysql 814
no more spool space in teradata 185
mysql load data 152
mysql split string 135
mysql stored procedure 133
teradata no more spool space 132
insulting one liners 125
mysql split string into rows 124
no more spool space 115
mysql split 102

Which search engine points to the blog?

Referring Search Engine Visits
google 28,473
yahoo 437
bing 253
search 148
ask 43
aol 14
yandex 9
images.google 7
altavista 4
eniro 3

Which are the top referring websites?

Referring Website Visits
stackoverflow.com 2,987
dev.mysql.com 774
planet.mysql.com 643
google.co.in 588
google.com 543
experts-exchange.com 309
forge.mysql.com 198
facebook.com 177
blog.tsheets.com 123
google.co.uk 86

Above data for ‘Blog Statistics’ is extracted from Google Analytics.
I promise the 2011 will be more contentful in terms of topics, resources and information rich blog posts.

Thanks a ton, readers!

06 Dec

Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitiviy

Do you ever need to transfer databases between servers? Different OSes?

Two common ways of data migration:
1. Create mysqldump and load it.
2. File transfer using SCP.

Case Sensitivity and Issue:
Yes, that can create big issues when you have to deal with systems having different case sensitivity.
E.g. on linux you can create directories with names “Kedar” or “kedar” which is not possible on windows!
It will be harmful when file-system itself restricting the names to lower case.
MySQL has a variable for that: lower_case_file_system.

Documentation says: This variable describes the case sensitivity of file names on the file system where the data directory is located. OFF means file names are case sensitive, ON means they are not case sensitive. This variable is read only because it reflects a file system attribute and setting it would have no effect on the file system.

Try loading data having different values for lower_case_file_system and you will get it!

How MySQL tries to solves this problem:
It asks user to handle the issue by changing system variable lower_case_table_names accordingly.
Check the options available:
0 : Table names are stored as specified and comparisons are case sensitive.
1 : Table names are stored in lowercase on disk and comparisons are not case sensitive.
2 : Table names are stored as given but compared in lowercase.

So where do I see the problem?
Here control is given to user with the variable lower_case_table_names and ignoring which can definitely lead to issues. These issues can be avoided by putting restrictions.
Also queries working on MAC / Windows may not work well on Linux / Other Flavours; cause problems on application side.

Documentation Says: You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you set this variable to 0 on such a system and access MyISAM tablenames using different lettercases, index corruption may result.

Now, I recently read the change: PERFORMANCE_SCHEMA is renamed to lowercase in MySQL 5.5 to answer a bug [http://bugs.mysql.com/bug.php?id=57609] pointed by Marc Alff’s post [http://marcalff.blogspot.com/].

In one line I wish: lower_case_table_names, RIP!
I wish MySQL does the same for all tables in order to avoid case sensitivity problems :).

I feel MySQL should not allow upper cases. What do you think?

-- Kedar Vaijanapurkar --