3 ms·
why a separate id and rowid? why not just rowid and data?
by nextaccountic 2y ago
why a separate id and rowid? why not just rowid and data?
- 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...