[development] We love sequences

[Karoly Negyesi]

Or maybe not.

Let me quote Moshe from  
http://lists.drupal.org/pipermail/development/2005-December/012108.html

"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."

Let's see

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  
support these.

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.

Regards,

NK