February 2008 - binari@psb.ugent.be - maillist.psb.ugent.be

[Binari] i don't like children
by Kenny Billiau 29 Feb '08

29 Feb '08

So you should say no when it's yes! http://www.crookedbrains.net/2008/02/baby-handling-instructions.html -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] ebookee
by Stijn Vermeir 29 Feb '08

29 Feb '08

Hi, This afternoon some of us talked about where to find good javascript books. I use ebookee.com to find ebooks sometimes, I thought I'd share this information, maybe it can be of use to someone. This site contains a lot of links to (mostly illegal) scans of books converted to pdf format. Unfortunately, most of the links are from rapidshare, which I heard is blocked in the UGent domain :( -- ================================================================== Stijn Vermeir Tel:+32 (0)9 331 36 92 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM stmei(a)psb.ugent.be http://www.psb.ugent.be ==================================================================

6 8

[Binari] how trolls came to existance
by Kenny Billiau 29 Feb '08

29 Feb '08

http://www.ctrlaltdel-online.com/comic.php?d=20080227 imho this is clear example of someone not having his towel around when hitchhiking through the internet.. -Kenny -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] mysql chalange
by Kenny Billiau 28 Feb '08

28 Feb '08

Hi, I've got a real problem (without a descent solution). There are two tables, history and function, which both have their primary key on locus_id and modification_date. The table history has all versions, the table function can skip some dates. So if you want the data from function you will need the one with the modification_date which is the closest the modification_date of history. I'm trying to get locus_id, the latest modification_date (both from history) and a definition (from function). You can try on real data: host: psbsql01 table: bogas_ectsi_tmp user: bogi pass: bogi I had this, but the problem with this query is that we are selecting all rows with a modification_date <= histories modification_date. Afterwhich the group by doesn't really know what record to keep. SELECT h.locus_id, max( h.modification_date ) AS `date` , definition FROM history AS h JOIN FUNCTION AS f USING ( locus_id ) WHERE annotator_id =2 AND f.modification_date <= h.modification_date GROUP BY locus_id ORDER BY `date` DESC LIMIT 0 , 30 A correct answer should be when definition has 'this is a valid definition' instead of 'n/a' for locus_id Esi000_0010 -Kenny -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

3 5

[Binari] lost-promises-two-more-boring-seasons
by Kenny Billiau 28 Feb '08

28 Feb '08

http://io9.com/361121/lost-promises-two-more-boring-seasons great :/ -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] lost season 1
by Sofie Van Landeghem 26 Feb '08

26 Feb '08

Does anybody have the first season of Lost? I have seasons 2 and 3, and the start of 4, so I'd like to have 1 as well :-)

4 4

[Binari] ritual of passing
by Kenny Billiau 25 Feb '08

25 Feb '08

Hi, eventhough thpar has more charisma then the newly hired Stijn, should we convince the new guy to make he giant tux? Maybe his puppy eyes can convince Karel as easy as a pint of beer would. -Kenny -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

3 4

[Binari] funny nick
by Sofie Van Landeghem 22 Feb '08

22 Feb '08

This must be one of the funniest nicks I've encounterd so far : "Tepelstreeltje" (sorry, Dutch reference...)

1 0

[Binari] Perhaps interesting to ask Yves
by Michiel Van Bel 21 Feb '08

21 Feb '08

Hey, this is a reason for Yves to give us all a Geforce8 :) http://www.biomedcentral.com/1471-2105/8/474/ -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.ugent.be http://www.psb.ugent.be ==================================================================

1 0

[Binari] Caffeine: A User's Guide to Getting Optimally Wired
by Kenny Billiau 13 Feb '08

13 Feb '08

http://scienceblogs.com/developingintelligence/2008/02/optimally_wired_a_ca… -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0