All releases of PySQL


Release Notes: Animated cursor during long queries or operations. A startup/shutdown option (10/11g only). The desc function is now interactive if multiple objects match. Support for the new Oracle audit function (addm, awr) and assm report. A new function for awr sqltune.


Release Notes: Automatic terminal width detection on Unix systems. Role/profile search. Search has been added to the session display function. There are many enhancements to the desc function. The prompt for multi-line commands has been enhanced. The diskusage function has been rewritten. All graphical functions have been updated to support the latest Graphviz and pydot releases.


Release Notes: SQL text is no longer truncated in the session summary. Terminal name is restored at exit. There is better support for AIX 5.3 and cx_Oracle 5. There are many minor bugfixes and more unit tests. Missing translations have been added.


Release Notes: A switch to git was undertaken and the source tree was and reorganized slightly. Useless and dead modules were removed (pysqlio and pysqlnet). The license was changed from GPLv2 to GPLv3. Unicode is now used inside PySQL. Oracle client encoding (NLS_LANG) is honored for database I/O and terminal encoding for user I/O. Unit tests were added. A new function parser that allows more complex and useful command switches was added. Graphical functions (datamodel, diskusage, etc.) have new options.


Release Notes: All of the source tree was reorganized and was switched from a custom build system to distutils. Installable packages are available for Linux (RPM and Slackware tgz) and Windows. Pysql is now installed in a standard Python site-package and a wrapper is put on the PATH. All configuration and cache files are now in $HOME/.pysql/ on Unix and %APPDATA%/pysql/ on Windows. The use of extended search patterns was added to the search function and datamodel function.


Release Notes: Table data comparison is now working.


Release Notes: This release uses color in comparisons to highlight what has changed. The compare function can also compare two tables (in the same or different schema), not just two schema.


Release Notes: This release adds a schema "compare" function with table column name, type comment, and indexed comparison. Just type e.g. "compare scott/tiger@test scotty/tigrou@test". This relerase will not show a column twice when the same table is found in different schema.


Release Notes: A "disk usage" graphical function was added to display where the most space is consumed. Just type "du" or "du scott" to get a graphical view of space used by tables and indexes for each tablespace. Like all other graphical functions, this one is powered by graphviz.


Release Notes: This release adds support for CLOB objects. It adds server output support (for dmbs_output.put_line().