Watch this 28-minute conference talk from OSACon 2023 to explore the innovative analytical database management system that runs in-process, eliminating overhead between client applications and databases. Learn about the key design decisions behind this open-source system that offers seamless integration with Python, R, Java, Julia, and over 10 other programming languages. Discover how the system achieves remarkable performance with features like column-based storage, vectorized execution, and zone map indexing, enabling efficient processing of large datasets without memory constraints. Understand its comprehensive support for various data formats including CSV, Parquet, JSON, and Iceberg, along with multiple data sources such as https, s3, and gcs. Through practical demonstrations, observe how to import and query large CSV files, perform pivot operations, and leverage the system's cache-friendly architecture for fast processing. While exploring its benefits of easy installation, zero configuration requirements, and impressive speed with load times exceeding one gigabyte per second, also gain insights into its limitations regarding distributed execution and multi-process operations. Read more