[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-15 Thread Martin Dufort

And you can check on the progress of that Status ID on: www.twitpocalypse.com
Unless Twitter decides to blacklist us) for sending too many requests
to the public timeline API...

So Twitter, if you do so, please send me an email martin [insert at]
wherecloud [dot] com so we can work something out :-)

Martin - www.wherecloud.com


On May 13, 9:07 pm, Craig Hockenberry craig.hockenbe...@gmail.com
wrote:
 Let me be the first to say THANK YOU for this advance notice. I found
 and fixed some bugs in our iPhone client today because of it — and I'm
 very happy to hear that we have some time to get the code approved in
 the App Store.

 We love to complain when the process goes awry, but it's also
 important to remember to give credit when it's well and truly due.
 Thanks again!

 -ch

 On May 13, 12:12 pm, Matt Sanford m...@twitter.com wrote:

  Quick update …

       While looking at the code that reminded me of this error I see it  
  had some bugs of its own. We seem to have a matter of weeks rather  
  than days before this change. Mobile developers and other who deride  
  our lack of early notice take heed … now is the time to go unsigned.

  Thanks;
    – Matt Sanford / @mzsanford
        Twitter Dev

  On May 13, 2009, at 10:49 AM, Cameron Kaiser wrote:

   I see that the product manager/APIs position is still on your  
   site... does
   that mean the position is still open?  Does teasing the API team  
   help as a
   qualification?

   It may get you an interview, but only so they can surreptitiously  
   get a
   photo and send it to the nice Italian men with the kneecappers.

   --
    
   personal:http://www.cameronkaiser.com/
    --
    Cameron Kaiser * Floodgap Systems *www.floodgap.com*ckai...@floodgap.com
   -- They told me I was gullible ... and I believed them.  
   ---


[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-15 Thread Patrick Burrows

Hilarious!



--
Patrick Burrows
http://Categorical.ly (the Best Twitter Client Possible)
@Categorically


-Original Message-
From: twitter-development-talk@googlegroups.com
[mailto:twitter-development-t...@googlegroups.com] On Behalf Of Martin
Dufort
Sent: Friday, May 15, 2009 10:08 AM
To: Twitter Development Talk
Subject: [twitter-dev] Re: Status ID closing in on maximum unsigned integer


And you can check on the progress of that Status ID on:
www.twitpocalypse.com
Unless Twitter decides to blacklist us) for sending too many requests
to the public timeline API...

So Twitter, if you do so, please send me an email martin [insert at]
wherecloud [dot] com so we can work something out :-)

Martin - www.wherecloud.com


On May 13, 9:07 pm, Craig Hockenberry craig.hockenbe...@gmail.com
wrote:
 Let me be the first to say THANK YOU for this advance notice. I found
 and fixed some bugs in our iPhone client today because of it — and I'm
 very happy to hear that we have some time to get the code approved in
 the App Store.

 We love to complain when the process goes awry, but it's also
 important to remember to give credit when it's well and truly due.
 Thanks again!

 -ch

 On May 13, 12:12 pm, Matt Sanford m...@twitter.com wrote:

  Quick update …

       While looking at the code that reminded me of this error I see it  
  had some bugs of its own. We seem to have a matter of weeks rather  
  than days before this change. Mobile developers and other who deride  
  our lack of early notice take heed … now is the time to go unsigned.

  Thanks;
    – Matt Sanford / @mzsanford
        Twitter Dev

  On May 13, 2009, at 10:49 AM, Cameron Kaiser wrote:

   I see that the product manager/APIs position is still on your  
   site... does
   that mean the position is still open?  Does teasing the API team  
   help as a
   qualification?

   It may get you an interview, but only so they can surreptitiously  
   get a
   photo and send it to the nice Italian men with the kneecappers.

   --
   
personal:http://www.cameronkaiser.com/
    --
    Cameron Kaiser * Floodgap Systems
*www.floodgap.com*ckai...@floodgap.com
   -- They told me I was gullible ... and I believed them.  
   ---



[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-15 Thread mwm

I'm using a bigint (20) with MySQL for TwitteReader so
18446744073709551615 available. Still many IDs to go ;)


