News for hackers. Stuff that matters.
Re:Twitter's UID associated to each tweet will very soon exc... by TweedHeads on Tuesday June 09, 2009 @08:37AM (#648940)
ALTER TABLE twits MODIFY COLUMN twitid BIGINT UNSIGNED NOT NULL

There, fixed, send check for $20 to [email protected]

Call me back when they reach 18446744073709551615

Re:Twitter's UID associated to each tweet will very soon exc... by sanj on Tuesday June 09, 2009 @10:16AM (#649102)
Assuming that Rails is still interacting with the DB, and the ID in question is the primary key (ie, the 'id' on the 'twits' table) isn't quite that easy.

I had to do this a couple of years back when I realized I had a table that'd grow quickly:

http://snippets.dzone.com/posts/show/4422

Feel free to send the donation to the same place.

Re:Twitter's UID associated to each tweet will very soon exc... by lpgauth on Tuesday June 09, 2009 @05:48PM (#650060)
Is there no easier way then this? Can't believe that wasn't integrated into rails...
Re:Twitter's UID associated to each tweet will very soon exc... by jhancock on Tuesday June 09, 2009 @09:47PM (#650383)
"Can't believe that wasn't integrated into rails..."

You just made my day. I haven't laughed so hard in ages ;)

Re:Twitter's UID associated to each tweet will very soon exc... by joezydeco on Tuesday June 09, 2009 @10:47AM (#649161)
Hmm, didn't fix my iPhone client. Try again!
Re:Twitter's UID associated to each tweet will very soon exc... by fleaflicker on Tuesday June 09, 2009 @10:24AM (#649118)
That command will take several hours to complete and write lock the table.
Re:Twitter's UID associated to each tweet will very soon exc... by Andys on Tuesday June 09, 2009 @09:31PM (#650368)
Unless you use PostgreSQL.

But then you would have had 64 bit ID by default anyway.

Re:Twitter's UID associated to each tweet will very soon exc... by jsonscripter on Tuesday June 09, 2009 @11:34AM (#649245)
Why can't you just redirect the writes to a new temporary table and join the original and temporary on reads? (I'm not a database admin)
Re:Twitter's UID associated to each tweet will very soon exc... by karanbhangui on Tuesday June 09, 2009 @01:28PM (#649445)
I'm actually interested in this answer as well. I know of a company using a proprietary db and now that their growth has literally exploded, they're stuck with it.
Re:Twitter's UID associated to each tweet will very soon exc... by jsonscripter on Tuesday June 09, 2009 @02:47PM (#649632)
I wonder what literally exploding growth looks like...
Re:Twitter's UID associated to each tweet will very soon exc... by blhack on Tuesday June 09, 2009 @03:11PM (#649706)
Re:Twitter's UID associated to each tweet will very soon exc... by TweedHeads on Tuesday June 09, 2009 @11:00AM (#649189)
Nothing the fail whale can't fix ;-)