Archive for 2006

This is about a friend of mine named Marc. This morning Marc talked to his dad on the phone before going to work. After the phone call his dad went about his daily routine, including taking a bath. While he was in the bath, he died. A blood clot that had formed in his legs had travelled to his lungs, causing a seizure and killing him.

I don’t know how to deal with these things.

Marc and I worked together for two years and when we bought houses, we bought them in the same neighborhood. We’re one street over and we can see each other’s houses by looking out a window. So when he found out and came home, he came over to talk to me. Being guys, and not the 21st century metrosexual kind of guys, he didn’t come over for a shoulder to cry on. He wanted to let me know in a matter of fact tone what had happened, that he was going to be away for a while, and could I look after his dogs while he was gone?

Of course I can look after the dogs. We’ll probably bring the five of them over and keep them in the backyard with our two. The weather is just cooling down enough that that should work out well. Since he’s going to be gone for a while and I don’t know how long, and since I’ve been playing soccer with shoes that don’t fit and he has a pair that do fit me (but not him), I asked him if I could borrow the shoes before he left. I’m such an asshole.

I don’t know how to deal with these things.

I apologized for asking but Marc is probably the one person with less of a sense of propriety than me and he didn’t understand how being asked for soccer shoes five minutes after telling me his dad had died was in any way odd. He’s a good guy.

We went over to his house for the shoes and I talked with him for a bit while he was packing. He couldn’t figure out what to take. He was having a hard time thinking clearly. I tried to talk to his wife but she seemed to be taking things worse than him. She’s six months pregnant, due in December. That has nothing to do with anything and I don’t know why I’m bringing it up. Maybe it’s the whole cycle of life thing. As one passes another comes to pass. By Christmas everything will be better again, except that their baby won’t get the chance to know its grandfather.

My dad died when I was ten. The funeral was in Iowa and we lived in Texas. My mom and brothers flew up for it but I didn’t. It was my choice and I was scared. About ten years ago a friend’s father died and I took her to the wake. It was open casket. That was the only time I’ve ever seen a dead person before. I couldn’t then, and I can’t now, grasp the concept that the lifeless body that was before me was once a walking, talking, breathing person capable of thought and ideas. I kept waiting for him to open his eyes. April Fools! Of course that didn’t happen.

I’m 32 years old. My brothers are ten and eleven years older than me. My mom is in her sixties. My grandparents are all close to their nineties. Sooner or later people that I love are going to start dying and I still don’t know how to deal with these things.

Little Lethal Weapon 4 homage there.

If the title didn’t give it away: we’re pregnant! Technically, it’s just Karina, but I have a feeling I’m going to do some suffering alongside her. At least that’s what every other dad has been telling me. We’re 15 weeks in and the due date is March 14th. So if you were looking forward to seeing us at SXSW, we might have to disappoint you. We’re still buying our tickets just in case the baby is late!

Sometime in the near future I’ll get around to scanning in the ultrasounds that we have. We’re also going to to do the 3D ultrasound, which’ll be really cool. I think that’s in five weeks, which is also when we’ll find out if we’re having a boy or a girl. Come on boy! I’m terrified by the thought of raising a girl, mostly because I know what goes on in the minds of boys. I’m not nervous … yet. But when I start flipping through those baby books that Karina has been buying, I start getting anxious.

We’ll try to keep everybody posted here but it’s pretty obvious I’ve been pretty lax about posting lately. Look for a baby gift list, coming soon though!

I’ve been working on a largish website project and I’ve been falling steadily behind schedule. The reasons for the delays fall into two categories: data conversion and code conversion. Both turned out to be more complicated than I expected.

Data Conversion (Filemaker to MySQL)

Filemaker is a weird sort of database. Instead of tables you have “layouts” that show certain fields but all fields exist in the same bucket. The database is the table. In this case the Filemaker database had hundreds of fields in it that were spread across 16 layouts and all of it needed to be converted to MySQL. Unfortunately this was not an a => b scenario for several reasons:

- A lot of calculations and data manipulation are taking place in Filemaker
- The LDML code made extensive use of lists built into Filemaker
- A lot of data had to be translated
- Certain restrictions were placed on the MySQL databases (see below)

The data conversion is part of the larger conversion from Filemaker/LDML to MySQL/PHP. On the PHP side the client already has a database structure and code built out for several of the portions of the site being converted. In those cases some data has to be split across multiple tables, so data has to be converted to new formats, and various other tweaks had to be performed.

