SQLite AUTOINCREMENT: The Feature You Probably Don’t Need (But Sometimes Do)

Most developers assume that AUTOINCREMENT is the safe, default choice when creating IDs.