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

tosdr.org - 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 tosdr.org, 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
3. followers
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


Friday, November 29, 2013

Twitter app using perl – Part 1


Hi All,

I thought it would be nice quest to create an aap with Step by Step guide.
Here in this series , I will gonna create an app for twitter using Cpan module “Net::Twitter“.


Step 1 .
You need to create an account on dev.twitter.com and need to register your new app.

Step 2.
If you have already finished up with step one , by now you must be having following details for new registered app
Consumer key
Consumer secret
Access token
Access token secret

Tuesday, November 26, 2013

Perl special variable cheat sheet

Hi all,

Again this will be a post for the perl lover.
Recently I was browsing, I  came across the blog of Peteris Krumins blog. The blog has list of interesting article concerning Perl, awk and sed.

One of the article, that attracted my regex mind was his Perl special variable cheat sheet. His 4 page cheat sheet is really easy and collate all the special variable, you may  require play code golf. (I really did not know , Perl has that many special variable)
You can download the cheat sheet here  or from the original link.



Friday, November 15, 2013

Perl vs perl

The following discussion is an expansion on a question and answer which can be found in the perlfaq1 page of Perl's documentation, namely:
What's the difference between "perl" and "Perl"?
Sometimes you'll see "Perl" written, with a capital P, sometimes "perl", sometimes even PERL.
Confused? Not to worry, Israel.pm to the rescue :-)
The rules are actually quite simple:
  • "Perl" should be used when one is writing about the language, for example:
    Perl is a language optimized for scanning arbitrary text files, extracting information from those text files, and printing reports based on that information. It's also a good language for many system management tasks. The language is intended to be practical (easy to use, efficient, complete) rather than beautiful (tiny, elegant, minimal).
  • "perl" should be used when one is writing about the executable which interprets and compiles the Perl code, for example: the perl executable can usually be found at /use/bin/perl on Unix/Linux systems, or on c:\Perl\bin\perl.exe on Windows systems.
  • The above two usage forms are not rigidly adhered to, even in Perl's documentation, but in any case you should never use "PERL".
    "PERL" is a backronym, so unless you are going to use it as a joke, don't. It is way overused and abused, and it is time to put it to rest.
There's a famous saying, attributed to Tom Christiansen, which says that Only perl can parse Perl
We'll leave you now to ponder these words of wisdom...