You don't even need to that. SQLite auto increments the ids and is a single writer (which you should be coordinating at the application level. Regular rowids a

You don't even need to that. SQLite auto increments the ids and is a single writer (which you should be coordinating at the application level. Regular rowids are definitely the way to go if you can use them.