Signal's he can check? So some random dude is looking at my credit card purchase history while playing around with his SQL queries?
SQL patterns I use to catch transaction fraud
81–90 of 138 posts
Re: SQL patterns I use to catch transaction fraud
#82> Real cardholders almost never buy something for exactly $1.00. Coffee is $4.73, gas is $52.81. The roundness is the signal. Surely this depends on how the vendor sets their prices? If you're going to buy something from a website to test a stolen credit card you don't just get to make up your own prices. And I think you may be over-indexing on the US "prices don't include tax" thing. Elsewhere, round-number prices a…
Re: SQL patterns I use to catch transaction fraud
#83Re: SQL patterns I use to catch transaction fraud
#84What if I go on a roadtrip and suddenly get gas at 2am?
Re: SQL patterns I use to catch transaction fraud
#85Re: SQL patterns I use to catch transaction fraud
#86Hacker News, we need to talk! "Fixel Smith" is an AI-generated person, with an article that has very little to do with fraud analysis. 'This' is also a music artist (1), novelist (2), fraud analyst (3), influencer (4), and whatever else you can imagine. 220+ points and 70 comments, and very few notice it's quite a fake post — and no one that it's an AI generated person? 1. https://www.amazon.it/Forged-Soundtrack-Expl…
I was checking the submission on the phone and only peeked at the comments section. While it's not always easy to judge if something is AI-generated or edited, here it was obvious at first glance from the quotes. Assuming that all of the comments were done in good faith, I think that the low AI literacy even here is really concerning.
Well,sure. But some people come here just for the comments and don't read the articles
Re: SQL patterns I use to catch transaction fraud
#87What about the tables?
Re: SQL patterns I use to catch transaction fraud
#88For example "Impossible travel": these days you can add your credit card to your phone and use Apple Pay. Well, this is useful for many things, one of them being adding your credit card to your kid's (teenager) phone, so that your kid can use your card in case of need/emergency when they are away from you. I did exactly that recently and actually worried about fraud control systems when my child paid using my card in Boston while I was in Europe.
Many things which you think are true might not be.
Anecdotally, US banks are terrible at building fraud control systems. It seems US banks assume any transaction that is charged by an entity outside the US is fraud. In my 10-year history of running a SaaS, the US banks and their "fraud control" systems have been one of the biggest billing problems.
Re: SQL patterns I use to catch transaction fraud
#89After 35 years of building software systems I've learned to temper my hubris. These days I rarely assume things to be "definitely true". For example "Impossible travel": these days you can add your credit card to your phone and use Apple Pay. Well, this is useful for many things, one of them being adding your credit card to your kid's (teenager) phone, so that your kid can use your card in case of need/emergency when…