MyJSQLView provides an easy to use Java based GUI, graphical user interface, frontend for viewing, adding, editing, or deleting data in the MySQL & PostgreSQL databases.

A query tool allows the building of complex SELECT SQL statements. The application allows easy searching, sorting, and import/export of table data.

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.

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.

Here are some key features of "MyJSQLView":

· User Connection Preferences Saving/Managing.
· User Preferences Summary Table Column Selection & Sizing.
· User Preferences Summary Table Row Sizing.
· Access to All Tables in Database During Session.
· Viewing, Adding, Editing, and Deleting All Table Fields.
· Support for Table Field Function Operations.
· Supports All Basic Data Types, Including Blob/Bytea.
· Data Type Checking During Adding or Updates.
· Support for All Table Types, Including Transaction Locking.
· Support for Flushing Privileges for User root on mysql database.
· Printing of Summary Table Data, Screen View.
· Export of CSV Summary or Complete Table Data.
· Export of SQL Summary or Complete Table Structure/Data.
· Export of SQL Current Open Database/Scheme.
· Import of SQL Statement File.
· Import of CSV data File Into Selected Database Table.
· Query Frame for Building Complex Select SQL Statements.
· Simple Easy to Use Interface.
· Simple and Advanced Table Sorting and Searching.

Requirements:

· Java 1.4 or later
· MySQL JDBC, 3.0.10 - 3.1.13, 5.0.7.
· PostgreSQL JDBC3, 8.2-506.

What's New in This Release: [ read full changelog ]

· The release marks the support for the HyperSQL 2 and MSAccess databases.
· Included with this update is several corrections for bugs involved with the import of large SQL dumps and table definition generation for unique keys.
· A multi-language PDF export inclusion is now implemented via unicode embedded fonts.