Category Archives: MySQL

Airlines and Bug Responsiveness

While developing FlightStats, I ran accross several bugs in the data I got from the Bureau of Transportation Systems. I reported the data to them, and got a quick response back (two weeks) that they had confirmed the bugs and asked the airlines to correct their reporting.

Did they? Yes! (Well, mostly. Grr, Southwest.)

Airline: Southwest
Initial Report: February 6, 2004
Reply: February 18, 2004
Problems Fixed: 30% in March, 2004 data set.

Airline: US Airways
Initial Report: February 6, 2004
Reply: February 18, 2004
Problems Fixed: 100% in February, 2004 data set.

Airline: American Eagle
Initial Report: July 21, 2004
Reply: None?
Problems Fixed: 100% in July, 2004 data set.

Average Aircraft Age by Airline

I’ve been doing some reporting on FlightStats, and produced an interesting report: What is the average age of the aircraft in active use by each airline?

Update: Due to bugs in data that Southwest is reporting, their average numbers are way off. I’ll get back on them.

+---------------------+---------+-------------------------+
| nickname            | avg_age | graph                   |
+---------------------+---------+-------------------------+
| Jetblue             |  3.2736 | ###                     |
| Hawaiian            |  3.9361 | ###                     |
| American Eagle      |  4.2526 | ####                    |
| ATA                 |  4.2690 | ####                    |
| Atlantic Coast      |  4.4526 | ####                    |
| Continental Express |  4.5238 | ####                    |
| Airtran             |  4.6742 | ####                    |
| Atlantic Southeast  |  5.2899 | #####                   |
| Comair              |  6.4736 | ######                  |
| Sky West            |  6.6019 | ######                  |
| Continental         |  9.2111 | #########               |
| Alaska              | 10.3416 | ##########              |
| United              | 11.2737 | ###########             |
| America West        | 12.2283 | ############            |
| USAir               | 13.3484 | #############           |
| Delta               | 13.9013 | #############           |
| American            | 18.3311 | ##################      |
| Northwest           | 20.6489 | ####################    |
| Southwest           | 23.6350 | ####################### |
+---------------------+---------+-------------------------+

Continue reading →

Yahoo!

In case you haven’t heard…

I am no longer with MySQL, and will be starting my new job as a MySQL Guru at Yahoo! on December 6th. If you want the details about why or how or when, feel free to ask me! (My email is jeremy [at] jcole [dot] us.)

Wish me luck!

Update: See what Jeremy Zawodny has to say about it: Jeremy Cole will be Yahooing Soon too!

Update: Mike Hillyer chimes in: Jeremy Cole is a Yahoo!

JeremyZ’s Favorite Database?

This is kind of old news, but I wanted to put it in my blog anyway, as perhaps some of you haven’t seen it, and so I won’t lose it. :)

On June 15, 2004, LinuxWorld interviewed Jeremy Zawodny and Derek Balling regarding their new book, High Performance MySQL. They asked the following question:

LinuxWorld: You must have experienced lots of different databases of information over the years – what was your favorite use for a database system?

Jeremy Zawodny: That’s a tough one. I (Jeremy) really like the aviation database that Jeremy Cole (MySQL AB’s training manager) has been building. He’s combined freely available information from the FAA and NTSB with MySQL and a simple Web interface in a way that brings together previously separate and hard-to-find information. If you want to know which airports or airlines experience the most delays, it’ll tell you. If you want to know what types of planes American Eagle flies, it’ll tell you.

He is of course referring to my project, FlightStats.