Posts

Ontology Linked Data

The following is a Assignment on Ontology and Linked Data and the evolution of data which lead to the use of ontology in web. Thanks to my teammates Bharath Gowda and Sravani Thota for working on the same. Ontology And Linked Data An ontology for …

Get the nth Word from a text field in mysql

I had a requirement to get the nth word out of a string and sort or order by the same. This is used when the text is stored in a purticular format and you would want to order it according to that or group it or so on. So how is it done? We do it us …

Automatic Command Archive

The default command storing size of ubuntu is 500 commands. It stores the commands in home folder in the file “.bash_history” . The problem is 500 commands is too short of a size. One method is to increase the command size to a large value by changing th …

Birthday Reminder For Gnome Panel

This program checks the file /home/rsrijith/shell/birthday_reminder.txt to find the upcoming birthdays in 20 days and writes into the file /home/rsrijith/shell/birthdays. There is a file called /home/rsrijith/shell/birthdays1, the difference between it an …

Tab Feature in Vim

Vim is one of the simplest looking but most powerful editor I have seen. So thought of listing a few interesting one that I came across. Tab Opening of Files. There are two methods of starting files in tabs. By opening vi the files you want to op …

Sort according to the nth Column in Shell Script

You have a file that has multiple columns separated by a specific delimiter and you need to sort it according to a specific column which need not be the 1st column. If its not the 1st column then ordinary sort wont work. So we need to use the parameters of …

Group by Date when Stored in Mysql DataBase as Date Time

I have a table called date_count with 2 columns one is a value and another is a date time, say called date_time in mysql. Date Time in mysql is stored as dd-mm-yy hh:mm:ss. The issue comes when I need to get the number of rows per day. As its stored as dat …