PySQL
PySQL aims to be a full replacement for sqlplus (and much more). It has features such as history, completion, and line editing. It has high level functions (searching for tables, indexes, count, explain plan, list of sessions, etc.), proper output for screen and files (CSV ready for inclusion in spreadsheets), support for user-defined SQL, background queries, graphical output for the schema data model, object dependencies, a PL/SQL package function call tree, and much more.
| Tags | Database Front-Ends |
|---|---|
| Licenses | GPL |
| Operating Systems | Windows Windows POSIX AIX Linux |
| Implementation | Python |
Recent releases
- 15 Feb 2009 17:45
Changes: 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.
- 27 Jan 2009 09:47
Changes: 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.
- 15 Dec 2007 13:40
Changes: 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.
- 18 Mar 2007 12:34
Changes: Table data comparison is now working.
- 04 Feb 2007 08:34
Changes: 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.
