Aerodynamic Data Models - Flying Fast at Scale with DuckDB

Learn optimization and data modeling techniques for achieving sub-second query response times with DuckDB in this 12-minute conference talk from OSACon. Discover how to implement parallel connections for simultaneous query processing, organize chronological data for enhanced min-max index performance, and leverage enum types for efficient string column queries. Explore configuration tuning strategies that enable processing of large-scale datasets (100+ GB) while maintaining rapid dashboard interactivity that can handle up to 100 parallel queries per user interaction. Master practical approaches to supercharge DuckDB's performance for time-series metrics exploration and interactive dashboard applications.