正在加载视频...

视频加载失败

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

56,910 次观看 • 1 年前 •via X (Twitter)

11 条评论

Tobias Müller 的头像
Tobias Müller1 年前

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

Tobias Müller 的头像
Tobias Müller1 年前

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

Alvar Lagerlöf 的头像
Alvar Lagerlöf1 年前

@duckdb Does it hold up with 10 million events?

Matt Holden 的头像
Matt Holden1 年前

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

Tobias Müller 的头像
Tobias Müller1 年前

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

Alexander Hupfer 的头像
Alexander Hupfer1 年前

@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)

TArch 的头像
TArch1 年前

@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

Tobias Müller 的头像
Tobias Müller1 年前

@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

ryan boyd 的头像
ryan boyd1 年前

@duckdb love it!

🇯🇲 Marquin 🇵🇸 的头像
🇯🇲 Marquin 🇵🇸1 年前

@duckdb Looks like Umami analytics

Tobias Müller 的头像
Tobias Müller1 年前

@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...

相关视频