Web Analytics in the browser with DuckDB WASM: Filtering in milliseconds, instead of waiting for API responses

This demo attaches a remote DuckDB database from S3 with credentials via Cognito.

The project will be open sourced soon. In the meantime, you can explore the power of DuckDB in a browser with @usesqlworkbench as well:

@duckdb Does it hold up with 10 million events?

@duckdb Wow, looking nice! Is this still using duckdb-wasm-kit?

@duckdb Yes, it does! Thanks for all the your work you put in it!

@duckdb That’s what @fusionmetrics implemented a year ago. Works pretty well in production but we need to take care of not hitting the browser memory limit (about 2GB or so)

@duckdb So you are saying that dowloading a whole database is better than api call? Yeah, if you dont have users you have to issues

@duckdb Have you tried other tools in this space? Each API calls run database queries in the backend. I tried a lot of them, and you see latencies of hundreds of ms to even seconds. If you filter/drill-down a lot, it will definitely be better to download a few MBs once, and query locally

@duckdb love it!

@duckdb Looks like Umami analytics

@duckdb I think most of the tools look pretty similar because they all show the more or less same stats, but Umami is among the ones I like the most...