|GitHub Project Page | Monead Home|
The project's source code has been moved to GitHub as of May 24, 2014
The latest release is version 02.00.06 released on July 2, 2014
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.
A big Thank You to ej-technologies GmbH for supporting the open source community by providing a license to their install4j multi-platform installer builder. The installers listed below were all created with a single configuration using the install4j installation builder.
You must have Java (JRE) version 5 or higher pre-installed in order to use BasicQuery. You can download the latest Java JRE from Oracle.
The current production release of BasicQuery is Version 02.00.07
The latest source code is available at its project home: https://github.com/DaveRead/basicquery.
We have leveraged BasicQuery in diverse situations which involved debugging, testing, and performance tuning. Key features of the application include easy access to each SQL statement entered; ability to save sets of SQL statements in separate files; support for parameterized statements; a provision for multiple return values; execution of sets of statements; storage of each connect URL used; and exporting of results, both data output and timing details, to a CSV file. Given its Java heritage, BasicQuery has been used successfully on multiple platforms.
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.
On the source code side many changes continue to be made. With the 01.02 production release out, the next set of betas will be focused on the following feature set:
We invite other developers to join our project and help advance this tool. Two major areas that need focus are the multi-lingual support and user documentation. The translations would benefit greatly from native speakers editing the terms. An individual interested in creating documentation would be invaluable since we know the operation of the tool too well.