Skip to main content

BigQuery MERGE Is Not a Uniqueness Constraint: A Replay-Safe Tutorial

A MERGE can be atomic and still leave duplicate business keys. The missing ingredient is a clear key and version contract. This tutorial builds a current-state orders table, not an event-history table. One row represents one order_id . It assumes a single writer and a source-provided, monotonically increasing integer version per order. Timestamps alone are not that contract. Why the obvious MERGE…

dev.to ·32m ago

We haven't written up this one. Dev.to has the full story — the link below goes straight to it.

Read the original at dev.to →

More in Tech

Designing allow, deny and hooks is becoming the new code review

Originally published at https://aicoding-guide.com . On a team that uses coding agents daily, the highest-leverage thing to review shifts from the code itself to the design of allow, deny and hooks.

32m ago ·dev.to

A 15-inch Windows laptop with a number pad and an Ethernet port, priced like a Chromebook

Lenovo’s V15 G6 is a full-size Windows laptop selling for $459.99 at Amazon, a third under its $699.99 list price, and it gets there without shrinking the machine into a travel toy.

33m ago ·the-gadgeteer.com

Full-page screenshots of hundreds of URLs, without cookie banners or missing images

Taking one screenshot of a web page is easy. Taking a few hundred, unattended, and getting images you can actually use is not.

Bulk Website Screenshot tool captures multiple web page screenshots in bulk.
Resolves issues like cookie banners obscuring pages, missing images, and pages failing to load.
Python integration allows using the tool from Python in just a few minutes.

33m ago ·dev.to

Multiple Microsoft 365 services are experiencing an outage

Outlook and Teams are among the platforms impacted by "elevated load" issues.

32m ago ·engadget.com

Multilingual API Summaries Explained: Support Emails and Meeting Notes (3 Node.js Checks)

Per-tenant visibility requires attribution, but recording every prompt would turn moderation telemetry into another sensitive content store.

32m ago ·dev.to

How to compare a nearshore engineer to a US hire using only public BLS data

US hiring teams often compare a nearshore rate with a US salary and stop there. That comparison is incomplete: a salaried employee also costs benefits, paid leave and the employer's payroll taxes.

BLS data used to compare nearshore engineer cost to US hire
Median software developer wage $135,980 in May 2025
Nearshore engineers cost 29-40% less than fully loaded US hire

32m ago ·dev.to

More from Thursday 12 November →