TheStrike – Day 1

TheBus drivers went on strike at 12:04 AM this morning, only three minutes after the threatened deadline.

Union leader Mel Kahele was quoted by the Star-Bulletin as saying, “I believe it is ludicrous for the company to believe that we are going to be in agreement with all the takebacks they are going to have on the bargaining table without even considering requesting for additional monies from the city and again from the City Council.” Kahele also promised that the union was “ready to go three months.”

OTS attorney Perry Confalone was similarly dismayed. He said that the Teamsters refused to give the company a written proposal until an hour or so before the 12:01 AM deadline.

Picket lines have been set up at TheBus’ Middle Street facility. The union also intends to march in front of Honolulu Hale – city hall.

At 5:30 this morning, many people already had contingency plans. Few people were at the city’s designated “‘Ohana Carpool” locations.

At the University of Hawai’i’s Share-a-Ride web site, only 14 rides were offered, and the response was equally small. UH Manoa has opened 1,900 additional parking spaces. All will be subject to the usual $3 fee. Community college campuses have adopted similar measures.

6 Hours to Go

There’s exactly six hours until the 12:01 AM strike deadline. (Ignore the timestamp – my web server’s clock is off.)

The Teamsters resumed negotiations today at 2:30 PM, but a resolution is doubtful. According to leader Mel Kahele, “We actually don’t believe we’re going to be able to settle unless the company decides on withdrawing their so-called 38 takebacks.” (Star-Bulletin, no permalink available.)

Bus fare increases advanced through City Council. A final vote won’t be until September 25th. (Advertiser, no permalinks.)

Late Buses Cancelled, Fare Talks Continue

Teamsters Union and OTS negotiators are scheduled to resume talks today, and will probably continue late into the night. Many people will not know the outcome until the morning news tomorrow.

In preparation for tomorrow’s threatened bus strike, urban buses that begin operation after 11 PM, and rural buses that begin after 10 PM, have been cancelled for tonight.

At Honolulu Hale, one of the current proposals is dropping monthly and yearly bus passes, and instead charging all riders a 75 cent fare (Honolulu Advertiser, August 25th, 2003). This is a dollar less than current pay-as-you-go fares for adults, but the current discount from bus passes means daily commuters would be paying approximately $7.50 more per month for the same level of service – with no promises that the daily rate will stay the same. (That figure also doesn’t account for the proposed transfer fees.)

More news will be posted as it becomes available.

Back to Class

School’s starting tomorrow, and I’m finding myself feeling scatterbrained. Summertime makes it really easy to relax, since I don’t have to worry as much about unyielding deadlines and being constantly judged by professors. Going back to the structure of it is challenging, and it’s going to take a few days to adjust.

I’m sure that the uncertainty of my travel plans on Tuesday is not helping with the stress I’m feeling.

Wish me luck.

Tips for Designing Databases

If you’re a developer for a small to mid-sized web application, one of the very first questions you’ll be faced with is, “How should the database be structured?”

If you’re new to the world of relational databases, understanding structures can be very complicated. The first thing you need to do is understand that in general, more tables are better than less. If you’re doing a member directory, for example, you may find yourself putting name, addresses, phone numbers, etc. into one table. Resist the urge! It’s very easy to pull information from multiple tables into a single SQL query, and you’ll be thankful later when you have the flexibility to add information you didn’t think you needed.

On the subject of flexibility, try to anticipate the future needs of your application. You may want to sit down with the people that will use your application, and ask them to tell you everything they might need to do with the information. Have them walk you through their work (or volunteer) day, so you can see where inefficiencies can be improved by your application. Ask them what the company/organization’s future goals are. Take lots of notes – the more, the better.

Oh, and one more thing. Don’t ever, ever duplicate data. You’ll get headaches down the road. Trust me. Crying smiley