This is a longer term project (four months). Because the data conversion will have to be done several times, I chose to write a script to handle it. Again, because it will have to be run over and over again, it first starts by emptying the existing tables and resetting all of the auto_increment counters to 1. When the site has been fully converted and is ready to relaunch, we’ll be able to run the script again and at the push of a button grab the most recent data from the previous site. Whenever data turns out to need more “massaging” during the code translation process (i.e. something turns out to be wrong) I can make the changes and re-run the script without having to perform a lot of manual labor.

I’ll outline the conversion script another day — it’s about 800 lines of code. It took about a week to write and get right and since this project is ongoing it will almost certainly require more tweaks as the project moves forward. That’s a lot more than the one day I had estimated for the conversion.

Code Conversion

Once I had the data poured into 19 MySQL tables I could start setting up the website. First thing was converting the new layout into XHTML and CSS. No problemo. The second step was to setup the new navigation structure. A little bit more work and planning here but again, no problemo. The third step was to create pages for all of the static content. This was the easiest step in the process. The fourth step was, and is, where I get my hands dirty and start mucking around with the site code.

Now, it seemed easiest to start with the pre-existing PHP modules from the client and get those up and running. Unfortunately, this is where I ran headfirst into one of my own great shortcomings. I have a hard enough time reading my own well-formatted and well-documented code. In this case I’m reading someone else’s code with functions and classes that are spread across 25 different files. Everything is being generated or manipulated by something else. Coming into this from the outside it’s very hard to figure out what is going on. For me this has led to a lot of confusion, a lot of delays, and a lot of sleepless nights.

Finally, this weekend I decided that something had to give. I was trying to take the short route and fumble through things. Define a task, tackle it, and when it doesn’t work try to trace the code back through the various files to find out why. Fix, try again, run into another problem, trace it back through, etc.

For most people this would actually work. They can just learn from doing something hands on. For me that doesn’t work. I have to first read a manual, then get hands on and refer back to the manual as I’m going along. It’s not enough for me to know how something works, I have to understand why it works.

I determined that I needed to write a manual. In doing so I would develop a deep understanding of how everything in the various files worked.

Yesterday I spent the day printing out most of a ream (500 pages) of code. I got a binder and a bunch of tabbed inserts. I created tabs for each document, hole punched everything and assembled my book. Then I started the two day process of reading the book. For each file I created an outline of each class and function. I also outlined the structure for each include. This is my table of contents and is in the front of the book.

Now I have a much greater understanding of what is going on because I’ve read through everything once. I also now have a quick reference to any section of code without having to open five different files to track function calls. At a glance I can see what is going on and if I’m passing data to a function in the correct format or using a function in the correct way. This took two days and it could have saved me weeks of sleepless nights.

Planning and organization are incredibly important when working on projects. It may seem like wasted time but in the end it saves more time than it consumes.

gen•tri•fi•ca•tion n. – The restoration and upgrading of deteriorated urban property by middle-class or affluent people, often resulting in displacement of lower-income people.

This process has started happening just east of IH35 in downtown Austin. My wife doesn’t want to move there because she thinks it’s horrible. I desperately want to move there because the new developments going up are mostly mixed-use with condos upstairs and office space downstairs. They are also being largely occupied by artists and other creative industry people.

The lower income people, some of whom have lived there for years, are being displaced. The property values are going up and they can’t afford the rents or taxes that go with the increased property value. Some of them really don’t want to go.

I don’t want to be insensitive but we don’t always get what we want. I read an article the other day about a “distressed” neighborhood downtown. The residents were afraid to come out of their houses, there were needles lying in the street, and the area had an incredibly high crime rate. This is what happens in “distressed” neighborhoods and it affects the surrounding neighborhoods as well.

So it is inevitable that, when population density reaches a certain point, areas only a few blocks from the heart of a city will become prime real estate for a variety of reasons, not the least of which is location. The opportunity to reduce the crime rate, increase tax revenue, and create more usable public spaces are all strong reasons too.

The people who are renting in these neighborhoods will almost certainly have to move further away from the center of the city and lose out. People who own residences in these neighborhoods stand to gain quite a bit. In many cases they will be able to sell their property at a price that will let them move to a much better neighborhood with less crime and less fear. It seems to me the old owners win, the new owners win, and the city wins.

