Lotus 1-2-3 was the killer app that made the IBM PC the standard for computers. It wasn’t the first spreadsheet, but it ran on a computer that could easily address more than 64K of memory, it was fast, and relatively bug free. So it was super successful. Today we know it as the thing people used before Excel. So what were the advantages and disadvantages of Lotus 1-2-3?
I get the occasional query from people who say I should promote my blog more, so that I can get an audience and write a book about this or that, and then I read stuff like this. Basically, writing is getting more and more commoditized, and writers are making less and less, not that they ever made much in the first place. And then I heard on a podcast that the average technical book sells 5,000 copies.
Fifteen years ago, I was in the home stretch of writing a book–my first, and so far only book. All told, I made around $13,000 off that book, between book royalties and publishing derivative articles in magazines, all before taxes, of course. I wrote about 20 hours a week for six months to do it, so, perhaps if I’d made it my full-time gig, I might have been able to make $52,000 a year. But that was when computer books were hot and big-box book stores were booming. I’m not confident I could make $52,000 as an author today. Read more
I’m sure all landlords have a story like this, but let me tell you my garbage disposal story. I don’t know what the last occupant put in that disposal, and I don’t want to know. What I do know is that it was completely seized up and wouldn’t run.
The motor hummed, which I know from years of tinkering with old Lionel and Marx electric trains that meant the motor wasn’t completely dead, so I had to find a way to free up whatever was keeping the motor from turning.
The usual fix is to use a garbage disposal wrench (which is really just an allen wrench–so you can use any allen wrench that fits) to spin the motor in both directions until it turns freely. There’s a little key in the center of the underside where the wrench goes. Mine wouldn’t budge. I wasn’t being wimpy either–I’d lean on it to the point where the disposal itself was shifting in its mount, but the motor stubbornly refused to go anywhere.
At this point I’d about written it off. A 1/3 horsepower Waste King Legend disposal costs around $55 online, and sometimes you can get their low-end half-horse unit for around $5 more, so I figured I didn’t have a whole lot to lose, and I knew I couldn’t make the disposal any worse.
Exomizer is a compression program for Commodore and other 8-bit computers. The compressed program still runs, but it takes up less space on disk. Decompressing takes some time, but usually less time than reading more data off a 1541 disk. And unlike native compression tools which sometimes take all night to run, Exomizer runs on modern PCs, so it runs extremely quickly.
The space savings isn’t as much of a consideration now as it was in 1986, but being able to cram as many programs as possible on a single disk image makes access more convenient.
I took my youngest son (approximately 4 months) to the hardware store with me today. First trip to the hardware store with Dad. Read more
There are commercial utilities that will optimize your HTML and your images, cutting the size down so your stuff loads faster and you save bandwidth. But I like free.
I found free.
Back in the day, I told you about two programs, one for Windows and one for Unix, that will crunch down your JPEGs by eliminating metadata that’s useless to Web browsers. The Unix program will also optimize the Huffman tables and optionally resample the JPEG into a lossier image, which can net you tremendous savings but might also lower image quality unacceptably.
Yesterday I stumbled across a program on Freshmeat that strips out extraneous whitespace from HTML and XML files called htmlcrunch. Optionally, it will also remove comments. The program works in DOS–including under a command prompt in Windows 9x/NT/2000/XP, and it knows how to handle long filenames–or Unix.
It’s not advertised as such, but I suspect it ought to also work on PHP and ASP files.
How much it will save you depends on your coding style, of course. If you tend to put each tag on one line with lots of pretty indentation like they teach in computer science classes, it will probably save you a ton. If you code HTML like me, it’ll save you somewhat less. If you use a WYSIWYG editor, it’ll probably save you a fair bit.
It works well in conjunction with other tools. If you use a WYSIWYG editor, I suggest you first run the code through HTML Tidy first. HTML Tidy, unlike htmlcrunch, actually interprets the HTML and removes some troublesome information. But in some cases, HTML Tidy will add characters, but this is usually a good thing–its changes improve browser compatibility. If you feed HTML Tidy a bunch of broken HTML, it’ll fix it for you.
You can further optimize your HTML with the help of a pair of Unix commands. But you run Windows? No sweat. You can grab native Windows command-line versions of a whole slew of Unix tools in one big Zip file here.
I’ve found that these HTML tools sometimes leave spaces between HTML elements under some circumstances. Whether this is intentional or a bug in the code, who knows. But it’s easy to fix with the Unix tr command:
tr "> indexopt.html
Some people believe that Web browsers parse 255-character lines faster than any other line length. I’ve never seen this demonstrated. And in my experience, any Web browser parses straight-up HTML plenty fast no matter what, unless you’re running a seriously, seriously underpowered machine, in which case optimizing the HTML isn’t going to make a whole lot of difference. Also in my experience, every browser I’ve looked at parses CSS entirely too slow. It takes most browsers longer to render this page than it takes for my server to send it over my pokey DSL line. I’ve tried mashing my stylesheets down and multiple 255-character lines versus no linebreaks whatsoever made little, if any, difference.
But if you want to try it yourself, pass your now-optimized HTML file(s) through the standard Unix fmt command, like so:
fmt -w 255 index.html > index255.html
Optimizing your HTML files to the extreme will take a little time, but it’s probably something you only have to do once, and your page visitors will thank you for it.
I had a big surprise Sunday night. A couple of months ago, I was up at Bethlehem Lutheran Church in north St. Louis, and they asked me if I’d come to their Christmas banquet this year. I said I’d love to come to their Christmas banquet. They said they’d send me tickets. “Some” ended up meaning five. They’re generous people. I ended up using one–I didn’t feel like looking too hard for a date, and I felt weird asking a bunch of my friends who’ve never been up there to go with me on a rainy Sunday night.
My relationship with Bethlehem goes back several years. I moved to St. Louis in Nov. 1998, and immediately started going to a church in Oakville, a semi-ritzy, very white-middle class suburb in south St. Louis County. I was driving 30 minutes to go to church every Sunday because I had connections there, and I’d never seen a church that was so on fire. I liked it there. It was a church that made me better, and, as I would quickly learn, it was more than willing to let me make it better too. Mark my words: When you find a church like that, keep it. They’re harder to find than you might think.
In Faith Lutheran in Oakville and Bethlehem Lutheran in St. Louis, I’ve found two. And I’m much the better for it.
The north St. Louis neighborhood around Bethlehem is about as opposite of Oakville as you can get. It’s not ghetto, but the buildings are well past their prime. A number of them are condemned. Many others are boarded up. It’s lower-middle class at best. But there are people there who are trying to make a difference.
I’d been going to Faith Lutheran in Oakville for a couple of weeks when I started receiving its newsletter. And in that first newsletter was a blurb from The Rev. John Schmidtke, the pastor at Bethlehem. Faith is one of five suburban churches that has partnered with Bethlehem to reach out to its community. Pastor Schmidtke’s letter was a wish list of sorts, but he wasn’t wanting money or objects. He wanted people. “Who can help us build a computer lab so we can teach elementary computer skills to the people of our community?” he asked. “Who can help us give our children a safe, welcome place where they can sit down at a computer and do their homework?” At the end of the letter, he gave his phone number.
The next day, I called him.
He said he already had some beat-up PCs that had been donated to him. I asked when I could come look at them. I don’t really remember many specifics anymore, other than driving into north St. Louis in a snowstorm one night to come look at a pair of beat-up Compaq Proliant servers. They were DX2-66s, decked out with external SCSI CD-ROM towers. One of them had three SCSI drives. The other had five. They were pretty snazzy servers… in 1993.
It was a humble beginning. Pastor solicited some obsolete computers from other businesses, and since this was the midst of the Y2K crunch, he was able to find plenty of people willing to give up some 386s and 486s they’d just retired. The best catch was a pair of non-compliant Pentium-75s. One of them even had a hard drive–a 40-megger. No, not a 40-gig drive. A 40-meg drive, like most of us had in our first AT clone.
Basically, we had a whole lot of nothing, and I did a whole lot of nothing with it. Sure, I was able to impress a few people by taking hard drives out of 486s and putting them in those Pentiums and booting up DOS, but as far as doing anything useful, we didn’t have much. So the project pretty much sat there, a pile of beat-up PCs in the corner of a storage room.
Then one day in the summer of 2000, I got a voice mail message. It was Pastor Schmidtke. He sounded excited, but there was a certain plea in his voice. He had a grant for several thousand dollars, and it was pretty much there for the asking, assuming he knew what to ask for. He didn’t know what to ask for. So he asked me if he could have five minutes of my time to tell him the wisest way to spend a few thousand dollars to build a computer lab.
I hopped on the ‘Net and checked it out, then faxed him a shopping list. For the budget he gave me, I figured I’d be able to get several name-brand PCs and a laser printer. The grant needed three competitive bids, so I priced systems from IBM, Compaq, and Dell to give him ballpark figures, plus phone numbers to call to get hard quotes if that was what he needed.
A few months later he had the money. A couple more months after that, we’d turned that money into eight new Compaq Deskpro PCs. I wasn’t going to leave him high and dry at that point–what good is a room full of computers when no one there knew how to make them go? A couple more months after that, some volunteers had turned that storage room into a nicely laid-out computer room. So then I set about taking those PCs, installing network cards, cabling and hubs, configuring them identically, and connecting a printer. We had a usable network. An Internet connection was the tough part. I took one of those Pentium-75s, installed a 56K modem and an Intel 10/100 NIC, and configured Freesco. We were live. While 56K dialup split among 9 PCs isn’t fabulous, it’s better than it sounds–while people are reading pages, after all, their computers aren’t loading stuff. I tried setting up a Squid server to help ease congestion a little, but Squid seemed to hurt as much as it helped, so I scrapped that idea.
So now, three years after we initially met, they have a working, useful computer lab. Neighborhood kids come in and research and type. Pastor’s family comes in, and with that many computers at their disposal, the kids can play around all they want for hours and his wife can get work done. It’s not the best, but it’s worlds beyond a pair of Pentium-75s. And in a neighborhood where a Pentium-200 is considered a luxury item, it’s doing a lot of good.
So I got to the banquet Sunday night and sat down at a table. There was a program sitting there at every place. I looked at it. “That’s nice,” I was thinking. “Star of Bethlehem Awards.” There were two people listed. Then I saw people were picking up the program and flipping pages. So I picked up mine, turned to the inside, and saw there were more than two people listed. Two more on page two, and then I turned to page 3 and saw my name. With a really kind write-up to go with it.
They read the write-up, along with everyone else’s writeup, after dinner. They gave each of us plaques and asked us to say a few words. I don’t remember exactly what I said–I’m not very comfortable giving impromptu speeches. It was Pastor Schmidtke who had the vision and who got the money. And it was Cathy, a member of the congregation, who made all the phone calls and made all the runs to Office Depot to get things like power strips and network cables when I ran out of power outlets or didn’t have quite enough reach. Maybe I could have done it all without them. But chances are I wouldn’t have. No one would have. One person can’t take on a project of that magnitude alone. It’ll kill you.
The speaker who read the write-up on me was interrupted by applause a couple of times. I got a round of applause as I walked up and another one as I sat down. Helping people like them is easy, because they appreciate it so much.
I hung the plaque up right after I got home. I guess that says something about priorities–I have an expensive Jesse Barnes print I bought more than a week ago that isn’t hung yet. But the sentiment behind that plaque is worth more than a room full of Jesse Barnes prints. It’s a nice plaque. It reads:
New Birth at Bethlehem
We Thank God For You
For your ongoing support, encouragement, and Christian love to the ministry of Jesus Christ through Bethlehem Lutheran Church. You are God’s Star for the ministry of Bethlehem.
December 16, 2001
Bethlehem Lutheran Church, St. Louis, MO
Daniel 12:3 reads as follows:
“Those who have insight will shine brightly like the brightness of the expanse of heaven, and those who lead the many to righteousness, like the stars forever and ever.”
There’s just one more thing I wish I’d said Sunday night. They’re a group of people trying to make a difference in north St. Louis. A lot of them are there by choice. They didn’t have to give me an opportunity, but they did. I’m glad they did.