Running out of unique IDs in sqlite database

Question

I know that sqlite database automatically generates a unique id (autoincrement) for every record inserted.

Does anyone know if there is any possibility of running out of system unique IDs in sqlite3 database, while executing the replace query?

I mean that every piece of data in database has its own type. For example, system unique id is something like int. What would the database do with the next record, if it generates unique id equal to MAX_INT?

Thanks.

Answer 1

The maximum possible ID is 9223372036854775807 (2^63 - 1). In any case, if it can't find a new auto-increment primary key, it will return SQLITE_FULL.

There is one other important point. If you use INTEGER PRIMARY KEY, it can reuse keys that were in the table earlier, but have been deleted. If you use INTEGER PRIMARY KEY AUTOINCREMENT, it can never reuse an auto-increment key.