General
Two data modeling approaches are tested for performance: a traditional dimensional model with joins vs a One Big Table, using DuckDB and PostgreSQL. The author shows that joins are not expensive and that wide tables can incur non linear CPU costs as the number of columns increases, with caveats based on engine and workload. Kimball's data warehousing principles are discussed, and the article concludes that joins often win, especially with filters.
The article addresses a DKIM failure issue reported by Google for a domain held at Cloudflare with email hosted through Office 365. Despite successful DKIM tests and configurations…
The article recounts building QZ to unlock closed fitness devices and highlights a July 2025 firmware update by Echelon that bricks devices by requiring server authentication. It a…
Geothermal
Quaise Energy reports drilling 100 meters with millimeter-wave drilling technology, a milestone toward accessing deeper, hotter geothermal resources. The piece outlines the technology, historical context, and plans for a future pilot plant, highlighting MIT research and the use of a gyrotron to ablate rock.