[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Matt Sanford

Make that *signed* integer. Writing too many emails at once, sorry.

On May 13, 7:38 am, Matt Sanford m...@twitter.com wrote:
 Hi all,

     Just a quick heads up. Our status id is fast approaching the
 maximum unsigned integer value. Based on all of the feedback on
 scaling I've received from this list I'm assuming everyone will be
 fine. One thing to check is your table definitions … no amount of
 interpreted language will save you from that. I think the tipping
 point will be this afternoon sometime but with the planned maintenance
 it might end up being later in the day.

 Thanks;
   — Matt Sanford / @mzsanford


[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Chad Etzel

I'm assuming this is just a friendly warning to developers... and that
the status IDs will continue to monotonically increase past (2^31 -
1), i.e. not rollover?

-Chad

On Wed, May 13, 2009 at 10:40 AM, Matt Sanford m...@twitter.com wrote:

 Make that *signed* integer. Writing too many emails at once, sorry.

 On May 13, 7:38 am, Matt Sanford m...@twitter.com wrote:
 Hi all,

     Just a quick heads up. Our status id is fast approaching the
 maximum unsigned integer value. Based on all of the feedback on
 scaling I've received from this list I'm assuming everyone will be
 fine. One thing to check is your table definitions … no amount of
 interpreted language will save you from that. I think the tipping
 point will be this afternoon sometime but with the planned maintenance
 it might end up being later in the day.

 Thanks;
   — Matt Sanford / @mzsanford


[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Dossy Shiobara


When you say integer what are you referring to?  I'm _assuming_ 32-bit 
integers, not 64-bit integers, because ILP-32 is so commonplace.


When you're about to breach the 2^64 in your ID space, please give us a 
heads-up around 2^63 so we can upgrade our systems.  :)


On 5/13/09 10:40 AM, Matt Sanford wrote:

Make that *signed* integer. Writing too many emails at once, sorry.

On May 13, 7:38 am, Matt Sanfordm...@twitter.com  wrote:

Hi all,

 Just a quick heads up. Our status id is fast approaching the
maximum unsigned integer value. Based on all of the feedback on
scaling I've received from this list I'm assuming everyone will be
fine. One thing to check is your table definitions … no amount of
interpreted language will save you from that. I think the tipping
point will be this afternoon sometime but with the planned maintenance
it might end up being later in the day.

Thanks;
   — Matt Sanford / @mzsanford



--
Dossy Shiobara  | do...@panoptic.com | http://dossy.org/
Panoptic Computer Network   | http://panoptic.com/
  He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)



[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Nick Arnett
On Wed, May 13, 2009 at 7:40 AM, Matt Sanford m...@twitter.com wrote:


 Make that *signed* integer. Writing too many emails at once, sorry.


That would be the MySQL (and any 32-bit OS) maximum signed integer, or
2,147,483,647,
I'm assuming.  So if we're using an unsigned INT in our tables, we're fine
for a while (months?) - status IDs will always be positive, right?  And
BIGINT, especially unsigned, is safe for a long, long time?

Just curious... does this mean Twitter really is closing in on 2 billion
tweets, or were some IDs skipped?  Is there a prize for whoever posts tweet
number 2 billion?  ;-)

Nick


[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Matt Sanford

Hi Nick,

As mentioned to Dossy (probably still wending its way thought  
Google Groups) I did mean 32-bit signed integers. Unsigned ints in  
MySQL will be fine but the rails default is int(10) if I recall which  
would be a problem. As mentioned to Chad (Google Groups seems to be  
slow delivering my messages :/) status IDs will continue to increment  
as positive numbers. BIGINT and unsigned number should be fine for the  
time being, yes.
You know we don't comment on the number of users and tweets … but  
you almost tricked me. Sneaky, sneaky.


Thanks;
 – Matt Sanford / @mzsanford
 Twitter Dev

On May 13, 2009, at 8:13 AM, Nick Arnett wrote:




On Wed, May 13, 2009 at 7:40 AM, Matt Sanford m...@twitter.com  
wrote:


Make that *signed* integer. Writing too many emails at once, sorry.

That would be the MySQL (and any 32-bit OS) maximum signed integer,  
or 2,147,483,647, I'm assuming.  So if we're using an unsigned INT  
in our tables, we're fine for a while (months?) - status IDs will  
always be positive, right?  And BIGINT, especially unsigned, is safe  
for a long, long time?


Just curious... does this mean Twitter really is closing in on 2  
billion tweets, or were some IDs skipped?  Is there a prize for  
whoever posts tweet number 2 billion?  ;-)


Nick




[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Chad Etzel

On Wed, May 13, 2009 at 11:08 AM, Matt Sanford m...@twitter.com wrote:
 When we breach 2^64 I'm not telling anyone … it seems to
 create more work for me when I send out friendly warnings :)

Well, if you *did* send out a warning at 2^64, it would mean either:

a) you have found the fountain of youth
b) you're a zombie
c) you wrote the most awesome cron job ever
d) you have a Delorean

