MyJSQLView is an easy to use Java GUI, graphical user
interface, frontend DML, data manipulation language, tool for the MySQL,
PostgreSQL, & HSQL databases. A query tool allows the building &
executing of complex SQL statements. Easy data sorting & searching,
import/export either in CSV, comma separated values, or DDL, data definition
language.
MyJSQLView is the result of a condensed version
of a larger project that was needed to allow users
access to an inventory database. The project from its
inception has been and will continue to be a tool
that allows users/developers access to database data.
An effort was made to try and make the user interface
as simple as possible to understand and use. The
name of the project comes from the concept of 'my java sql view'.
The view being the key. The interface provides the
user with a standard type of spreadsheet perspective
with obvious controls to sort, search, page, view,
add, edit, or delete table data. One does not need to know
any SQL, structure query language, to use MyJSQLView.
Even though the user interface is relatively simple, it
does provide some powerful features such as a query tool,
import/export of data and an advanced sort/search. The
tool provides essentially no support to those that wish
to manage databases. The tool is ideal for small to medium
size businesses that wish access to database data. The
project can and will in the future provide reports and other
data mining techniques. Custom data analysis modules may also
be produced by contract if so desired for your specific needs.