SQLPython An open source SQL command-line client designed with extensibility and personalization in mind
Download

SQLPython Ranking & Summary

SQLPython Tags

SQL client SQL Client consolidate script cli client consolidate

SQLPython Description

An open source SQL command-line client designed with extensibility and personalization in mind SQLPython is a free and open source command line tool developed with the help of the Python programming language and having the following goals:· emulate Oracle's sqlplus basic functionalities in python· allow easy extensions to sqlplus functionalities leveraging python's class inheritance· allow to consolidate custom sql scripts into new SQLPython commands· allow to jump out the sql environment into python to post process query result sets Here are some key features of "SQLPython": · SQL*Plus-style bind variables · Query result stored in special bind variable ":_" if one row, one item · SQL buffer with list, run, ed, get, etc.; unlike SQL*Plus, buffer stores session's full history · @script.sql loads and runs (like SQL*Plus) · ! runs operating-system command · show and set to control sqlpython parameters · SQL*Plus-style describe, spool · write sends query result directly to file · comments shows table and column comments · compare ... to ... graphically compares results of two queries · commands are case-insensitive Requirements: · Python

SQLPython Related Software