Crossfilter-SQLite
Crossfilter with SQLite as a backend, for filtering data which is larger than the maximum heap size of javascript, and still using the dc.js & crossfilter magic of slicing and dicing.
How to use?
var sc = ; var sqlConnectionInformation = "DB_FILE" "DB_TABLE";var sqlCrossfilter = sqlConnectionInformation; // Create dimension based on "type" and "method" columns in "DB_TABLE"var typeDimension = sqlCrossfilter;var methodDimension = sqlCrossfilter; // Use evaluateAll to evaluate all queries, to create the initial groupssqlCrossfilter;
How does this connects to dc.js?
The idea is to use dc.js commitHandler, on the commitHandler function call the evaluateAll and then call the commitHandler callback, and dc will do the rest.
Is it working? completed?
This project is in the POC phase, most of the group/dimension methods aren't implemented (like top, reduceCount, groupAll - etc).
Contribute
If you want to contribute in this very young phase of the project, you can do one of this:
- Add docs about how to use this library
- Add tests (Hopefully, I will add some tests in the future)
- Implemented the crossfilter api fully
- If you find any bug - create an issue :)