PyQueryBuilder < CMS

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

CherryPy-3.1.2

   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 
```
1. http://www.sqlalchemy.org/docs/04/intro.html#overview_migration_metadata
2. http://www.sqlalchemy.org/trac/wiki/SADocSupplement
3. 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

mongodb-linux-x86_64-1.2.4

-- LiangDong - 2010-01-29

Topic revision: r29 - 2012-12-10 - LiangDong

Edit
Attach