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 TweedHeads on Tuesday June 09, 2009 @11:00AM
(#649189)
Nothing the fail whale can't fix ;-)
There, fixed, send check for $20 to [email protected]
Call me back when they reach 18446744073709551615