WebSQLClient Files

RELEASE NOTE
Version : WebSQLClient Release 1.0
Date : 16-June-2012

Summary:
Web SQL Client (WSQLC or wiskl) is a light-weight HTTP server allowing an end-user to access JDBC data sources via automatically generated data entry screens. It has purposely been designed to be used with standard web browsers   wireless tablet PCs and is highly configurable. 
WebSQLClient is capable of connecting to any JDBC datasource. Its main purpose is to provide rapid data model driven development. The WebSQLClient data entry forms are generated by querying the database system table information, but can alternatively be configured manually. 
WebSQLClient comprises a database agnostic data load utility (SQLLoader), a data unload tool (SQLExport) and SQL scripting capabilities. 
The application is a combination of a Java based multi-threaded webserver and HTML and Java Script. The major technology used comprises : Java, jQuery, jQuery UI, jqGrid, XML, JSON, Ajax and JDBC.  WSQLC’s main components are the WSQLC server and dynamically created HTML pages.
WebSQLClient has been tested against Derby, HSQLDB, Microsoft Access, MySQL, Oracle and PostGres databases.

Components:
The major components on the WSQLC Server are . 
- The Session Manger, to keep track of the various active sessions of the WSQLC server  
- The JDBC ConnectionPool to manage a predefined number of database client workers
- The Log Writer to accept and to spool log information
- The combination of a Controller and a Viewer implementing the Model View Controller (MVC) pattern for WSQLC. Controller and Viewer are Runnables, i.e. a thread is spawned to address each HTTP request
- The Form Renderer to create and to manage the HTML data entry forms
- A SQL Load module to load data into a target database using JDBC
- A SQL Unload and Script module to execute SQL/DML statements and to unload data sources through JDBC into flat files.
- A Form Generator that uses the information on the system table of the supported databases to create the data entry screen configuration files.  WSQLC uses a proprietary format to define the tables and fields on data entry screens.
The major components on the client are
- Ajax (XMLHTTP)
- HTML
- jQuery 
- JQuery UI
- JScripting


Release history
27-May-2012  : Initial version
16-June-2012 : Support for Access ontrol List 

Distribution:
The WSQLC distribution comprises all required software, apart from a Jave SDK.

Installattion instructions and user manual:
Download the latest version of the WSQL User Manual (e.g.WSQLC User Manual 20120527 V12.pdf)


Notices:
WSQLC (Web SQL Client) is free software

Permission is granted to copy, distribute and/or modify this software under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA to obtain the GNU General Public License 
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

GNU General Public License: www.gnu.org/copyleft/gpl.html

Contact details for copyright holder:  websqlclient@gmail.com