Home
Project Home
Getting Started
Command Reference
Tutorial
Download
 

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.

News: Wed Feb 18 2004

A "System Procedure" interface has been implemented that allows for custom procedures written in Java and uSQL* scripting capabilities. DEFINE command allows use of substitution variables

News: Sun Feb 15 2004

Can now copy data between connections using the COPY command.

News: Sat Feb 14 2004

Project status is now in beta!

Can now format number fields. Syntax: FORMAT NUMBER num_format

Ex: FORMAT NUMBER 000,000.00

News: Wed Feb 11 2004

Can now format date fields. Syntax: FORMAT DATE date_format

Ex: FORMAT DATE MM/dd/yyyy

News: Sun Feb 8 2004
The Command Reference page is now up.
News: Sat Feb 7 2004
Just finished putting up the project sourceforge.net. Please check back often as I plan to add to this site and the project daily. The Command Reference and Tutorial should be up within the next day.