Dependencies
Project management
setuptools
cd ../setuptools-0.6c11/
python setup.py build
python setup.py install
Test
pylint
cd pylint-0.19.0
python setup.py install
tutorial
TPCH
seps
1. makefile
cc = gcc
DATABASE = ORACLE
MACHINE = HP
WORKLOAD = TPCH
make
2. dbgen -S 1
3. create *.ctl file for each *.tbl file
load data
INFILE 'orders.tbl'
INTO TABLE ORDERS
FIELDS TERMINATED BY '1'
(O_ORDERKEY, ... O_ORDERDATE DATE "YYYY-MM-DD")
sqlldr liangd/tiger
Data format
PyYAML
PyYAML-3.09]$ python setup.py install
python-cjson 1.0.5
python setup.py build
python setup.py install
py-yajl 3.0.6
git clone https://github.com/rtyler/py-yajl.git
python setup.py install
yajl 1.0.12
1. mkdir build
2. cd build
3. cmake ..
4. make
5. build output left in yajl-X.Y.Z
ruby 1.8.5
yum install ruby
cmake 2.6 pack4
yum install cmake
visualization
dot
yum install dot
pylab
matplotlib
numpy
python setup.py build / install
plot
pylab.show() not support for
>>> /data/Python/lib/python2.6/site-packages/matplotlib/backends/__init__.py:41: UserWarning:
Your currently selected backend, 'agg' does not support show().
Please select a GUI backend in your matplotlibrc file ('/data/Python/lib/python2.6/site-packages/matplotlib/mpl-data/matplotlibrc')
Web service
python setup.py install
python cherrypy/test/test.py
http://www.cherrypy.org/
Cheetah 2.4.2.1
python setup.py install
http://www.cheetahtemplate.org/
YUI
datatable
Documentation
Sphinx-1.0.4
Utilities
PLY 3.3
http://www.dabeaz.com/ply
IPython 0.10
-
easy_install ipython[kernel,security,test]
.
Error:
- DynamicMetaData
NameError: global name 'DynamicMetaData' is not defined
-
http://www.sqlalchemy.org/docs/04/intro.html#overview_migration_metadata
-
http://www.sqlalchemy.org/trac/wiki/SADocSupplement
-
http://www.sqlalchemy.org/docs/reference/sqlalchemy/schema.html
- graphviz-2.27.20100308.0545-1.el5.x86_64.rpm failed
error: Failed dependencies:
libgdkglext-x11-1.0.so.0()(64bit) is needed by graphviz-2.27.20100308.0545-1.el5.x86_64
libgtkglext-x11-1.0.so.0()(64bit) is needed by graphviz-2.27.20100308.0545-1.el5.x86_64
libgts-0.7.so.5()(64bit) is needed by graphviz-2.27.20100308.0545-1.el5.x86_64
Database
SQLAlchemy
cd SQLAlchemy-0.5.8/
python setup.py install
Pysqlite
cd ../pysqlite-2.5.6/
python setup.py build
python setup.py install
sqlite3
cd ../sqlite
../sqlite-3.6.22/configure --prefix=/data/sqlite
make
make install
mysql
(might help
http://tech.zhenhua.info/2009/01/install-and-configure-mysql-as-non-root.html
)
-
- root / cms
-
mysql> GRANT ALL PRIVILEGES ON test.* TO cms@localhost IDENTIFIED BY 'passcms' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
create database migrate;
GRANT ALL PRIVILEGES ON migrate.* TO cms@localhost IDENTIFIED BY 'passcms' WITH GRANT OPTION;
cx_Oracle
[oracle@localhost apps]$ unzip oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip
downloads/oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip downloads/oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip
downloads/oracle-instantclient11.2-jdbc-11.2.0.1.0-1.x86_64.zip downloads/oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.zip
downloads/oracle-instantclient11.2-odbc-11.2.0.1.0-1.x86_64.zip
[oracle@localhost apps]$ mv instantclient_11_2 oracle/product/10.2.0/
[oracle@localhost instantclient_11_2]$ ln -s libclntsh.so.11.1 libclntsh.so
[oracle@localhost instantclient_11_2]$ ln -s libocci.so.11.1 libocci.so
[root@localhost ~]# vi /etc/ld.so.conf.d/oracle.conf
[root@localhost ~]# ldconfig
[liangd@localhost:data]$ source pysetup.sh
[liangd@localhost:data]$ cd cx_Oracle-5.0.3/
[liangd@localhost:cx_Oracle-5.0.3]$ python setup.py build
[liangd@localhost:cx_Oracle-5.0.3]$ python setup.py install
Oracle
[oracle@localhost ~]$ cat /data/apps/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /data/apps/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Postgresql 8.4.1
gunzip postgresql-version.tar.gz
tar xvf postgresql-version.tar
./configure --prefix=/data/postgresql
gmake
su
gmake install
adduser postgres
mkdir /data/postgres/pgsql/data
chown postgres /data/postgres/pgsql/data
su - postgres
/data/postgresql/bin/initdb -D /data/postgres/pgsql/data
/data/postgresql/bin/postmaster -D /data/postgres/pgsql/data >logfile 2>&1 &
/data/postgressql/bin/createdb test
/data/postgresql/bin/psql test
tutorial
psycopg2
[liangd@localhost:psycopg2-2.0.14]$ python setup.py build_ext -I /data/postgresql/include/ -L /data/postgresql/lib/
[liangd@localhost:psycopg2-2.0.14]$ python setup.py install
[[http://www.webtop.com.au/blog/installing-postgresql-and-psycopg2-2009030344][tutorial on installing]]
$ vi /etc/profile
...
67 # Postgresql
68 export POSTGRESQL_HOME=/usr/local/postgresql
69 export LD_LIBRARY_PATH=/usr/local/postgresql/lib
70 export PGDATA=/home/postgres/data
71 pathmunge $POSTGRESQL_HOME/bin
72
73
74 export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC
...
$ source /etc/profile
template1-# createuser liangd password tiger
mongodb-linux-x86_64-1.2.4
--
LiangDong - 2010-01-29