Ok, I’ve been thinking blogs are a pain in the ass because you have to keep checking everybody’s blogs to see if they updated it recently. And then today I discovered RSS feeds. Actually, I’d heard a little about them in the past but never paid any attention to them. I kept wondering what this “Syndicate this site (XML)” link was on my own blog. And I wondered about Simon’s BBC News app and how it worked.
It suddenly all came together, and I discovered that there are RSS readers that you can use to subscribe to a number of blogs and news sites, and it will tell you when they’re updated. Sweeeet.
I googled for an application. NetNewsWireLite is the first one I found that was free for OS X. It seems ok, although I’d like the option to poll the sites more frequently than once every 30 minutes.
I’ll have to find one for Linux as well, so I don’t have to spend all day at work hitting refresh on Slashdot, Linux Today and The Register.
At work, we had an operation that was taking too damn long. Looked at the code, looked at the query it was generating, and it was pretty horrible, but I don’t see any way to avoid doing it. Then used the SQL “explain” on the query. Hmmm, it’s doing a sequential scan on two different tables. Hmm… Put an index on one column on one of the tables. Suddenly it’s only doing a lookup on one table. Ran downstairs to the big 30-plex test machine. Did the test once. Took 1:31. Added the index. Ran the test again. Took 0:08.
I’m a fucking genius.
I’m still working on the flying club web machine. I’ve put together a main page for them to look at. Basically I think the machine is functional as it is, but I want more.
Continue reading Still working on it
I’m setting up a computer for the flying club’s ops room. Basically I want this to be a “web kiosk”, as idiot proof as possible, because let’s face it, when it comes to computers, some pilots are complete idiots.
Continue reading Getting this thing to work
So I’ve had this blog for what, 3 days now? And already somebody posted a penis spam in the comments. So I had to remove the comment and ban the IP, which is a royal pain. All spammers must die. Painfully.