Re:"We ran out of columns" – The best, worst codebase
by nextaccountic on Saturday August 03, 2024 @03:15PM
(#41148586)
why a separate id and rowid? why not just rowid and data?
[ Parent
| on HN ]
Re:"We ran out of columns" – The best, worst codebase
by sebastiennight on Sunday August 04, 2024 @08:10AM
(#41153008)
"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à.
Re:"We ran out of columns" – The best, worst codebase
by nextaccountic on Sunday August 04, 2024 @02:39PM
(#41155427)
It's the same thing actually
https://stackoverflow.com/questions/41928749/pros-cons-of-re...