Ramblings on technology with a dash of social commentary
RSS icon Email icon Home icon
  • Twitter API Snowflake and MySQL

    Posted on November 13th, 2010 phpguru 2 comments

    I’ve been looking at APIs lately, and in particular, the Twitter API.

    I managed to stumble into an advanced discussion on the Twitter developer forums about Twitter’s “Snowflake” update. One of the primary changes of the Snowflake update is the use of 64-bit integers for their ID.

    As a PHP & MySQL developer interested in learning more about the Twitter API, I want my database schema to be optimized properly.

    On this page of the MySQL website, it says, in part:

    Some things you should be aware of with respect to BIGINT columns:

    • All arithmetic is done using signed BIGINT or DOUBLE values, so you should not use unsigned big integers larger than 9223372036854775807 (63 bits) except with bit functions! If you do that, some of the last digits in the result may be wrong because of rounding errors when converting a BIGINT value to a DOUBLE.

    Does that mean I cannot use a BIGINT to store a Tweet’s primary key?

    Surely VARCHAR(64) will be much slower…

  • Another Twitter Follower I am Proud Of

    Posted on October 2nd, 2010 phpguru No comments

    MancowMuller is now following me on Twitter. What a cool guy.

    Mancow, I really Miss you & Turd on the morning show in Chicago. I moved away over 8 years ago, and still have yet to find a better morning talk radio show. Laura Ingraham is my current pick. I guess she’s a great 2nd choice. I need to download your past shows and put it on my iPod.

    My wife and I still listen to White Cotton Panties. “Bread is not my friend!” ROFL.

    Also, I still use ” … sofa king good… ” all the time. It gets past every profanity filter there is.

    Mancow, for the month of October, Pick a Charity of your choice, and all the proceeds I get from my online T-Shirt Shop FeelGoodGear.com I’ll give to your favorite charity.


     DUH: Democrats for Understanding History

    Spreadshirt Market Place Design

    DUH: Democrats for Understanding History


     God Bless Our Boys Our Girls Our Country F14

    Spreadshirt Market Place Design

    God Bless Our Boys Our Girls Our Country F14


     Bovine Excrement Free - 2 Color Art

    Spreadshirt Market Place Design

    Bovine Excrement Free – 2 Color Art


     God Bless Our Boys - 1 Color Art

    Spreadshirt Market Place Design

    God Bless Our Boys – 1 Color Art


     Borders Language Culture - 3 Color Art

    Spreadshirt Market Place Design

    Borders Language Culture – 3 Color Art


     Republican Elephant - 2 Color Art

    Spreadshirt Market Place Design

    Republican Elephant – 2 Color Art

    MancowMuller is following me on Twitter

    MancowMuller is following me on Twitter

  • Why Twitter is Cool

    Posted on September 26th, 2010 phpguru No comments

    Check out this email I just received.

    Karl Rove is now following me on Twitter

    Karl Rove is now following me on Twitter

    It was funny – I saw this when I checked my email this morning and exclaimed,

    Hey, Karl Rove is following me on Twitter!

    My wife said,

    Who’s Karl Rove?

    We were just stepping into the local Starbucks. I glanced on the cover of the New York Times, and Karl Rove was featured in the first line of a front page story. I nudged my wife, pointed and said,

    See? Look, Karl Rove.

    The New York Times article summarizes Mr. Rove’s career, and also hints as to why he’s been more in the news lately:

    Already a prominent presence as an analyst on Fox News Channel and a columnist at The Wall Street Journal, Mr. Rove is also playing a leading role in building what amounts to a shadow Republican Party, a network of donors and operatives that is among the most aggressive in the Republican effort to capture control of the House and the Senate.

    Democrats were happy when Mr. Rove left the White House in 2007 and don’t appear to be too thrilled about his return to the public eye.

    Anytime Democrats are not happy about something… that’s good news for Republicans, business owners, everyday Americans and the middle class. Great news.

    Anyway, that’s why Twitter is cool. Instantly connect to the world… you care about. I’m directly connected to the the shapers of This Great Country we love so dearly. This got me thinking,

    I better step up my game, now that Karl Rove is watching me.

    Once someone I respect is paying attention, I want to straighten up, stand tall, and look and perform my best; live up to my ideal; project excellence with honor.

    Ironically, this is exactly what Karl Rove does (and a few others, Beck, Hannity, Ingraham, O’reilly, Broomhead) to the Liberal establishment. Once these guys aim their discerning eyes at you and speak the truth, the laser-focused exposure on the ridiculous behavior we are getting from these insane Dems in power makes them realize they have to clean up their act, stand up straight and improve their game. Bigtime.

    As more truth is revealed about ObamaCare, the Stimulus, and the Dems socialist globalist agenda, The People are wising up, and Dems are all realizing that their days are numbered. And no, they don’t like it one bit.

    Keep it up, Karl!

  • The Strange Boom in the Popularity of Shorter URLs

    Posted on June 10th, 2009 phpguru No comments

    It was recently noted that bit.ly took over as the #1 “url shortening service” to twitter users, besting the oldest and most well-known of such services,  http://tinyurl.com/. Some 46% of shortened links redirect through the service.

    Lately though, I keep stumbling onto more and more short URL services.

    Here’s a post at Mashable that lists… get this… 90 of them.