[development] We love sequences
karoly at negyesi.net
Wed May 30 00:43:24 UTC 2007
Or maybe not.
Let me quote Moshe from
"A long time ago, we made a big effort to be database independent and
introducing our own sequences feature was part of that. We wanted to
welcome all RDMS, even those without sequences."
mysql -- native (auto_increment modifier)
SQLite -- native (auto_increment modifier)
postgresql -- native (serial type backed by sequences)
Oracle -- doable (via sequences and a trigger)
MSQQL -- native (identity type)
DB2 -- doable (DEFAULT NEXT_VALUE OF sequence)
Firebird -- doable (generator, trigger)
MS Access -- native (autoincrement type)
Surely I have not covered all possible RDBMSes and the above might contain
errors, I just spent ten minutes with googling this together.
But still. It seems that most RDBMSes that we considered supporting
To continue quoting Moshe,
"I'd support a patch that removed drupal sequences in favor of built in
auto-increment and such."
Let's hope he is not alone because
http://drupal.org/node/49836#comment-251682 now contains such a patch.
More information about the development