Aerodynamic data models: Flying fast at scale with DuckDB
summary
An application embeds DuckDB embedded OLAP to collocate data and compute, powering keystroke-by-keroke profiling and interactive dashboards over a 311 dataset. Queries run subsecond (≈100ms) queries so filters, sparkline breakouts and pivot tables feel instant. Metrics and dimensions are stored as SQL measures and joins in code artifacts, deployable to cloud with scheduled reports and CSV/pivot exports, and the demo shows the UI-scaled tooling actually working.
AI-written summary · about
chapters (5)
- 0:00Introduction to Rill Data
- 0:47Rill platform architecture
- 1:47Why Rill chose DuckDB
- 2:55Product demo and walkthrough
- 4:49Q&A and closing remarks
related talks
28mAnalyze data easily with duckdb - and the implications on data architectures
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
47mPlay Data Engineer Locally with DuckDB
51mMotherduck: Data Analytics in the Post Big-Data Era
45mAnalytics for not so big data with DuckDB
37mDuckDB: Crunching Data Anywhere, From Laptops to Servers
38mFrom Big Data to DuckDB: Ryan Boyd (MotherDuck) on Hyper-Tenancy, Duck Lake, and Making Data Fun.
24mData infrastructure to build bigger with less