browsersql v0.0.1
BrowserSQL
This toolkit aims at helping developing GUI elements for accessing a remote SQL database.
Using BrowserSQL require to pass around the raw access to the database.
One way to achieve such access is to use Ajax (or better, WebSocket) and having a HTTP server forwarding requests to a local database (see https://github.com/lachrist/mariaws for a concreate example).
In this readme the function that materializes such access is called sql
; its takes two arguments:
1. A string that should be a SQL query (e.g. "SELECT * FROM CAR;")
2. A callback that will receive two arguments:
1. A potential SQL error code (null
if the query was successfull)
2. An array of tables that are the result of the query (a three-dimensional matrix that is)
There is two ways you can include BrowserSQL within your web page:
1. Simply include the file browsersql.js
(https://github.com/lachrist/browsersql/blob/master/browsersql.js) within your web page.
The global object will then contain the browsersql
object.
2. Use browserify
(http://browserify.org/): install this module with npm install browsersql
and get the browsersql
object with the JavaScript line: var browsersql = require("browsersql")
.
Demonstration
See: (https://github.com/lachrist/browsersql-demo).
API
browsersql.login(authentify)
: a containerbrowsersql.console(sql)
:browsersql.kit(onsql, database, viewers, callback)
:searcher(table, onsearch)
:selector(table, onselect, oninsert)
:setter(table, identifier, column)
:editor(table, identifier)
: