When 2,147,483,647 just isn't enough.

August 12, 2009 Pivotal Labs

If only I had a paid a little more attention to any of the Facebook is growing more quickly than the Universe is expanding articles of late, I might have caught a bug in my app before I received multiple one star ratings.

That said, live and learn and be sure to create the uid column in your users table as a bigint.

t.integer :uid, :limit => 8

I will never know how many countless Facebookers with excessively large uids tried to play my game in vain, only to watch as MySQL mercilessly truncated their unique identifier to the eighth Mersenne prime.

About the Author

Biography

More Content by Pivotal Labs
Previous
Rails requests missing the HTTP body
Rails requests missing the HTTP body

This is a bug in Rails that quite likely affects you, but which you've even more likely never experienced. ...

Next
Boosting with Acts As Solr
Boosting with Acts As Solr

Probably my favorite feature of the Solr full text search engine and the acts_as_solr plugin is a feature c...

Enter curious. Exit smarter.

Learn More