HackerNews Summary (2023-05-17 08PM)

Source: New York City May Be Sinking Under the Weight of Its Skyscrapers

Summary
New research has found that New York’s buildings, with an estimated weight of 1.68tn pounds, could potentially contribute to the city sinking. According to scientists, New York experiences a subsidence rate of approximately 1-2mm per year on average, leading to concerns of the impact of climate change and increasing hurricane intensity.

Facts

🌊 One to two millimeters of subsidence per year is enough to cause serious problems to coastal cities in the future

🏢 The cumulative weight of New York’s buildings is estimated to be 1.68tn pounds

🌉 Lower Manhattan, Brooklyn, and Queens are the most susceptible areas to subsidence risks

---

Source: Announcing DuckDB 0.8.0

Summary
DuckDB has released version 0.8.0, named “Fulvigula,” including new pivot and unpivot statements, improvements to parallel data import/export, time series joins, recursive globbing, lazy-loading of storage metadata, user-defined functions for Python, Arrow Database Connectivity (ADBC) support, and new Swift integration.

Fact

🆕 DuckDB 0.8.0 includes many new features, such as pivot and unpivot statements, time series joins, recursive globbing, lazy-loading of storage metadata, and more.

🤝 ADBC support and new Swift integration have also been added to the release.

🐣 Two breaking changes were made to the SQL dialect, including the default null sort order being changed from NULLS FIRST to NULLS LAST and the division operator now performing floating point division by default.

---

Source: abiosoft/colima: Container runtimes on macOS (and Linux) with minimal setup

Summary
Colima is a container runtime that enables the running of Docker and Kubernetes on macOS without the need for extensive setup. It supports Intel and M1 Macs, has a simple CLI interface, and allows for port forwarding, volume mounts, and multiple instances. It is available on Homebrew, MacPorts, and Nix.

Fact

💻 Colima enables Docker and Kubernetes to run on macOS with minimal setup

🐳 Docker and Containerd are supported runtimes

🚪 Port Forwarding and 🏭 Volume Mounts are supported

🔍 Includes multiple instances and has a simple CLI interface

🤝 Colima uses the MIT license and accepts contributions

---