Blech, looks like MySQL neither has a uniqueidentifier property nor sequences (AUTO_INCREMENT doesn’t work for shared IDs). This is pretty trivial to handle in PostgreSQL. Hmm, perhaps could be added via a UDF but this seems like a pain. Uggh, must be written in C. Que Lame-o.

(another option is using ‘uuidgen -t’, but there are a few negatives: 1) forking for each uuidgen, and at least the bigger problem for me 2) the uuid generated is a 8-4-4-4-8 hexadecimal string that’s frankly overkill (must be stored as a char, too large to store in INT4 – could be worked with, but well…)

stonefishspine with an points out the soldiers’ oath is to the Constitution…

In fact, within the framework of the Constitution, we govern ourselves, and our citizen soldiers vow to support the Constitution even before they agree to follow the orders of the President or their officers. This hierarchy is important because, if officers or presidents prove to be domestic enemies of the Constitution, soldiers are no longer obligated to serve them. They are, rather, sworn to defend the Constitution against them.

(Highly recommended read)

If you’re Sidekick gets zebra/bar-code stripe:

  1. Soft reset your device by pressing the following keys: @+1+0.
  2. As your device reboots, press and hold the green POWER button and the ‘P’ key. Release these buttons after the device shuts down.
  3. Finally, insert the AC power adaptor to restart your device.

The timing is a bit tricky since you can’t see anything. I finally got it to work when I held down the power button and the p key after the screen flashes, a little bit after letting go of the soft reset combo.

Brick to slick – a series of articles looking at the 30th anniversery of the cell phone.

“(AT&T) thought they should control all communications,” Galvin said. “They were going to take over the two-way radio business. This became evident to me. I think that one of the things that I did bring to the company was backbone. I said: ‘We can’t let them take over our business. There has to be competition. That’s better than a monopoly.’ They had a monopoly, but we had experience to back us up. And we beat them.”