Autarchy of the Private Cave

Tiny bits of bioinformatics, [web-]programming etc

    Archive for January, 2011

    MySQL as NoSQL with HandlerSocket: 750000 qps

    25th January 2011

    HandlerSocket provides a direct access to InnoDB storage, bypassing SQL interpretation layer. With in-RAM data, it may raise MySQL performance to 750000 queries per second.

    Share

    Posted in Links, Software | No Comments »

    MongoDB is web-scale

    25th January 2011

    Disclaimer: don’t take this video seriously.

    Share

    Posted in Links, Misc | 2 Comments »

    Light web-based collaborative project management tools

    10th January 2011

    Updated on the 5th of March, 2010 (added flowdock and pivotal tracker, and also personal experience using a few of the previously described tools).

    Back in 2007 I wrote a brief review of web-based project management tools. After that, I started using dotProject for personal projects management. I’m still using it, but for collaborative project management, communication, and tasks/milestones tracking dotProject isn’t perfect.

    I need a tool, which is

    • collaborative
    • web-based (to allow effective collaboration)
    • preferably free
    • has concise per-project activity log
    • minimal required functionality: tasks, milestones, files, and status updates.

    After trying a few things, our small team settled for now on using github + pivotaltracker jira + confluence + flowdock.

    Here’s a full list of tools briefly reviewed. I’ve been already using ProjectPier, so I’ll start with this software.
    Read the rest of this entry »

    Share

    Posted in Links, Software, Web | 11 Comments »

    My favourite command line for mirroring with wget

    9th January 2011

    wget ––continue ––mirror ––page-requisites ––adjust-extension ––convert-links ––backup-converted ––limit-rate=500k ––wait=2 URL

    (short form: wget -cmpEkK ––limit-rate=500k -w 2 URL)
    Read the rest of this entry »

    Share

    Posted in *nix, Notepad | No Comments »