SQLite Forum

about "strict" mode
Login
> RowIds are not stable if the are generated by the DB.

What?  Of course they are.  It sounds to me like you are talking about a user error in allocation of the pseudo-key range amongst non-contiguous databases.  (Meaning that you have the same database being created/updated in two (or more) places and you have not adequately managed the keyspace.)

This is a long solved problem (since at least 1940).

Although other methods have existed since the 1940's, you could use the "Microsoft Method" and simply assign a subrange to each instance.