[fizx]

Why should relational db writes not be idempotent? MySQL example:

  INSERT INTO table (id, a, b) VALUES (1,2,3)
    ON DUPLICATE KEY UPDATE a=2, b=3;