Background: Learnt Biotechnology, taught Bioinformatics and now doing more of Information technology!
Work: Research Program Manager [System, Network and Database Admin, Developer, Database curator, General Project Management].
Interests: Building applications (Desktop, Web and Mobile) to solve interesting problems.
Likes/+1: Linux, Python, PyQt, HTML, CSS3, JavaScript, Bioinformatics, Android, Design, Gadgets, Photography.
Built: Citebot, about:authors, VLinux, bioinformatist.org
Activities: Listening to podcasts(audio, video), reading news and books, keeping abreast of technology, watching documentaries, Indian music.
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog. Here’s an excerpt: The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 31,000 times in 2011. If it were a concert at Sydney Opera House, it would take about 11 sold-out performances for that many [...]
Some things I’ve learnt recently. Simple boolean function to check if a column exists SELECT EXISTS(SELECT 1 FROM information_schema.columns WHERE table_name = tabname AND column_name = col1) Identify duplicate values in columns SELECT key FROM tabname GROUP BY key HAVING (COUNT(key) > 1) col1 is an integer but I wanted it formatted as text in [...]
Tutorial delivered at PyCon Ireland 2011. This was a quick introduction to developing a GUI using PyQt. I used the sphinx-build command from the Sphinx documentation project as an example. The basic command for generating HTML documentation from source files is sphinx-build sourcedir outdir A GUI(dialog) was designed using Qt Designer to replicate the functionality [...]
This was a short introduction on using python with databases that I delivered to a group of visiting researchers. Slides: python-databases.pdf Code: github.com Outline Python modules for working with databases SQLite pyodbc Client software Create and connect to a database Create a table Inserting a row Inserting multiple rows Retrieving data Updating data Example using [...]
Just created a repository for the Sphinx themes I have been creating for the various documentation projects. These themes were created by modifying the base themes included with Sphinx. Here are some screenshots. Agni (means Fire) Jal (means Water) VLinux-theme (used for the VLinux project) Download Agni – agni-1.0.zip Jal – jal-1.0.zip VLinux-theme – vlinux-theme-1.0.zip [...]
CyanogenMod 7 (Android 2.3/Gingerbread) port for Milestone (RC4, but quite stable) – http://android.doshaska.net/cm7 The instructions to update are similar to what I have posted before except that there is no need to install OpenRecovery and all three data wipe options should be used including the Factory reset. NOTE: This is going to wipe out all [...]
I was trying to do this today and came across couple of different ways of including content from other documents. My first attempt was to use .. literalinclude:: but that is only good for including code or text. What I wanted was to include sections from other documents into the current document so that any [...]
Just came to know about Arista, a transcoder for Linux from the Linux Action Show. It was in the packman repo for openSUSE and I installed it while watching the show. Gave it a try on a 170mb flash video and converted it for my Milestone android phone (Droid/Milestone preset). The resulting MP4 video was [...]
Didn’t know that feature existed! http://en.support.wordpress.com/code/posting-source-code/
This is a copy of the post I made in the Boxee forums and is about compiling Boxee from source code under openSUSE 11.3. I had the required libraries installed before. Most of them can be found in the openSUSE oss or the Packman repositories. Download the latest source boxee-sources-0.9.23.15885.tar.bz2 Extract the archive cd Downloads [...]