Posts

Who is best with MySQL? R or Perl or Python: A benchmark

I really surprised to see R talks better with MySQL than Perl or Python!!!... I thought R might be slow in querying MySQL database. But I have a different answer here. Following is the code used for this demo. R script: library(RMySQL) test <- function(){          con <- dbConnect("MySQL", host="genome-mysql.cse.ucsc.edu", user ="genome", dbname = "hg18")          rs <- dbGetQuery(con, "select name, chromEnd from snp129 where chrom='chr1' and chromStart between 1 and 1e8;")          return(rs)          dbClearResult(rs)          dbDisconnect(con)         } print(system.time(test()))    user  system elapsed   0.372   0.039  25.729 R took 25.729 seconds to retrieve half million records. Python script: f...

CollabNet: a Subversion client for Netbeans

As of now it is hard to find CollabNet debian package. Hence, I went back to traditional way of installing .rpm packages available for CollabNet. A simple guide is presented here for you, Firstly install alien package which converts .rpm packages to .deb sudo apt-get install alien then, download http://downloads-guests.open.collab.net/files/documents/61/921/CollabNetSubversion-client-1.5.1-2.i386.rpm Run, sudo alien --to-deb CollabNetSubversion-client-1.5.1-2.i386.rpm this will convert .rpm to .deb then run, sudo dpkg -i collabnetsubversion-client_1.5.1-2_i386.deb Now, configure Netbeans with SVN. Go to Netbeans > tools > options > set the proxy (check whether you need it or not) Then, tools > options > select Versioning (Subversion) > miscellaneous > provide SVN executable path (often /usr/bin or /usr/local/bin) then, go to Team > Subversion > Check out > Mention SVN repo URL (http://your_repo.org/svn/ProjectName/trunk) Finally, select the check out folde...

Multiple repos in SVN

I was about to start a new project, MGenome and hence started to work on SVN. Setting up SVN worked out fine with MGenome. Later, ended up with thinking, if I start yet another project how to create another repo? googled so much.. found..some hints... copied hints from here and there.. Now here is complete way to do it. sudo apt-get install libapache2-svn vi /etc/apache2/mods/enabled/dav_svn.conf ‹ Location /svn › DAV svn SVNParentPath /home/svn AuthType Basic AuthUserFile /home/svn/passwd ‹ \Location › Now, any project inside /home/svn/ will be accesible

htop: better than top

htop is more interactive than top to view job process in linux. Install it in Ubuntu with apt-get install htop. for more info visit, http://htop.sourceforge.net/index.php?page=main

Barcamp5 - As I have seen!!!!!

I visited Barcamp5 , held at IIM, Bangalore. It was a wonderful Tech. conference. Talks were bidirectional... advanced... and critic too. The first event which I got into was eXtreme programming. Mr. Kethan Padongoer, Bug producer, from ThoughtWorks shared his experience on Cruse Controller, a SVN testing tool with demo. Mr. Naresh jain, from agient soft shared his experience with Junit with demo. To be frank loved a lot an unconference, barcamp!!!