Declaration

CREATE TABLE page_views (
  page_id text PRIMARY KEY,
  views counter
);
UPDATE page_views SET views = views + 1 WHERE page_id = 'home';
Advertisement

Semantics

Idempotency NOT guaranteed. Retries can double-count. Handle carefully.

Advertisement

No mix

Counter table can only have counter columns + primary key. No regular columns. Separate table pattern.