[development] We love sequences

[Sammy Spets]

Bring it on!

-- 
Sammy Spets
Synerger Pty Ltd
http://synerger.com

On 30-May-07 02:43, Karoly Negyesi wrote:
> 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