Download
 sdssQA
 sqlcl
 Emacs interface
Help
Tools
Download

SDSS Query Analyzer (sdssQA) Version 2.0

Author: Nolan Li & Tanu Malik, JHU
Date: January 2003

sdssQA is a GUI SQL query tool to help compose SQL queries. It was inspired by the SQL Server Query Analyzer, but runs as a Java application on UNIX, Macintosh, and Windows clients and is freely available from this web site. It connects via ODBC/JDBC (for local use) and via HTTP or SOAP for use over the Internet.

Linux/Unix: Execute java -jar sdssQA.jar

Windows and Mac-OS (v10+): Double-click the sdssQA icon to execute.

Two directories are created in the user's home directory:

  1. QA_queries - default location to save your .sql queries, and a subdirectory called samples/ , with the sample queries.
  2. QA_data - default location to save query output.
For basic SQL help, go to the Intro to SQL page.

For sdssQA help, see the sdssQA help page.

The sdssQA also contains sample scientific queries which have useful comments included; these can be found under File->Open Example Query

Download sdssQA v2.2.16 sdssQA.jar [500 kB]
Download the Sun JRE v1.4