[development] Why do we avoid auto-incrementing db columns?

Ezra B. Gildesgame ezra at pingv.com
Wed Apr 25 14:29:54 UTC 2007


I happened to discuss this with Greg Knaddison yesterday.
MySQL 4 does not support auto-incrementing columns. I believe  
Drupal.org uses MySQL 4, and one reason it has not been upgraded  
could be to avoid complications caused by changes in the way  
information, particularly international characters, are stored  
between 4 and and later versions.

Ezra Gildesgame

1350 Pine Street, Suite 1
Boulder, CO 80302-4847

On Apr 25, 2007, at 8:15 AM, Barry Jaspan wrote:

> Could someone either clue me in or point to a prior discussion about
> why Drupal avoids using auto-incrementing database columns?  If it is
> database compatibility, which versions of which databases that we
> support do not have it?
> Thanks,
> Barry

More information about the development mailing list