From
the SQLite docs:
sqlite.org wrote: If the largest ROWID is equal to the largest possible integer (9223372036854775807) then the database engine starts picking positive candidate ROWIDs at random until it finds one that is not previously used. If no unused ROWID can be found after a reasonable number of attempts, the insert operation fails with an SQLITE_FULL error.
But based on my math and assuming that 10,000 rows are added every second (higher than Indigo Server could handle), then it wouldn't hit the maximum for 29.2 million years. So even if it didn't try to find unused positive candidates I wouldn't worry about it.