Author Archives:

Case sensitivity in MySQL

It is sometimes necessary to perform a case-sensitive query for text stored in a MySQL table. By default, searches are case insensitive. In MySQL, the character set defines what kind of characters you can store, but not how they are compared or sorted. This is determined by the character set’s collation setting. For example, take [...]

How to recover from a tarbomb incident, and why not to do it

Tarbombs are irritating. I found an easy way to reverse the effect and then paid the consequences for not testing it first.

Working with SDFs using MX and groovy

Rich Apodaca recently introduced MX, a lightweight cheminformatics toolkit. He also recently published a quick demo to demonstrate how easy it was to use MX to read and write SDFiles using jruby to script it. I wanted to replicate the functionality in groovy, another scripting language that runs on the JVM — one I’ve recently been using [...]

Follow

Get every new post delivered to your Inbox.