Saturday, April 12, 2014

SQL Fiddle - Cloud way test your query and schema.

Most of the times, we are in need to validate our query with the test data for validation purpose and proof of concept.
Recently I came across the SQL Fiddle and got hooked to it to validate my query to match the expected results.

SQL Fiddle not only provide list of database including oracle and also a new cloud base tool to validate your query and sharing your schema over various forum

Tuesday, April 8, 2014

Overriding the core function/ subrotine in perl

Though its not recommended but some times we are in need to change or extend the core functionality of inbuilt Perl function/ subroutine.

This can be easily implemented in the following way. I have created a small gist for changing the core functionality.( Just for fun)

You can read it more in perdoc .

Tuesday, March 25, 2014

Interview experience for perl developer with

Recently I had an opportunity to give the interview for for perl developer.

I got the call from the HR after 2 week from the CV submission date. Initial HR round was very simple . Introduction about the company and kind of work you are expected to do, the team strength etc

The online interview with the technical people was arrange after 2 people with 2 perl developer. The interview was about perl.

Saturday, March 8, 2014

Learning the SQL by practising online - SQLZOO

SQL is standard language to access and manipulation data in MySQL and Oracle.

Although SQL is quite easy to learn and has limited syntax, but the concept of using mainly DDL (Data Definition Language) ,DML (Data Manipulation Language) and DCL (Data Control Language) take time to understand or to get accustomed to make use of  when it is required. (ref)

As far as , Learning SQL and grasping the syntax may be quite easy to begin with (lot of online resource are there) , but to get the required data for the  real world problem might be not that much easy and may require practice.

SQLZOO is website where you have opportunity to practice these problem, to sharpen your skill and to test what you have acquired. The best thing of this website , it support all type of database engine (Oracle, MySQL etc) and has many problem to practice.

Problem start with a scenario and will ask you to use specific DML , to get the required results.

Great website to start with your SQL training and hone your ability.

Wednesday, January 1, 2014 - a new initiative to explain the goods and hidden bad in the service terms you are signing

Now day We are signing new account now and then.  Each service provider has it own sets of "term of service". These terms are bulky and  usually ignored by the end user before signing.

Now a new initiative called, can help know the goods and hidden bad in simple layman terms about the service , you are about to signed or have signed already. They have simple rating system very good A to very bad (E).

Friday, December 6, 2013

Twitter app using perl – Get your following – Part 3

Hi Again,

If you have seen the your twitter page , you will find the following tab about the user.

As U can can see in the image , there are four important tab
1. tweet (your own tweet)
2. following
4. list

Saturday, November 30, 2013

Twitter app using perl - Tweet your status - Part 2

Hi All,
The second part will be simple to update your own status using the perl script.
For that initially, you need to go setting tab.

Under the setting tab, change the permission setting for your app to read , write and acess direct message as given below