SQLite Forum

The opposite of AUTOINCREMENT
Login
An alternative idea is to create a table to hold freed ID values and use a delete trigger to add to that table.  Then you can "pop" the values from there with little overhead.