MyJSQLView View, add, edit or delete data in the MySQL and PostgreSQL database
Download

MyJSQLView Ranking & Summary

MyJSQLView Tags

query database frontend database query database frontend database gui

MyJSQLView Description

View, add, edit or delete data in the MySQL and PostgreSQL database 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: · he release marks the inclusion of the first initial plugin module for the application. The plugin is called Table Field Charts and derives from an open source GNU project that was active at Sourceforge under the name DataProfiler. The DataProfiler, by Arrah Technology, does not appear to have any files to download now, but was a sort of data analysis tool that connected to various databases. · The Table Field Charts module encompasses aspects of the DataProfiler that gave general information for a database's table fields. · The information is presented in the form of graphic charts, pie & bar, for the field's record count, distribution, and patterns. · Though the basic outline of the code, four classes, used from the DataProfiler is intact I'm afraid major refactoring, code cleanup, and feature additions as all but annihilated most of the source. · New to the charts is the ability to scale and colorize all parameters. · The MyJSQLView project has just about arrived at the point with the plugin architecture that various projects such as the DataProfiler will begin to become targets for what I call SUCK UP. · Over the past several years the project has been identifying and evaluating open source tools that are in alignment with MyJSQLView's goals. · Gradually with the plugin architecture the plan will be to provide the ability for this project and others to SUCK UP other tools various features and incorporate them into MyJSQLView. · The key focus for this group will be tools that provide data analysis, and business intelligence abilities. · The Table Field Charts is not a true plugin yet, but did provide the basis for testing the process of implementing a separate plugin thread to be run within the program.

MyJSQLView Related Software