- Opens DB connection (creates new if not exists)
- Add a data record
- Bulk data insertion
- Updates a record
- Deletes a record
- Get single record (by key)
- Get all records
- Get records count
- Clear/delete all records
A sample html page along with this file is provided for download, which showcases many of the above features (except, bulk insertion). This html uses Knockout.js, download it to check its working, and how to use this api (don't try it from filesystem, run it from web server).
|sample html in action|
From screenshot, you can see grid supports inline edit, delete and insertion, and they can be performed simultaneously. The bottom portion shows the status or result of all operations.
For supporting browsers check my previous blog post.
Download the Zip file or check the demo.