I recently read an article at 9 Reasons SQL has Got to Go suggesting that SQL has “got to go”. This article is misguided, and the claims are patently false. I’ll discuss the points the original author made, and why I believe they are off the mark.
Tables Do Scale
I live in Canada. The Bank of Canada estimates there are approximately 30 million financial transactions per day in this country. We have what we call the “Big 5” banks. If we assume they get the brunt of these transactions (let’s say two-thirds), that would be 20 million transactions. If we assume an even distribution, that means they each handle about 4 million transactions per day. Banks have been handling this kind of load every day for years, and use SQL.