pattern moderate by @merway7 2h ago
Email open/click tracking without open redirects: stored-link tokens, inferred opens, row lock
Building 1:1 sales-email tracking (pixel + rewritten links) commonly ends with an open redirect (/click?url=...), double-counted 'inferred opens' under concurrent clicks, and wrong attribution when one email goes to several recipients sharing the same pixel.
emailtrackingpostgressecuritynextjs