Maybe I’m just niave. Or maybe I really want to move downtown and I can’t afford anything West of IH35. But with every article I read about “distressed” neighborhoods, I feel more confident that gentrification is simply more good than it is bad.

June was “vacation month” for us. We went back to the Bahamas to visit friends and to take some friends with us. The trip was a mixed bag for us: we got to see friends, the beach, and go boating and I got to play poker but we once again didn’t make it to any of the family islands, we only spent a few hours at the beach, and Karina never got her massage — which I now owe her.

When we got back my brother Keith and his wife Cindy visited. It was the first time my wife has met them, which was nice.

After that we had a week to catch up on work before heading down to Brownsville and South Padre Island for Karina’s 10 year high school reunion. That meant I had to spend some time working on the reunion website and then be a human accessory (like a handbag!) to all of the events. It was actually more fun than I thought it would be going in. She has some cool classmates. Going into it I just remembered my own high school experience and I was not looking forward to something like that.

Now we’re home and still trying to catch up on work. I guess what I’m trying to say is: I haven’t had time, ability, access to post much for the last month. There have been lots of things I’ve wanted to talk about or mention though and I’m constantly coming across cool things both online and offline. Maybe I’ll share some soon…

From a post titled “Rush’s Law“:

Rush should be urged to share his story with America. Here’s he is, an impotent, thrice divorced, ex-drug addict, conservative, parolee who went on a sex tour in the Caribbean and found himself rudely embarrassed for carrying recreational prescription drugs in his doctor’s name. Who can’t relate to that?

I’ll admit it: I’m a TV addict. My favorite shows, in no particular order, include Lost, Invasion, The Daily Show, Numbers, Prison Break, and Two and a Half Men.

Last night was the thought-provoking season end to the dark and creepy Invasion. Families were torn apart and Sheriff Underlay had to make a life and death decision about Russell’s pregnant wife. His inability to answer Russell, or even speak, at the end of the episode was a powerful moment. And a perfect setup for the beginning of next season.

Today I find out that there is no next season. That ABC plans to cancel the show. I’ve never signed a fan petition before (they mostly get circulated for anything produced by Joss Whedon) but I signed this one:

http://www.petitiononline.com/33030/petition.html

I also sent a comment directly to ABC:

http://abc.go.com/site/contactus.html

Help me be entertained. Sign the petition and write a quick note. It only takes a minute.

I don’t post much these days because I stopped posting about politics. Posting about design and development means taking time to explore new things, which means you have to have time to explore new things. In the meantime, a brief return to the days of old…

The Anti-Idiotarian Rottweiler has a post up that exemplifies everything that is wrong with the right wing of the Republican party. I’m not going to gloat or rant. I am going to excerpt a few choice bits and recommend you go read it for yourself. If you are a Republican, ask yourself if this is the party you want to be associated with.

From the Post: The Turd World Shithole Known as Mexico Whines:

…the pendejos from Drug and Whoresville are bitching and moaning…

Well, Pancho Villa, you could avoid all of that if you’d actually be the great “friendâ€? that Vicente’s bathhouse gay friend Jorge always claims that you are…

(Jorge refers to George Bush here. Pancho Villa refers to Vincente Fox, President of Mexico.)

Nuke Mexico

And, lest you think the people reading this crap are any less psychotic:

Don’t worry Verminte you pitiful shitstain, Bushito will be back on all fours licking your boots in no time. I highly doubt Bushito has found some self-respect and loyalty to Americans over Mexicans. I hope he proves me wrong and tells you to go fuck yourself. In the meantime here’s a message from Los Angeles with love: GO FUCK YOURSELF!

We have to be very careful after nuking Mexico, Mein Imperator! Burritos stay hot for a LONG time.

We could use their cadavers as an energy source for heating homes in the southwest for years to come.

Yeah…but they’re so pretty when they glow in the dark.

I like Stephen Colbert but I have to admit that I prefer his mentor, Jon Stewart. After the White House Press Correspondent’s Dinner though, I have newfound respect for the man. My jaw dropped watching his ballsy, spot-on performance at the dinner:

Update: I realized after posting this that it doesn’t contain the full video (and it has an annoyingly long introduction). To see the full thing check out Salon’s Video Dog. They also posted his press secretary audition skit.

More Firefox commercials here.