How to change rowid of all other records in SQlite3 database after deleting one record?

Question

SQLite

I have a lot of records in the database, sometimes I delete one of them and all other records do not change their rowid.
Question: How, after deleting a record, to update the rowid of all the others so that they go in order?
I'm using the latest version of the Python programming language, and the SQlite3 database.

Answer 1

It's not entirely clear why you would want to do this. PRIMARY KEY can not be changed like this, out of the blue, this is bad practice.
It is better to create a separate variable for this, some kind of record_id, but here the performance issue already arises - after each deletion, it is not very good to rewrite the entire table.
In short, the answer is: the problem does not have a correct solution, fix the application architecture.