Download List

Sponsored link

Project Description

MyJSQLView provides an easy-to-use Java based GUI frontend for viewing, adding, editing, or deleting data in the Apache Derby, H2, HSQL, Microsoft SQL, MSAccess, MySQL, Oracle, PostgreSQL, and SQLite databases. A query frame allows the building of complex SQL statements and SQL Query Bucket for saving such. The application allows easy sorting, searching, and import/export of table data. A plug-in framework allows inclusion of tools to visually build queries, profiles, and plot data for analysis.

System Requirements

System requirement is not defined
Information regarding Project Releases and Project Resources. Note that the information here is a quote from page, and the downloads themselves may not be hosted on OSDN.

2013-01-02 07:52

This release includes the graphical SQL query builder (QueryBuilder) plugin as a default in the tool.

2012-10-27 08:56

This release marks a major reorganizational effort regarding
the source code and plugin management.

Though the public will notice little with regard to source subpackaging, the plugin
management changes bring the ability to load plugins from remote locations.

Plugin repositories can now be created by individuals or organizations which wish to provide
custom plugins on the basis of a realtime network loading capability.

In that regard, the MyJSQLView project has added to its own public repository a free Open
Source SQL query builder plugin.

2012-06-02 06:58
Version 3.35

This maintenance update addresses several issues which manifested themselves when using the SQL Query Bucket and Query Frame. Drops to the Query Bucket from the main summary table failed to properly create the syntax as derived from the search and sort parameters in the Summary Table. Fixes to the Query Frame now allow the use of aliases. The application has also been updated to remove legacy data structures which decreased the efficiency of the application.

2012-04-12 08:42

The maintenance update addresses issues with data importation and exportation associated with database tables with 100k+ rows. Modifications have been made to allow the control of table reads and writes by way of General Options Preferences. This release, like the prior one, improves the HeatMapper plugin. The TableFieldProfiler plugin has been expanded to include a cluster analysis tool.

2012-01-28 08:21

This release includes improvements in the efficiency of use for the SQL Query Bucket and an Aggregation/GROUP BY feature for the Advanced Sort/Search Form. This release also brings a
new default plugin called HeatMapper that allows the plotting of multi-variable numeric data. The coding for this plugin solidified the selection of HyperSQL for in memory data analysis. The HyperSQL database and JDBC are now included as a library component of the MyJSQLView download.

Project Resources