3 ms·
>to fix it they have to migrate the entire database to use a different type for bookmark IDs... except of course this will take a while because there are two Bi
by charcircuit 1y ago
>to fix it they have to migrate the entire database to use a different type for bookmark IDs... except of course this will take a while because there are two Billion Of Them Lol
You can shard them between 2 tables. Then migrate them to a single one later.
- ohdeargodno 1y agoThere's no SLA for Harry Styles porn. Run the migration, lock the table for two days and redo the same in 13 years when you get to 4 billion bookmarks.
- kijin 1y agoIn 13 years, the Unix timestamp will probably be a much bigger problem.
- camel-cdr 1y ago> There's no SLA for Harry Styles porn But what about my good night's sleep? How can I go to bed without reading about my favorite blorbos?
- ohdeargodno 1y agoReal ones use bookmarks to find them ag- ah, shit. Real ones back them up in a single .txt file
- rsynnott 1y agoI mean I’d assume they went for a 64bit integer. In a few million years, people who are into weird porn about whatever the temporally local equivalent of Harry Styles is (probably some sort of robot) will once again be mildly inconvenienced.