TabSQL Files

TabSQL

(See details and tutorial in doc/help.html)


Introduction:

TabSQL is a generic tool for inquiry within or across table-like data files.
Users can use TabSQL to search anything of interests in text files and MySQL
database tables. 

TabSQL is open source software distributed under GNU GPL
(http://www.gnu.org/licenses/gpl.txt). 


Prerequisites:

1. A MySQL server (http://www.mysql.com)
2. If running from the source code of TabSQL, you also need a Python with
	packages MySQLdb, pycrypto, wxPython.


Install and Run:

1. From source package:
	on GNU/Linux:
		$ tar xzf tabsql_src-1.0.tar.gz
		$ sudo ln -s `pwd`/tabsql_src/tabsql.py /usr/local/bin/tabsql
		$ tabsql &
	on Windows:
		a) unzip tabsql_src-1.0.zip
		b) go to the folder tabsql_src
		c) double click on the file "tabsql.pyw"

2. From binary package on Windows:
		a) download and install tabsql-1.0_setup.exe



Examples for the installation steps

A) set up and run TabSQL from source code on Fedora 12: 
 1) set up environment for running TabSQL
	# yum install wxPython mysql-server MySQL-python
	# easy_install pycrypto
	# service mysqld start
 2) set up TabSQL
	# wget http://www.webarray.org/softwares/tabsql/tabsql_src-1.0.tar.gz
	# tar xzf tabsql_src-1.0.tar.gz
	# ln -s `pwd`/tabsql_src/tabsql.py /usr/local/bin/tabsql
 3) Run TabSQL
	# tabsql &

B) set up and run TabSQL from source code on Ubuntu 9.10 (i386): 
 1) set up environment for running TabSQL
	# sudo apt-get install python-wxgtk2.8 python-wxtools wx2.8-i18n python-dev python-setuptools mysql-server python-mysqldb
	# sudo rm -rf /usr/lib/python2.6/dist-packages/pycrypto-2.0.1.egg-info
	# sudo easy_install pycrypto
 2) set up TabSQL
	# wget http://www.webarray.org/softwares/tabsql/tabsql_src-1.0.tar.gz
	# tar xzf tabsql_src-1.0.tar.gz
	# sudo ln -s `pwd`/tabsql_src/tabsql.py /usr/local/bin/tabsql
 3) Run TabSQL
	# tabsql &


Notice:

TabSQL uses RC5 in pycrypto for encryption. Unfortunately, this module has been
removed from pycrypto-2.1.0 due to some reasons. Then an older version has to
be used instead. The following steps are examples on Ubuntu 10.04 (i386).

# mv /usr/lib/python2.6/dist-packages/Crypto  /usr/lib/python2.6/dist-packages/Crypto_disabled
# wget http://www.amk.ca/files/python/crypto/pycrypto-2.0.1.tar.gz
# tar xzf pycrypto-2.0.1.tar.gz
# cd pycrypto-2.0.1
# python setup.py install