SQLite Forum

Best way to handle unique column needs
Skip the "autoincrement" unless you actually need it.  You probably don't.  99.9999999999999% of the time autoincrement is used when it is not required because "it sounds nice" and not because it fulfills any useful purpose (other than consuming CPU and I/O for no useful purpose).

Avoid that trap.  Do not use autoincrement unless you need it, and you probably don't.