RANT: Do not misuse spreadsheets for data storage

Using spreadsheet files for data storage and exchange can lead to the
corruption and even loss of information — sometimes without noticing it immediately. I came across this one too often so I could not help but write a rather long post about this topic.

Sharing datasets with other researchers or collaboration partners is a vital part of the knowledge exchange in a community. This might happen in big scale in form of supplementary material along with publications or in small scale within research groups. In this post I do not want to focus on what is actually shared, but how. Because a crucial but commonly underestimated element when sharing datasets with others is the used data format. Continue reading

WD PiDrive Cable USB 3 to USB 2 Hack with a Saw

I literally wanted to start this post with “I literally hacked the PiDrive cable…” but I actually have sawn it instead. Duh!

I’m using quite a few Raspberry Pi boards as servers, gateways, etc. and recently started to ‘polish’ their design. Instead of hard drives hanging beside them with a bunch of loose cables I’ve started to buy WD PiDrive Cases and Cables to pack all of them into nice ‘little boxes’.

The PiDrive Cables are really neat: they are designed to be positioned between a Raspberry Pi, its power supply, and an USB hard drive. The cable is designed for USB 3.0 hard drives, but in one case (hah) I wanted to use an external USB 2.0 drive I had lying around. So without further ado I’ve removed the USB 3.0 extension of the connector with a saw. It looks crude but works perfect…