Article URL: Six SQL patterns I use to catch transaction fraud Comments URL: https://news.ycombinator.com/item.id=48155212 Points: 24 # Comments: 0.
This is the kind of stuff I wish more “fraud detection” posts showed — actual queries, not just vibes. Even outside fraud, those window-function velocity patterns are basically the SQL version of spotting feedback loops in a signal chain: you’re not looking at one event, you’re looking at the timing between events.
