Monthly Archives: September 2010

This is the first “official” trial and my early learning experiences doing program involving interaction with a database. Here I am using postgreSQL database as an example, which is our SeqWare MetaDB as well our SeqWareLIMS are relying on. Some … Continue reading →

As a transition, Brian will hand off such duty onto me and Matt, in an attempt that Matt and I can cover each other in case one is on vacation. 1. Background: Currently, two pars of run composes the seqware … Continue reading →

To query for samples done with pipeline process (little report) A script (sw_reports_find_files.pl) is written by Brian located at /home/jyli/svnroot/seqware-complete/trunk/seqware-pipeline/perl/bin/site-specific/unc/sw_reports_find_files.pl 1. log into swmaster 2. run the script as ” perl /home/jyli/svnroot/seqware-complete/trunk/seqware-pipeline/perl/bin/site-specific/unc/sw_reports_find_files.pl –username seqware –password seqware –dbhost swmaster.bioinf.unc.edu –db seqware_meta_db … Continue reading →

There is the help page for accessing SeqWare LIMS system. For postgresql, the query language is slightly different from other sql language. To clean up SeqWareLIMS event, follow the following steps: 1. To to SeqWareLIMS and find run with either … Continue reading →