MySQL Stuff

Upgraded my mySQL server from 3.23.58 to 4.1.11 – all in one fell swoop.

Except for a white space I inserted in a config file that I should not have, an unbelievably simple and not complicated upgrade. Swap out the engine, change some config files…don’t touch the data files (MYD,MYI,frm) – yep, kept ISAM tables.

And it worked. Huh! I like that…

And now I get sub-selects! *Shrug* Again, this is why people flame mySQL – this should have been in there l.o.n.g ago.

To me.

But now I’m a happy pseudo-DBA.

Bad Landscaping News

On the downside, we found out last week that one of the two huge trees in our backyard – the Norway maple – was going to have to go.

We knew this was coming – we’ve had the tree service out three years in a row to make sure it was stable for another year – but still, it’s sad. It’s a great tree. And the picture to the the right is the only one I can currently find of the tree. I’m sure I have one somewhere else, but I usually take closeups, not step back and view the whole tree.

On the upside, this will give us more sun in the backyard, so we can plant more of the sun-loving plants that we like.

On the downside – beyond the mere loss of a great tree – is that this tree was near the house and arched over the sunroom – so we’re going to lose that insulating effect in the summer. (In the winter, leaves dropped and whatever sun exisited came through. Perfect!).

The other tree – a freakin’ huge silver maple is in great shape, accoring to the arborist. This tree is about 60-80 feet tall, with a base diameter of about 3.5 feet. It’s a beaut.

Power Landscaping

Well, spring has (finally) sprung in the Chicago area, and I spent a good part of today out the yard doing clean-up: Specifically, the bushes along the back fence.

This area has been pretty much ignored by me since moving in (will be six years this October, methinks), and – from the looks of things – pretty much ingored for over a decade. Bleh.

Basically, I was trying to trim and thin the row of deciduous shurbs along the fence (I don’t even know what kind of shrubs they are). My tools? Pruners, an electric bush trimmer and (drumroll, please)…a genuine Milwaukee Saws-All.

Yep. More power pruning.

I took out as much as was left – all either dead, dying or not a bush (emerging trees). One such tree I took out has, with a quick count, 13 years of rings. A fruit tree (crabapple – Malus something or other). Yep, it’s been growing there for over a dozen years.

Hopefully I won’t let it get that bad again anytime soon…

Permalink Me Up Scotty!

I’ve bitched about the lack of features on Blogger – vs, for example MT – and I’ve also said that I expected big things from Google this year.

OK.

One of my gripes has been the lack of permalink support in Blogger.

Today, I discovered that it exists.

When did this happen? Are the blackouts coming back again? (Probably)

So I re-coded some templates, fixed some RSS generate/parse scripts and we are fucking almost happy now.

Not bad for late Friday night coding.

Bellow Be Gone

Saul Bellow, Nobel Laureate, died this Tuesday.

I’ve been writing the entry in my head for a few days, but reality intervened, and so it’s at this late date (three days late) that I comment on the event.

Or more properly, to share my thoughts on Bellow.

Bellow is a mixed bag for me – I think he is one of the giants of 20th Century literature, but I have not read as much of him as I would like to. And I tend to rank his literary output differently than the “experts” (whomever they may be…).

I think Bellow is on par with Hemingway and Faulkner as the greats of 20th Century American writers (yes, I know Bellow was born in Canada). Steinbeck’s star has fallen, with only a handful of his works today rating as “very important” (The Grapes of Wrath remains one of the books of the 20th century, especially in American Lit).

Bellow is probably the most literary of the this trio – a writer’s writer. As such, he is often overly scholarly, often too didactic for most non-English major types. Faulkner is equally unreadable, but in different ways (can you say page-long paragraphs??).

Yet Bellow remains a favorite (for this yes-I’m-an-English-major type).

My favorite Bellow invention is The Adventures of Augie March – while the ending is (to me) somewhat of a letdown, an over-all brilliant and entertaining book. I rank it higher than the book most view as Bellow’s best, Herzog – another personal favorite, don’t get me wrong.

How can you not resist the following?

I am American, Chicago-born — Chicago, that somber city — and go at things as I have taught myself, free-style, and will make the record in my own way: first to knock, first admitted; sometimes an innocent knock, sometimes a not so innocent. But a man’s character is his fate, says Heraclitus, and in the end there isn’t any way to disguise the nature of the knocks by acoustical work on the door or gloving the knuckles.

 –The Adventures of Augie March, opening lines.

OK, maybe you can resist, but … you shouldn’t.

Bellow’s significant literary output was in the 1950s-1970s or so; he really hasn’t been relevent since. But a brilliant writer.

And I just thought of something – Bellow, born in Canada, wrote his best works about America (such as the Chicagoan Augie March).

