How to fail your deadline? – Starting learning MySQL thinking you can master it in one day!

[#### 1. How to fail your deadline? – Starting learning MySQL thinking you can master it in one day!]

Recently, I touched upon MySQL because I wanted it to be the backend for my incoming Django-based data browser. After 4 days of prolonged fiddling I finally manage to make some notes of its functionality. It is very fast, but equally importantly, very different from Python! The other lesson is that one should allocate enough time for learning when starting a new language (depending on [single linkage distance](https://en.wikipedia.org/wiki/Single-linkage_clustering))

Today’s blog will go through:
1. Loading a table into MySQL, be it fixed-width or regularly delimited.
2. Create relations between entries.
3. How to deal with errors, and fix your relationship:

Continue reading “How to fail your deadline? – Starting learning MySQL thinking you can master it in one day!”

Python modules are fun, once you understand it


[#Python modules are fun, once you understand it]

#### Brief:
Having the privilege of joining Orengo’s group as a summer student, I feel urged to improve my coding as well as documentation skills. Thus I intend to log my coding and thinking in a series of blog posts, on a weekly basis.

Today’s blog post will cover some basics of organising Python code, in the hope of easing future maintenance. We will go through:

Continue reading “Python modules are fun, once you understand it”

amazon cloud

Theres a nice new tool for using the Amazon Cloud:

http://star.mit.edu/cluster/index.html

 

The same group also have a PDB viewer:

http://star.mit.edu/biochem/index.html

migrating home directory files using dolphin

This is one convenient way you can start to move your old home directory files over to new home directories:

1) If you havent got ian to activate your UCL account then do so.
2) login to your machine as your ucl user
3) start dolphin &
4) right click on the ‘places’ column of the dolphin window
and click ‘add entry’
5) in the resulting pop-up window put in the remote location of your home directory:
e.g.
label: old_home
Location: sftp://username@bsmlx**/home/bsm3/lees
substitute username and ** as appropriate

6) click split at the top of the dolphin window to give you a split screen
Then click on your new home directory in the places directory and
start copying things over.