Database explorer with a focus on breadth, not depth.
All of today's well-developed database explorers make it easy to do the things that are already easy to do in SQL, namely to dig down to the details of a single table's rows and column configuration. SQueaL is designed for a different task: to show the breadth of a database structure, not the depth. With SQueaL one can see which tables were the last to update, which update the most often, which data is typical of each table, and other tasks to get a 'feeling' for the database.
SQueaL is useful for developers new to an existing project to become acquainted with the database being used. We already have profiling tools for code, but nothing currently useful for large database examination.
The name 'SQueaL' is bookended by the letters SQL, symbolically it shows you what is 'inside' the SQL. Also, the verb 'to squeal' means 'to snitch' or 'to inform', implying that this application reveals information which is otherwise not so easily accessible and concise.
- Table names
- Number of records
- Creation time, size on disk
- Estimate: Frequency of inserts, updates, and deletes
- Sort on metrics
- Column names and types
- Average, maximum, and minimum size of column values, and standard deviation
- Typical or representative values for each column
- View random records
- Sort on metrics
Just the Python2 core library and the Python MySQL connector. Try one of the following:
$ sudo aptitude install python python-mysqldb
$ sudo aptitude install python python-mysql.connector
Fight with some of these, and please let me know what works for you.
# yum install python-devel mysql-connector-python MySQL-python
# yum install mysql-devel
$ export PYTHONPATH='.easy_install/lib/python2.6/site-packages'
$ easy_install --prefix=.easy_install MySQL-python
There is no MySQL connector for Python3 yet.
http://github.com/dotancohen/squeal
Dotan Cohen
http://dotancohen.com
You can find my email address and other contact information in your favorite search engine!