BasicQuery Version 01.00.01 Released

BasicQuery is a Java-based application used to access databases through JDBC. It features a Swing-based GUI and includes capabilities useful to developers when testing SQL statements against a database. It also produces timing information, which is valuable during tuning exercises. Development on BasicQuery began in early 2003 and it has been used on various projects since then.

BasicQuery can use any JDBC-compliant driver. The list of drivers to be loaded is stored in a parameter file. The driver packages themselves are loaded dynamically at startup from a user-configurable location. We regularly access MySQL, Oracle, and Sybase databases. The Apache Jakarta Commons Pool Library can be used, allowing timing tests to reflect the impact of pooled versus non-pooled connections.

Our goal is to see BasicQuery grow to incorporate more developer-friendly features. A few of the more recent additions revolve around generation of queries based on previous results. We also intend to leverage metadata, thereby supporting schema copies and comparisons. The inclusion of XML input and output is also high on the list. Finally, the integration of JavaHelp is becoming crucial due to the increasing number of features.

Please visit the project summary page at http://sourceforge.net/projects/basicquery/ and download this release. An InstallAnywhere installer is also available for your convenience. See the project's home page at http://basicquery.sourceforge.net and click on the "Application Installer" link.