uSQL* is essentially an interactive query tool that aims to provide a consistent environment for anyone who develops in multiple databases, or is looking for additional functionality that is not provided in a particular client interface. It's fundamental purpose is similar to Oracle's SQL*Plus, MSSQL Server's Query Analyzer, MySQL's mysql client, PostgreSQL's psql client and the like. Features: - Simultaneous Connections
- Pluggable Query Output (Multiple Output Formats Without Complex Formatting Commands)
- SQL Buffer Editing
- Reuse of Result Sets (Change Output Format Without Having Server Re-execute Query)
- Execute External Scripts
- Save Scripts To File
- Save Queries To File
- Execution of user created stored procedures written in Java
Transitioning to different database architectures not only requires learning the intricacies of the database itself, but also learning the client interface. With uSQL*, only one interface is required, provided that a JDBC driver is implemented for that database architecture. uSQL* is developed in Java and implemented in a console environment so that the user is not tied to a particular OS or required to develop in a windowing environment. It can manage multiple connections and provide for pluggable query output so that arduous formatting commands for reports are not required. |