Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Spencer Judge discusses the architectural ...

You may encounter situations like these. You try to load a CSV with millions of rows in Pandas, but run out of memory. You run an aggregation query in SQLite, but it is too slow to be practical. You ...

That DuckDB is gaining more and more attention is no accident. As a rising star in desktop analytics, it masters SQL with ease, effortlessly handling CTE recursive queries, multi-layered window ...

Have you ever wished you could generate interactive websites with HTML, CSS, and JavaScript while programming in nothing but Python? Here are three frameworks that do the trick. Python has long had a ...

Alex Merced is the co-author of O'Reilly's "Apache Iceberg: The Definitive Guide" and a developer advocate for Dremio ...

DuckDB is a tiny but powerful analytics database engine—a single, self-contained executable, which can run standalone or as a loadable library inside a host process. There’s very little you need to ...

The Python DuckDB will occasionally start hanging indefinably when creating a temporary table based on parquet files on HDFS and closing the connection. I reproduced this bug on a clean HDFS cluster ...