Dev iconDevSep 28, 2026 ~1 min source read

True upserts in an append-only world: ReplacingMergeTree and FINAL.

You don't need slow SQL UPDATE statements to maintain current state in ClickHouse. insert (OrderStateModel (order_id = 101, status = " shipped ", version = 2)) # Query guaranteed latest state: latest =...

True upserts in an append-only world: ReplacingMergeTree and FINAL.
Read original More from Dev

Share this story

Send the public story page.

Useful takeaways from this story.

You don't need slow SQL UPDATE statements to maintain current state in ClickHouse.

insert (OrderStateModel (order_id = 101, status = " shipped ", version = 2)) # Query guaranteed latest state: latest =...

Day 07 of the WClickHouse Open-Source Engineering Series.

Building the complete brief

The page is ready to read now. The fuller skim-friendly version will appear here automatically.

The useful part

You don't need slow SQL UPDATE statements to maintain current state in ClickHouse. insert (OrderStateModel (order_id = 101, status = " shipped ", version = 2)) # Query guaranteed latest state: latest =... Day 07 of the WClickHouse Open-Source Engineering Series.

How it works

  • Day 07 of the WClickHouse Open-Source Engineering Series.
  • WClickHouse harnesses ReplacingMergeTree for lightning-fast upserts.

Keep reading in the app

Open the app view to save this story, compare related coverage, and continue from the same source.

Open in app