Hemingway – probably my favorite American writer – really didn’t write much about America. Huh. Interesting. I never really thought about it before. With the exception of his early short stories – The Nick Adams Stories – Hemingway writes pretty much exclusively about Europe and Africa. I’m just glancing at my bookshelf now and here is what I’m seeing:

  • A Farewell to Arms – Italy mainly
  • Green Hills of Africa – Uh, Africa
  • For Whom the Bell Tolls – Spain during the Spanish Civil War
  • The Sun Also Rises – France and Spain
  • The Snows of Kilimanjaro (short stories) – Mainly Africa
  • A Moveable Feast – France, mainly Paris

Odd, I guess, for such an Amercian author. I never really thought about it before. Faulkner, of course, pretty much never left Mississippi in his work, and Steinbeck did a lot of West Coast centric writing.

But we’ve lost Saul Bellow.

For those of you who’ve never read it, a subtle, incredibly underrated Bellow novel is More Die of Heartbreak. Odd, warm, slim.

Read.

Singing the Praises of Templating

I’ve had this blog for about four years now, and I’ve made a bunch of changes to the look and feel of the site over this time.

However, about two years ago – when I started getting serious about this – I rebuilt this blog on standards (CSS, valid HTML etc) and tried to make it as modular as possible.

I am still hosted at Blogger for the day-to-day blogger output, but I have a bunch of home-grown apps that I generate on an as-updated basis one of my home Linux boxes. These areas (such as Top Ten Lists and Reviews) are databased at home and pushed to my web site as needed. (PHP/mySql for those who care.)

So, I need templates to keep things sane.

Which I’ve done.

I just did a major CSS upgrade of this site (added/changed alternate style – another boon), and – once done with the CSS coding – all I had to do was update two template files (one at Blogger, one on my local box) and republish.

And everything is completely up-to-date and in synch.

I love it when I accidently do something correctly…god bless the template gods.

Firefox Updates

I like the Firefox browser as much as any web-savvy geek, but I have one quibble with it: The patchless-upgrade process.

I began with a pre-lease version of Firefox, upgraded to 1.0, then downloaded and installed the bug/security-fix releases 1.01 and 1.02. While it’s not biggie for me with a fast connection, it is problematic that one has to download a ~4.5M upgrade for each point release.

It’s a full install each time (which does keep one’s preferences and so on, so that’s good).

That’s a pain.

I’m guessing the reasoning is to completely replace the older (broken in some way) engine and get the new one installed, instead of band-aid patches that will leave the browser more brittle. I’m OK with that, but I this may keep folks from upgrading in more timely manner, especially the dial-up folks.

Show Me the Way, to the Next Whiskey Bar

For those of you unfamiliar with The Whiskey Bar, it’s a very much left-leaning blog with terrific writing. Liberal, but not the foam-at-the-mouth, diss everything Republican and so on liberal. Thoughtful and well researched.

The Whiskey Bar was great reading during the 2004 election season, but the bar abruptly closed around the time of Rathergate.

The Whiskey Bar re-opened in January, but with a different format: Collections of quotations and lifted written passages tossed together to make a point.

Finally, on March 24, Billmon – the saloon keeper – finally posted some original writing explaining why he went off the grid, why he came back and so on. Brilliant stuff, whether you’re a liberal or not.

One compelling passage:

To paraphrase Hannah Arendt, the peculiar vulnerability of historical truth (which means political truth) is that it isn’t inherently more plausible than outright lies, since the facts could always have been otherwise. And in a world where the airwaves are overloaded 24/7 with the mindless babbling of complete idiots, it isn’t very hard to make inconvenient facts disappear, or create new pseudofacts that reinforce whatever bias or cultural affinity you want to cultivate – particularly if the audience is already disposed to prefer your reassuring lies to discomforting truths told by strangers.

And that’s just a taste.

Billmon’s point is that the Democrats lost because Rove and his minions really understood how the game is played today. The Whiskey Bar doesn’t like this new game, but he gives the Rovarions credit for playing this game well.

Read.

XML Quagmire

I’ve been followoing the issue of XML standards/bifurcation and so on for too long now, but I’m still uncertain about the ramifications of it all.

Comment: Yep, binary is better – faster.

Questions:

  • Is this flavor of faster necessarily faster enough to matter?
  • Is it better to have mulitple XML-binary formats? Sure, better for each one but…overall?
  • Look at the whole Atom vs. RSS/RDF issue. Does XML really want to go down this road?

This sounds like a spanking for the non-ASCII XML folks.

It is, but with a caveat: Remember VRML?

It was brilliant, flexible, easy to code (for a programmer) and in ASCII. And required a plug-in, much like Flash does. XML requires SOME sorta of parser, as well, both not browser native, let’s say.

Flash is not easy to code for a programmer (no JS-like code to hack). It’s compiled to … uh, a binary.

I just don’t know. I really don’t.

But I’m glad to see this XML-thingee starting to (finally!) gain traction with the masses. The next year or so will be interesting in this space.