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.

You can leave a response, or trackback from your own site.

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!

You can leave a response, or trackback from your own site.

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.

You can leave a response, or trackback from your own site.