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 ...

DuckDB is an open-source, in-process analytical database engine designed for efficient querying of large datasets. Known as the "SQLite for analytics," it seamlessly integrates with Python and offers ...

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 ...

Ever felt the frustration of wrangling with mountains of data through web scraping? The landscape of marketing technology is constantly growing and #marketing teams are experimenting with new tools ...

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 ...