Pulling real-time data from Twitter using StreamInsight

  • Johan Åhlén

    Ten Centuries

    Points: 1154

    Comments posted to this topic are about the item Pulling real-time data from Twitter using StreamInsight

  • BOR15K

    SSCertifiable

    Points: 5798

    Before I will test it, I have a query, please:

    I understood from Twitter that they have just changed (September 2010) their authentication flow to use oAuth authentication method (it points to Oauth Authentication Flow ver. 1.0a)

    Will your solution work under this new oAuth flow?

    Kind Regards

  • Johan Åhlén

    Ten Centuries

    Points: 1154

    Yes, Twitter changed their authentication in September. From what I have seen it has not had any impact on the streaming API.

    I will update the adapter to work with oAuth later if needed and publish on CodePlex.

    Note however that this adapter is for educational purposes only and not designed for a production environment.

    Kind Regards,

    Johan

    Zeev Kazhdan (9/29/2010)


    Before I will test it, I have a query, please:

    I understood from Twitter that they have just changed (September 2010) their authentication flow to use oAuth authentication method (it points to Oauth Authentication Flow ver. 1.0a)

    Will your solution work under this new oAuth flow?

    Kind Regards

  • Matt Whitfield

    SSCrazy Eights

    Points: 8107

    Awesome article sir - I think I'll definitely be playing around with this 😀

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone

  • Brandie Tarvin

    SSC Guru

    Points: 172760

    I'm going to ask some really stupid questions.

    Why would anyone want to pull data from Twitter? What data are you pulling when you do?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 721420

    I think Twitter has some great possibilities for workflow, and interacting with your customers/followers. I know I'd love to get streaming data from Twitter on what's happening with SQLServerCentral, and maybe SQLHelp. Get that information out, and use it to increase conversations, or maybe just see what people are saying about SQL Server.

  • Sean Fynn

    Valued Member

    Points: 66

    Brandie Tarvin (9/29/2010)


    I'm going to ask some really stupid questions.

    Why would anyone want to pull data from Twitter? What data are you pulling when you do?

    I was thinking this myself as being only an occasional Twitter-er... however, I began to think of business applications where Clients / Customers could Tweet their interest in something... say a project they wish to put their name in for consideration. It appears that thru this API one could pull enough relevant information to join with a background app. Sure they could have just text'd or sent an email to the same system. Obviously with Twitter the message should not be sensitive in nature. This may just offer another way (easily I hope) to connect. Interested to hear other people's ideas too.

    I will be playing with this as well - thanks for the summary POST!!!


    Regards,

    Sean

  • Trey Staker

    SSCarpal Tunnel

    Points: 4736

    I found the article informitive. Years ago I had a need for streaming data into sql server like this for an application that gathered realtime stats. After Reading the article and seeing StreamInsight applied it would of been perfect back then for what we were doing. Unfortunately that was 9 years ago.

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

  • SQLRNNR

    SSC Guru

    Points: 281252

    Nice article. Now I need to find more time to play around with it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • drowling23

    SSC Rookie

    Points: 41

    Why do you use Newtonsoft.Json? Don't we have a DataContractSerializer that supports Json?

  • Johan Åhlén

    Ten Centuries

    Points: 1154

    Old habits from the time before WCF.

    drowling23 (2/6/2011)


    Why do you use Newtonsoft.Json? Don't we have a DataContractSerializer that supports Json?

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply