We love sequences

Or maybe not.

Let me quote Moshe from  
http://lists.drupal.org/pipermail/develop
ment/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://dr
upal.org/node/49836#comment-251682 now contains such a
patch.

Regards,

NK

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/develop
ment/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://dr
upal.org/node/49836#comment-251682 now contains such a
patch.
> 
> Regards,
> 
> NK