Scribbles & Snippets
... of low and no utility ...

Latest Posts

Running Cromwell on AWS/Batch
- Posted: 2018-11-21.

Parallel mysql myisam repair
- Posted: 2018-11-21.

Does a TKI like Crizotinib kill tumor cells ?
- Posted: 2018-10-28.

Save Spotify to flac or mp3
- Posted: 2018-07-14.

Replace all symlinks by the original file
- Posted: 2018-03-02.

Log in

: User
: Password

All Entries On Perl

A total of 16 entries were found. Click on the titles to read the posts.

  • Install CPAN modules only if not yet present (2011-06-16 - Geert Vandeweyer)

    I needed a way to check if a certain CPAN module is present on the system/path, before installing the module again. This way I wanted to prevent that newer versions of mdoles were installed by an i...

  • commandline timer with osd_cat output (2011-07-19 - Geert Vandeweyer)

    This simple timer script is executed from the commandline and takes two inputs. First a timer name, second a time indication in hours and/or minutes. 

    It sends output to the screen usi...

  • Converting EndNote to BibTex (2011-09-01 - Geert Vandeweyer)


    Converting end note references to bibtex is a pain. However, some steps can be automized to make it a least bearable. The steps below are no guarantee the result will be perfect, but ...

  • Perl: next character in alphabet (2011-10-17 - Geert Vandeweyer)

    The following snippet gets the next letter in the alphabet given the input character. Replace the alpha-string with uppercase or any other sequence of characters if needed. 

    # do...
  • Batch Paired-End File Interlacer (2012-07-18 - Geert Vandeweyer)

    Creating Interlaced Paired-end data

    Galaxy is a great platform to analyze next-generation sequencing data in non-cli manner. Currently, it has a few major drawbacks. One of those is the in...

  • Batch Workflow starting using the Galaxy API : Practical Example (2012-11-02 - Geert Vandeweyer)

    Galaxy is a very powerfull interface to the analysis of Next-Generation-Sequencing data. On the other hand, it has some drawbacks. On of the major ones is the inability (for now) to run workflows o...

  • Enable LOAD DATA LOCAL INFILE on Ubuntu 12.04 (2013-01-30 - Geert Vandeweyer)

    On my ubuntu 12.04 LTS server, I noticed that I could not run the following mysql command anymore: 

  • Bash oneliner: Sum Disk Usage for files based on age (2014-06-13 - Geert Vandeweyer)

    Command of the day : Get a recursive disk usage for files older than a specified age. 



    find . ...
  • Retrieve large batches of rows from mysql (2014-10-28 - Geert Vandeweyer)

    The following snippits are some approaches for rapid high performance fetching of vast amounts of rows from a mysql database. All of them should reduce the load on the mysql server and increase the...

  • warning setting locale failed (2016-03-31 - Geert Vandeweyer)

    The following two commands fix the messages upon ssh-login to remote hosts regarding missing locale variables.


    The Errors: 

  • Recovery of corrupt XFS partition. (2016-05-10 - Geert Vandeweyer)

    We had a large XFS partition that went corrupt after a memory hardware failure. Containing 45Tb of data and no backups, we were eager to retrieve the data in some way. 



  • Automate CPAN module installations (2016-12-06 - Geert Vandeweyer)

    1. Problem

    • You have an installation script that needs to install several cpan modules
    • You don\'t want to stick around to wait for user input : [yes] 
    • Save Spotify to flac or mp3 (2018-07-14 - Geert Vandeweyer)


      I like spotify. That\'s why I have a paid subscription. I also like music in general, as do my kids. That\'s why I have a \"

    • Parallel mysql myisam repair (2018-11-21 - Geert Vandeweyer)

      Small script to run the check & repair commands on database server in parallel, to speed up recovery and restart.