\i path_to_sql_file
\l - show all databases
\c <db-name> - connect to database
\d - show all tables (including sequences)
\dt - show all tables
\d+ <table-name> - desc table
\dn - show all schemas
\db - show all tablespaces
\q - quit (Ctrl+C)
Here is the error:
[Sat Jun 01 10:18:36.750 2019] [9160:0] [info] jk_open_socket::jk_connect.c (473): connect to 127.0.0.1:8109 failed (errno=111)
[Sat Jun 01 10:18:36.750 2019] [9160:0] [info] ajp_connect_to_endpoint::jk_ajp_common.c (891): Failed opening socket to (127.0.0.1:8109) (errno=111)
Q: Where can I download iTunes Producer v2.2.1?
A: Khokolate Dec 19, 2014 8:51 AM in response to dmacdonell
This should help everyone with old MACs or old OSs.
Version 2.0.1 — https://itunesconnect.apple.com/itunesproducer/iTunesProducer_2.0.1.dmg
Tables | Are | Cool |
---|---|---|
col 3 is | right-aligned | $1600 |
col 2 is | centered | $12 |
zebra stripes | are neat | $1 |
cd /tmp
# Install Python 2.6.
# From http://stackoverflow.com/a/8352224/177696
wget http://download.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
sudo rpm -ivh epel-release-5-4.noarch.rpm
sudo yum install python26
mkdir -p ~/bin
ln -s /usr/bin/python26 ~/bin/python
Human immune system produces a vast variety of antibodies in order to respond to the external stimuli. Next-generation sequencing technology allows researchers to obtain the sequences of all antibodies from a single person. Clustering these antibody sequences allows us to understand how an antibody is produced. However, the number of antibody sequences from a single sample can be up to 1 million scale. Clustering with such a big scale poses a big computation challenge.
The current algorithm for clustering antibody sequences computes a pairwise distance matrix, and then perform a hierarchical clustering to group sequences into clusters. This algorithm is implemented in Python as provided clonify_contest.py
script.