BC's permanent DST shift will break Postgres timestamps

Data · 2026-06-25

Data Engineering

How Booking.com Stops Data‑Quality Decay with Early‑Stage Checks11 MIN

Booking.com treats tiny data‑quality slips like broken windows: left unchecked they erode trust across the whole warehouse. By moving linting, modeling reviews and automated tests into the development pipeline, they halt the cascade of inconsistencies before they embed into dashboards and business logic.

Build a production‑grade data pipeline for under €35 a month10 MIN

The repo ships a production‑shaped pipeline that stitches together DuckDB, Dagster, dlt and dbt on a single €35‑per‑month VM. It pulls open‑source Danish Parliament and Rfam data into a medallion architecture and surfaces insights via Metabase, showing you can run serious data engineering without cloud lock‑in or big spend.

ML & AI for Data

Reasoning Chains Boost Fact Recall in LLMs, Revealing Hidden Knowledge6 MIN

Google researchers show that letting LLMs generate a brief reasoning trace lets them pull correct answers that are otherwise invisible in the model’s top‑1 output. Two mechanisms, latent computation buffering and factual priming, explain the effect, suggesting that simple chain‑of‑thought prompting can substantially improve closed‑book QA without extra training.

LY Corp’s AI agent slashes analytics turnaround from weeks to minutes13 MIN

LY Corp deployed a generative‑AI agent that automates query formulation, execution, and insight synthesis, cutting typical analysis lead time from two weeks to about ten minutes. The system stitches business questions to data, using staged metadata, SQL guardrails and supervisor agents, unlocking hundreds of analyses per month.

Talos automates rare disease reanalysis, limiting review to 1.3 variants per patient7 MIN

Talos re‑examines stored genomic data as knowledge evolves, recovering 90 % of diagnosable cases while surfacing only 1.3 candidate variants per patient. In a cohort of ~5,000 undiagnosed patients it added 241 new diagnoses, 5 % extra yield, with analysts reviewing just one new variant per 200 patients. This makes systematic, frequent reanalysis sustainable at scale.

Databases & Storage

BC’s permanent DST shift will break Postgres timestamps6 MIN

On March 8 2026 BC will stay on Pacific Daylight Time year‑round, making America/Vancouver permanently UTC‑7. Because Postgres timestamptz stores UTC and applies the current tz rules on query, appointments saved before the change will appear an hour off later. Store the intended local time and its zone, or update tzdata, to avoid the bug.

MySQL Time‑Travel Recovery via Continuous Binlog Indexing1 MIN

dbtrail streams MySQL binlogs to keep a searchable index of every row change with before‑and‑after images. It lets teams run time‑travel queries, generate precise reversal SQL, and recover lost cascade deletions without locking or schema changes, all from a web console or AI‑driven MCP client.

A New Taxonomy Maps Modern Data Systems From OLTP to LTAP6 MIN

Jack Van Lightly introduces a compact taxonomy that classifies modern storage architectures by system count, workload mix, data visibility, and durable copies. It neatly positions emerging LTAP designs alongside OLTP, OLAP, and HTAP, giving engineers a shared vocabulary to compare single‑tier, tiered, hybrid, and materializing patterns.

Practice & Datasets

Why Even the Best Data Teams Lose Influence: They Skip the Decision Layer12 MIN

Technical chops and flawless pipelines no longer guarantee impact. Teams that stop at delivering data miss the crucial perspective layer that turns insights into decisions. Adding opinionated analysis and business context re‑anchors data work to real outcomes, preventing irrelevance and budget cuts.