{"repo":"rpbouman/huey","free":true,"listed":false,"github":"https://github.com/rpbouman/huey","clone":"git clone https://github.com/rpbouman/huey.git","description":"Light-weight, browser-based ROLAP pivot tables on top of DuckDB-WASM","language":"JavaScript","stars":607,"topics":["data","duckdb","excel","pivot-tables","rolap","small-data","sql"],"license":"MIT","category":"databases-storage","readme_excerpt":"🦆 Huey Huey is a static browser-based app that lets you explore and analyze data. Huey supports reading from multiple file formats, like .csv, .parquet, .json data files as well as .duckdb database files. You can either load these files from your local workstation, or from a remote location via a URL; Or you can connect Huey to an external Data Lake or Quack server. Try Huey now with some sample reports using the live demo at https://rpbouman.github.io/huey/src/index.html (Note: this is a live demo that allows you to run Huey without even downloading it. Even though it's available online, it's still a static webapp: any data you load into it is safe, and stays on your local client.) If you prefer to watch a video insted, here's a few: - 3rd DuckDB Meetup . - DataZen talk . Key features - Supports , , , (MS Excel) both for analysis as well exporting results. Huey can also read DuckDB database files, or connect to a remote catalog. - Comprehensive attributes tab to explore the structure of your dataset - Intuitive query builder that supports projection, aggregation, filtering, and (sub)totals - A pivot table to present analysis results - Many different aggregate functions for reporting and data exploration - Automatic breakdown of date/time columns to temporal hierarchy with derived attributes for year, month, quarter etc - Extensive support for arrays and data types to allow immediate ad-hoc analysis of complex, nested data (typical for JSON data) - Export of result data and ","default_branch":null,"files":null,"tree":[],"storefront":"/r/rpbouman","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/rpbouman/huey/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}