Data analytics in browser with AlaSQL.JS
summary
Demonstrates using AlaSQL.JS as an in-memory SQL engine inside the browser to import CSV/Excel/SQLite/JSON, run compiled, indexed SQL queries, and export results to localStorage or IndexedDB; shows a small app that finds duplicate rows and joins multiple uploaded files using user-defined JS functions for custom logic. Claims fast client-side preprocessing to avoid round trips but notes practical limits: large dataset transfer times, expensive multi-file joins, and that subselects in joins do not work.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 1:18Processing data at edge
- 2:46What is AlaSQL.JS
- 5:17Key features
- 7:06SQL statement processing
- 7:48Demo with AlaSQL.JS
- 10:00Limitations and use cases
related talks
29mKEYNOTE: Big Opportunities in Small Data
36mArcticDB, the OLAP antidote
30mBig Data and Small Data Everywhere, All at Once
27mUsing embedded SQL engines for plotting massive datasets on a laptop
41mVisualizing big data
18mData Analysis with JavaScript
20mA framework for building data driven interactive front ends
51mFront End Data