This chapter explores the importance of columnar access in data management and highlights the drawbacks of using CSV files, particularly regarding performance inefficiencies when modifying data. It emphasizes the need for more efficient file formats for handling larger datasets effectively.
DuckDB is an open-source column-oriented relational database that was first released in 2019. It’s designed to provide high performance on complex queries against large databases, and focuses on online analytical processing workloads.
Hannes Mühleisen is the Co-Creator of DuckBD, and is the CEO and Co-Founder of DuckDB Labs. He joins the show to talk about drawing inspiration from SQLite, why DuckDB was written in C++, the novel data processing scenarios it enables, and more.
This episode is hosted by Lee Atchison. Lee Atchison is a software architect, author, and thought leader on cloud computing and application modernization. His best-selling book, Architecting for Scale (O’Reilly Media), is an essential resource for technical teams looking to maintain high availability and manage risk in their cloud environments.
The post DuckDB with Hannes Mühleisen appeared first on Software Engineering Daily.