posted on 11:48 AM on Thursday 18 September 2014
I do a lot of data loading into MySQL and wanting to save myself time doing this, I wrote a Java command line application to read a input tab delimited text file and load it into MySQL. The program will scan the columns and determine the data type automatically which saves quite a fair bit of time. And the performance is much better than the other solutions which I used in the past.
Using awk to remove genotypes from a VCF file (08:28 AM on Friday 19 September 2014)
SEA Aquarium (10:51 AM on Friday 05 September 2014)
BIND XML Parser (11:50 AM on Saturday 14 June 2008)
Migrated to MySQL (09:01 PM on Saturday 07 December 2019)
Parallelization in R (08:16 PM on Tuesday 17 September 2013)