in reply to Re: Generating portable SQL primary key sequences
in thread Generating portable SQL primary key sequences

DBIx::MySQLSequence

A safe, transaction safe sequence emulation for MySQL. The docs explain some reasons you might want to allocate the object ID first, rather than afterwards.

Extracted out of a commercial app I wrote once.

I really need to write the equivalent for some other non-sequence-friendly database one of these days.
  • Comment on Re: Re: Generating portable SQL primary key sequences