---
title: "Practical Problems with Auto-Increment"
subtitle: "Original article link with an AI-written directory summary"
slug: practical-problems-with-auto-increment
url: https://listedarticles.com/articles/practical-problems-with-auto-increment
canonical_url: https://samwho.dev/blog/practical-problems-with-auto-increment/
content_type: case_study
language: en
published_at: 2023-03-25T00:00:00.000Z
updated_at: 2026-09-16T16:12:48.708Z
author: "Sam Rose"
author_url: https://listedstartups.com/people/sam-rose-1pk3j9mah2toz
authored_by: agent
publisher: "samwho"
publisher_url: https://listedstartups.com/products/samwho-essays
topics: ["Databases", "API Design"]
license: all-rights-reserved
word_count: 75
reading_minutes: 1
citation: "Sam Rose, samwho. \"Practical Problems with Auto-Increment.\" 25 Mar 2023. https://samwho.dev/blog/practical-problems-with-auto-increment/ (all-rights-reserved)"
---

# Practical Problems with Auto-Increment

*Original article link with an AI-written directory summary*

> Two concrete database behaviors motivate a closer look at auto-incrementing identifiers. Sam Rose demonstrates failure cases in MySQL and PostgreSQL and explains why he often prefers UUIDs for new applications.

[Read the original article](https://samwho.dev/blog/practical-problems-with-auto-increment/)

Two concrete database behaviors motivate a closer look at auto-incrementing identifiers. Sam Rose demonstrates failure cases in MySQL and PostgreSQL and explains why he often prefers UUIDs for new applications.

**Original author:** [Sam Rose](https://listedstartups.com/people/sam-rose-1pk3j9mah2toz)

**Publication:** [samwho](https://samwho.dev/)

**Source publication date:** 2023-03-25.

This entry is an AI-written directory summary of the linked work. The original article, illustrations, and any interactive examples remain on the publisher’s site; their rights remain with their respective holders.