WebSQL Client

websql-server exposes a sqlite
API originally defined at
Cordova-SQLitePlugin
through Websockets.

websql-client connects to websql-server
and implements the WebSQL API.

Usage

Install websql-server:
``
npm install -g websql-server
`

Start websql-server:
`
websql-server
`

Import websql-client (a bower package) and primus in your html (Primus
is automatically served by websql-server):
`


`

Include the initialization code:
`
var db = window.sqlitePlugin.openDatabase({name: "my.db", location: 1});
``

A more advanced installation would conditionally load websql-client if a browser
environment is detected, otherwise load
Cordova-SQLitePlugin.

Testing

Running tests in the web browser

serve up the whole project as a static site with: http-server (npm package)

navigate to: http://localhost:8080/test/browser/tests/index.html

Intended Use cases

- Testing and prototyping Cordova Apps in the web browser that use
Cordova-SQLitePlugin.
- Running unit tests for code that depends on a websql api (TODO: document how
to set this up).

Advantages over using browser's Built in WebSQL implementations:

- No limitations of current WebSQL implementations, such as:
- not authorized to use function: random
- https://code.google.com/p/chromium/issues/detail?id=460191
- maximum database size restrictions
- not able to use a pre-populated sqlite database from a project directory
- not able to use sqlite extensions written it C.
- Sqlite connection, initialization and query caching is retained when you
refresh/reload your app. Your app only has to reconnect to the web server
through Websockets. This allows for fast livereload incremental
app development.