3 ms·
Isn't the solution just to use the rowid (after doing the read-id-after-insert dance)? How much trouble does SQLite reysing rowid's actually cause?
by w10-1 4mo ago
Isn't the solution just to use the rowid (after doing the read-id-after-insert dance)?
How much trouble does SQLite reysing rowid's actually cause?
- andersmurphy 4mo agoYou 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.