Credit Card systems

Ovid on 2002-08-15T21:11:58

Question: Why would a bank never use MySQL for its banking systems?

Answer: Because you truly need ACID transactions for such critical systems (note: that link is outdated. MySQL has improved - somewhat - but it's still a decent explanation of ACID transactions). Never take a chance with people's money.

Given that you can go ahead and write apps that periodically crash, lose user preferences, or even accidentally wipe out data, the one thing that you should never, ever do is mess with someone's money. This leads me to the obvious question: why the heck are credit card processing systems such pieces of crud? One of the test servers that I am working with returns information that does not match real world data. I'm building and testing software that I cannot guarantee will work (granted, this is for a private system that you folks will never encounter) until I see it perform with customer's real-life credit cards. Oh joy!

Apparently, many of the credit card processors out there see programmers as a nuisance and aren't terribly inclined to answer questions. There are few things more annoying than getting a denied request only to have the processor tell you that they won't explain said requests -- even on a test system.

And don't even think about having the temerity to request up-to-date documentation ...


Re: Credit Card systems

vsergu on 2002-08-15T21:28:42

Someone offered me a "small" contract job recently, but when I heard that it involved accepting credit cards on the Web I fled screaming. Inevitably the client wants to do things that are horrendously bad ideas and won't pay to do things right (which usually involves getting a different, competent, and hence more expensive hosting service).

Into the broader topic

lachoy on 2002-08-15T21:31:39

This leads to one of my favorite silly topics: Nobody Does Anything Anywhere.

One of the few things that have been consistent at organizations I've worked at or consulted with is that most of the people do very little. So little, in fact, that it's amazing anything gets done at all. And most of my colleagues have had this same experience. It doesn't matter what the company is: a nonprofit advocacy organization, real estate, a utility company. There are huge inefficiencies riddled throughout the company -- the larger the company, the worse it is.

But what's truly remarkable is that things do get done. People and companies somehow muddle through whatever it is they're supposed to be doing, eventually coming to some sort of conclusion. Credit card transactions do get processed, even if it takes a while and a person has to step in at some point. (This might be more of a "give up and declare victory" sort of thing, but if it is everyone's doing it!)

And even nuttier: companies in the US are supposed to be the most productive in the world. If that's true, what the heck are they doing everywhere else? Maybe they've got their work vs. life priorities straight :-)