A demo web application to run online queries to SQL server. It is not secured for the sake of simplicity. This demo must only be used for educational/demonstration purposes only. Dont store sensitive data. The queries are not santized in this demo tutorial. Please fork repository and run it.
Node.js required. MySQL/MSSQL like application should be running. This loads the result via secured connection on XMLHttpRequest. Data used frequently is cached in to cookies in encrypted form depends on user preference. Loading and Rendering is handled by express along with proper xhr request. An active internet connection is required for loading data over cdn networks. Just download as zip or git pull repository. An SSL/TLS layer is used for HTTPS connection in the web application. Trust the SSL certificate in your browser settings. It is possible to add redis caching so that connection query requests to MySQL instance is reduced, but I have not implemented it yet. Please wait for next release.
$ sudo npm install
$ set DEBUG=webserver:*,express* && npm startOpen https://localhost:3000/.
Node.js Node.js Install
MySQL MySQL Install
MySQL Windows MySQL Windows
To use Redis, REDIS Redis Install