SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Pulling real-time data from Twitter using StreamInsight


Pulling real-time data from Twitter using StreamInsight

Author
Message
JAhlen
JAhlen
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 127
Comments posted to this topic are about the item Pulling real-time data from Twitter using StreamInsight
BOR15K
BOR15K
Mr or Mrs. 500
Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)

Group: General Forum Members
Points: 578 Visits: 453
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
JAhlen
JAhlen
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 127
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
Matt Whitfield
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1641 Visits: 719
Awesome article sir - I think I'll definitely be playing around with this :-D

Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone
Brandie Tarvin
Brandie Tarvin
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25939 Visits: 9182
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/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
Steve Jones
SSC Guru
SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)

Group: Administrators
Points: 106081 Visits: 19332
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.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Sean Fynn
Sean Fynn
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 57
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
Trey Staker
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1446 Visits: 2788
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
SQLRNNR
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49287 Visits: 18570
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

drowling23
drowling23
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 0
Why do you use Newtonsoft.Json? Don't we have a DataContractSerializer that supports Json?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search