The more I work with computers, the less I trust them.
Please keep in mind that I do adore the things. Photoshop, blogging, video games, eBay. I dare say the course of my life would have been quite different, had I been born 15 years later and had access to all these wonders at the reasonable prices they cost today. I certainly wouldn't spend so many lonely hours trolling eBay for antique typewriters, that's for certain.
Then there's what I've come to think of as the dark side of computers: accounting programs, inventory management, billing software. And at the heart of all these dark applications lies the database.
Simple databases are buggy enough, when you're just using one table to track a single set of data, like a card catalog or an address book. You mis-type things. You don't notice when the cursor jumped to the wrong field.
When databases start to get relational - customer data linked to purchase history linked to inventory - and when you have a whole organization of employees and managers pounding new information into these things on dozens of terminals, they're a nightmare.
Well, maybe you don't have nightmares about these things. But anyone with my low-grade level of OCD can probably sympathize.
What really blows me away is the amount of trust we invest in these systems. "Computer says...so must be true." As if no one could have entered the wrong price for a product, no programmer could have plugged the wrong constant into his code for calculating a tax. As if no hard drive ever degraded and corrupted its contents.
I once worked at a small tobacconist where our system's reports told us we were doing millions of dollars in sales every day. Millions!
We had to throw out months of reports. Eventually we realized the system was multiplying the price of each item by the square of the quantity to give us that item's sales total. If someone bought five cigars, the system reported as if they'd purchased 25.
There's no good reason for that.
There was no easy way to get in to the source code, so we tried calling the software vendor to get them to fix the problem. Unfortunately they'd gone out of business - one month after cashing our check for the next year's tech support. (Oh, how we trust our machines and the folks who build them!)
Also:
A friend of mine was hauled away in handcuffs after being pulled over for a routine traffic stop. An outstanding arrest warrant claimed he had deposited a year's worth of his deceased mother's social security checks into their joint account. Pretty serious charges - you can understand why the officer was so aggressive.
But the bank which had filed the charges had mis-entered the date of the mother's death in the system. They were off by one year. After paying bail and spending a night in the hospital with life-threatening high blood pressure, my friend received an apologetic letter from the bank. Still, there's no reason for that.
And now:
I'm working as a picture framer for an art store. I like it. It's a handy trade and a challenging combination of the visual, physical, and intellectual. We use a stunning pneumatic CAD driven mat-cutting machine and we have software that'll show you what your artwork will look like framed up in the moulding of your choice. This thing does ovals, embossing, scrollwork, lettering, reverse-bevels - you name it. When I saw this thing my inner-child started doing somersaults.
Unfortunately the computer also does our price quotes.
There are some fairly tedious calculations to be made when estimating a framing job: glass, mats, labor, mounting, and linear feet of moulding all have to be considered. The software does speed all this up, which makes things more comfortable when I'm facing an impatient customer. But sometimes the prices are unreasonable. Museum glass often comes in too low, and plexi might as well be plutonium as far as the computer's concerned.
"Where is it getting these prices?" I asked the store manager.
"Well, it's supposed to download them directly from the vendors, but those didn't seem right either so we just went in there and set them ourselves."
"For every possible size?"
"No, you put in for the sheet and the computer figures down for the different sizes. Somehow."
Worse, the system doesn't leave any wiggle-room for when you want to lower your price for a good customer or an easy job, or raise it for some extra-special service. So right now we fudge such calculations with the cryptic "extra fitting charge," which we can't set precisely but usually kicks in at an appropriate amount for that little something extra. If we're really going the extra mile (with custom calligraphy work, or hand drawn french-lines, for example), we can charge for the "extra fitting" two or three times. But every time we do this we have to make copious hand-written notes on every copy of the invoice so that customer, framer, and accountant all understand.
There's no reason for this.
And wait! Once that's all been fudged to perfection, we carry the invoice over to the QuickBooks Point of Sale system and enter the total over there, since the framing computer can't handle all the transactions we need the sales computer to handle. Where the framing computer doesn't allow us the flexibility we need, Quickbooks leaves itself so open to tampering that any one of us can log into any record and monkey with quantities, prices, tax rates - whatever. It's a good thing we all trust each other. (It's a great crew. Like I said, I really enjoy the job.) But the potential for hitting a couple wrong keys and trashing the sales history is immense.
Hmm. This has devolved into a rather dull work-related rant. So here's a deep observation to make up for it: 95% of this millennium's "Modern American Experience" is comprised of these frustrating moments we spend with our machines. We may have wonderful times with them too, but if we're not careful, these petty disasters will come to overwhelm the collective consciousness.
We don't want that, do we?
Anyway, here's my two-pronged reaction to computers. When we use them to create things, I'll embrace them. What artist doesn't want a soft new set of brushes? What carpenter declines a box of shiny, cutting-edge tools?
But when they're applied to record-keeping, administration, or finance: it seems the only logical response to computers is wariness and distrust. I know I sound like an old codger here, and a dated codger at that. "You kids with your darn-fangled computer-boxes!" But it seems like we've grown more comfortable with these things as they got more powerful. We're oblivious to the fact that Moore's law is multiplying the potential for mistakes as fast as it multiplies processing power. I'm not complaining about "kids with PCs." Kids don't scare me. What scares me are the mouth-breathers at the RMV who enter all of our personal information into a database that could get us arrested if they make a single mistake.
We owe it to ourselves to fear the information that's gathered, processed, and displayed in databases. Is that really your bank balance? Have you checked? Has any human checked?
(And just how do they go about calculating your credit score?)
When information is about us, we need to question why it's been gathered in the first place.