-Chad


[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Matt Sanford


Have you not heard, we're tweeting from space these days. Birth rate  
changes are now considered optional.


No Humans Required™
  — Matt

On May 13, 2009, at 8:26 AM, Andrew Badera wrote:



or e) Twitter becomes even more massively popular while the world also
undergoes a birth rate revoluion.

Thanks-
- Andy Badera
- and...@badera.us
- Google me: http://www.google.com/search?q=andrew+badera
- This email is: [ ] bloggable [x] ask first [ ] private



On Wed, May 13, 2009 at 11:21 AM, Chad Etzel jazzyc...@gmail.com  
wrote:


On Wed, May 13, 2009 at 11:08 AM, Matt Sanford m...@twitter.com  
wrote:

When we breach 2^64 I'm not telling anyone … it seems to
create more work for me when I send out friendly warnings :)


Well, if you *did* send out a warning at 2^64, it would mean either:

a) you have found the fountain of youth
b) you're a zombie
c) you wrote the most awesome cron job ever
d) you have a Delorean

-Chad





[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Cameron Kaiser

 I see that the product manager/APIs position is still on your site... does
 that mean the position is still open?  Does teasing the API team help as a
 qualification?

It may get you an interview, but only so they can surreptitiously get a
photo and send it to the nice Italian men with the kneecappers.

-- 
 personal: http://www.cameronkaiser.com/ --
  Cameron Kaiser * Floodgap Systems * www.floodgap.com * ckai...@floodgap.com
-- They told me I was gullible ... and I believed them. ---


[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Matt Sanford


Quick update …

While looking at the code that reminded me of this error I see it  
had some bugs of its own. We seem to have a matter of weeks rather  
than days before this change. Mobile developers and other who deride  
our lack of early notice take heed … now is the time to go unsigned.


Thanks;
 – Matt Sanford / @mzsanford
 Twitter Dev

On May 13, 2009, at 10:49 AM, Cameron Kaiser wrote:



I see that the product manager/APIs position is still on your  
site... does
that mean the position is still open?  Does teasing the API team  
help as a

qualification?


It may get you an interview, but only so they can surreptitiously  
get a

photo and send it to the nice Italian men with the kneecappers.

--
 personal: http://www.cameronkaiser.com/ 
 --

 Cameron Kaiser * Floodgap Systems * www.floodgap.com * ckai...@floodgap.com
-- They told me I was gullible ... and I believed them.  
---




[twitter-dev] Re: Status ID closing in on maximum unsigned integer

2009-05-13 Thread Craig Hockenberry

Let me be the first to say THANK YOU for this advance notice. I found
and fixed some bugs in our iPhone client today because of it — and I'm
very happy to hear that we have some time to get the code approved in
the App Store.

We love to complain when the process goes awry, but it's also
important to remember to give credit when it's well and truly due.
Thanks again!

-ch

On May 13, 12:12 pm, Matt Sanford m...@twitter.com wrote:
 Quick update …

      While looking at the code that reminded me of this error I see it  
 had some bugs of its own. We seem to have a matter of weeks rather  
 than days before this change. Mobile developers and other who deride  
 our lack of early notice take heed … now is the time to go unsigned.

 Thanks;
   – Matt Sanford / @mzsanford
       Twitter Dev

 On May 13, 2009, at 10:49 AM, Cameron Kaiser wrote:





  I see that the product manager/APIs position is still on your  
  site... does
  that mean the position is still open?  Does teasing the API team  
  help as a
  qualification?

  It may get you an interview, but only so they can surreptitiously  
  get a
  photo and send it to the nice Italian men with the kneecappers.

  --
   personal:http://www.cameronkaiser.com/
   --
   Cameron Kaiser * Floodgap Systems *www.floodgap.com* ckai...@floodgap.com
  -- They told me I was gullible ... and I believed them.  
  ---