This week in infrastructure
MariaDB adds DuckDB as a storage engine for analytics, based on AliSQL integration.
MariaDB adds DuckDB as a storage engine for analytics, based on AliSQL integration.
Analysis of a 1.75B-record airport weather dataset using DuckDB and QGIS on a high-end workstation.
Explores using DuckDB and Polars to query and write to Iceberg tables, covering new features, workflows, and practical patterns.
Explores modern single-node data engineering tools like DuckDB, DataFusion, Polars, and LakeSail built on Apache Arrow for high-performance analytics.
Analysis of e-bike fleet data from Bird, Lime, and Neuron APIs using DuckDB and QGIS.
Analysis of 10K+ satellites using GCAT dataset, DuckDB, and QGIS on a high-end workstation.
A curated list of interesting tech links for April 2026, covering data engineering, analytics, and AI integration.
Guide to using Apache Iceberg with Python libraries (PyIceberg, DuckDB, Polars) and MPP query engines like Dremio, Spark, and Trino.
Building a reverse geocoder using Overture Maps datasets to fetch country codes, addresses, and polygon data without API fees.
Review of the updated GM-SEUS dataset v2 with 3.4M solar panels and new rooftop arrays, including technical setup and analysis tools.
A technical walkthrough of converting Canada's wind turbine database to Parquet format and analyzing it using DuckDB, QGIS, and command-line tools.
Analysis of Microsoft's 2026 Global ML Building Footprints dataset, including technical setup and data exploration using DuckDB and QGIS.
Analyzing All The Places' open-source location data project, detailing the technical setup and process for downloading and examining millions of brand locations.
A technical analysis and comparison of various administrative boundary datasets, including OpenStreetMap, using Python, DuckDB, and QGIS.
Analyzing Business Insider's dataset on US data center locations, ownership, and resource consumption using Python, DuckDB, and QGIS.
A technical walkthrough of converting the US Wind Turbine Database to Parquet format and analyzing it using tools like GDAL, DuckDB, and QGIS.
A guide on importing Java Flight Recorder (JFR) profiling data into DuckDB for analysis using SQL queries.
Exploring the GM-SEUS dataset of US solar farms using GIS tools like QGIS and DuckDB for spatial data analysis.
A technical exploration of the ICMM's global mining dataset, detailing the setup, tools, and process for data analysis using Python, DuckDB, and QGIS.
An analysis of Statistics Canada's Open Database of Buildings (ODB) dataset, covering data processing, tools used, and technical setup.