An argument against defaulting to auto-increment primary keys

Shannon Griswold Articles, Databases, Java 11 Comments

Attention: This article was published over 12 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.The de-facto “easy” primary key for ages has been the auto-incrementing integer. Upon insertion of a new record, the database simply increments a counter …