News for hackers. Stuff that matters.
Re:GitHub's online schema migration for MySQL by manigandham on Thursday May 03, 2018 @02:15AM (#16983722)
Modern advice: always use 64 bit integer ids. If it's a small table, it won't matter. If it's a big table, you'll need them anyway.
Re:GitHub's online schema migration for MySQL by daigoba66 on Thursday May 03, 2018 @04:55AM (#16984370)
That’s not always the best advice.

Consider a table that you know will only have a few rows, but is referenced in one or more FK columns. If I use a 64bit integer when 32bit (or smaller!) is enough, I’m now using twice as much space for the FK column. If there are millions of rows, plus indexes, that can add up pretty fast.

Re:GitHub's online schema migration for MySQL by jschmitz28 on Thursday May 03, 2018 @02:23AM (#16983765)
Yeah, this was a case of somebody (definitely not me, I would never!) generating a table in Rails, before Rails used 64 bit IDs on primary keys by default, and no one noticed before the table got really large. It looks like newer versions of Rails are doing it by default now: http://www.mccartie.com/2016/12/05/rails-5.1.html