The Vancouver PHP User Group has kindly offered to be a guinea pig for my session on copyright, contracts and licenses for software developers. I appreciate the opportunity to refine the presentation, as it will be a bear to get right - first, I have to sure that the audience clearly understands that I am not providing legal advice; second, the topics are complex and difficult to explain concisely.

The session is particularly important to get right, as I may be (or am, in a few cases) presenting variants of the session at these events:

• Orbital Lunch and Learn (private event) (confirmed)
• Open Source CMS and Blog Tool Summit (confirmed) …

A while ago someone asked on the forums for the Archive engine to support autoincrements. I finally got around to doing this last night.

Yes it can support both unique and non-unique indexes on the autoincrement. Though you will pay in performance if you insert say "5" and then insert "4" on a unique index since it has to do a manual scan. Otherwise its fine and zippy.

Thus far it doesn't look to have any issues but I am sure I will find at least one :)

Pushed into 5.1, which should go beta fairly soon.

And for your example:

CREATE TABLE `t5` (
`a` int(11) NOT NULL auto_increment,
b char(12),
PRIMARY KEY (`a`)
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, …

A while ago someone asked on the forums for the Archive engine to support autoincrements. I finally got around to doing this last night.

Yes it can support both unique and non-unique indexes on the autoincrement. Though you will pay in performance if you insert say "5" and then insert "4" on a unique index since it has to do a manual scan. Otherwise its fine and zippy.

Thus far it doesn't look to have any issues but I am sure I will find at least one :)

Pushed into 5.1, which should go beta fairly soon.

And for your example:

CREATE TABLE `t5` (
`a` int(11) NOT NULL auto_increment,
b char(12),
PRIMARY KEY (`a`)
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, …

First off, thanks to all of you who wished me good luck yesterday! That was really nice to feel welcomed ... and it really means a lot to me. Thanks!

Secondly, I will be in Miami, FL, tomorrow, Wednesday the 11th through Saturday the 14th attending a MySQL Sales conference. I'm keen to meet many in the Sales team and inquire how the Community team can best assist them in their endeavours, as well as let them know about some of the things going in the community. However, I'd love to meet any of you out there who enjoy using MySQL or products which run on MySQL. Kind of an impromptu meetup, I suppose, but I wanted to take advantage of being in Miami to meet some local like-minded South Floridians.

So, if you're up for a meetup, post a comment and I will get in touch!

p.s. As a side note, I'm finishing off my Many-to-Many article part 2 this week, so stay tuned. Sorry for the delay; things have been a bit crazy as of late …

According to the latest Fortune magazine's list of top 100 companies to work for, Genentech is the top company to work for with 50% women in their workforce. Other notable mentions include Cisco (25), Yahoo! (73), Intel (97), Intuit (43), Microsoft (42), QucikTrip (21) and Starbucks (29). Surprisingly (and rightfully so) Google is NOT in the list (Hurray!).

Just yesterday I blogged about that I am willing to work for any company so long its not Google and today these ratings make me feel part of the community.

American Express Project manager for technology also gets almost $100K a year on average.

Neither …

Ooooh... a dns system that gets its info from a database. Now all I need is a DHCP daemon that will talk to the same database. Then my domain name system will be as cool as Active Directory :)

http://wiki.powerdns.com/projects/trac/

Ooooh... a dns system that gets its info from a database. Now all I need is a DHCP daemon that will talk to the same database. Then my domain name system will be as cool as Active Directory :)

http://wiki.powerdns.com/projects/trac/

It always surprises me how knee-jerk we can be in the open source world. If someone writes a glowing report of Project X, we slobber all over ourselves to salute them, however inaccurate they might be. If someone indicates a need for improvement, we slam them.

My recent post on OpenOffice is a case in point. I just don't think it's very good, and I also don't think it matters that it's not very good (because my goal in life is not to beat Microsoft at its game, but rather to make Microsoft play on my turf. Here are a few reasons OpenOffice is weak, and is not likely to ever attain Apache/Linux/BIND/etc. status.

• OpenOffice isn't a piece of software that most developers care about, and developer-aligned open source software is much more likely to be superior software. If there's no itch to be …

Horay, Jay Pipes is our new Community person specifically focusing on North America (like Lenz Grimmer for Europe).
In addition, it's hoped Jay will provide me with some sanity around the users conference ;-), assisting with the preparations and also later on-side so we'll both have more time to meet and talk with people.

You've probably already seen Jay active with his blog, and/or on the MySQL forums...
Welcome Jay!

Horay, Jay Pipes is our new Community person specifically focusing on North America (like Lenz Grimmer for Europe).
In addition, it's hoped Jay will provide me with some sanity around the users conference ;-), assisting with the preparations and also later on-side so we'll both have more time to meet and talk with people.

You've probably already seen Jay active with his blog, and/or on the MySQL forums...
Welcome Jay!