pykQuery

Build reliable and maintainable data-interactive visualisations quickly.


Data Querying Framework for Developers.



Interactive


The UI Engine for the Big Data is the Browser. While the backend can store and process terabytes of data, the front-end browser is capable of holding not more than 30 MB of data. Complex programs are not possible in the browser because a lot of the utilities that back-end programmers take for granted e.g. complex data structures, SQL, etc. are not available to front-end programmers. Hence, we built pykQuery as a means to improve the available tool-set to our visualisation developers.

Save upto 90% time spent in writing data related code



Data Access: Get data slices out of silos and make them available to front-end visualisation.

Mysql
Postgres
Googlesheets

Data Manipulation (In-Browser): Parse, search, filter, aggregate, join, sort and manipulate data from various sources right in the browser.

Interactivity: Trigger data selection and filtering on DOM events to create real-time data-driven interfaces.

Built to provide a delicate balance
between capability and performance


Before we made pykQuery, we tried to explore open-source alternatives that could solve our data visualization problems but none seemed to hit the "sweet spot". Really! We went through 12 of them: Underscore.js, Lazy.js, Crossfilter.js, Google's Lovefield, Loki, PouchDB, ForerunnerDB, Datavore, JinqJS, AlaSQL, SqlJS and finally Miso Project's DataSet.

See how pykQuery does against them


Feature Comparison
Performance Comparison

Key Features

— SQL Like Syntax on Columnar Data
— Select (metric functions, custom functions)
— Library Functions (math, datetime)
— Alias
— From
— Where (and/or conditions, nested filters, etc.)
— Group By (aggregation)
— Having
— Joins (full, inner, left, right)
— Order (ascending, descending)
— Limit
— Offset
— Interactivity Impacts (data, filter)
— Save Queries as JSON

What it includes

— PykQuery.2.0.min.js
— PykQuery-GoogleSheets.2.0.min.js
— pykquery-postgresql npm package
— pykquery-mysql npm package




Applications

— Interactive Visualizations
— Exploratory Dashboards
— Data-driven Presentations

Battle hardened since Jan 2014

Here are some of the Pykih visualizations powered by PykQuery.


Coke

Hansa Cequity

CPG Sales Distribution Dashboard

Klp

Akshara Foundation

Real-time Survey Responses

500 small

500 Startups

Portfolio Review PPT

Snow tile

Snow.com

The Skier's Almanac

Ia responsiblebiz

Oxfam India

Responsible Business Index





Why Should I Hire Pykih? (PDF) to learn why we’re the smart choice.
Portfolio of work done - for Content Marketing (PDF) to see some of our past work.
Portfolio of work done - for Decision Making (PDF) to see some of our past work.
Get in touch and we’ll deliver a proposal in a week or less.



Talks
Blog

Contact us
FAQs

Pykih logo