4 ms·
"The rowid is implicit and autoassigned, but we want developer-friendly IDs." maybe But of course, the obvious solution is to have one table with just ROWID an
by sebastiennight 2y ago
"The rowid is implicit and autoassigned, but we want developer-friendly IDs." maybe
But of course, the obvious solution is to have one table with just ROWID and data, and another table with the friendly IDs! If you time the insertions really well, then the ROWIDs in both tables with match and voilà.
- nextaccountic 2y agoIt's the same thing actually https://stackoverflow.com/questions/41928749/pros-cons-of-relying-on-rowid-instead-of-id-primary-key-sqlite https://stackoverflow.com/questions/41928749/pros-cons-of-re...