TheTechTalker.com

A blog for technology, life, music, humor and much more

Get Your Twitter Feed into SQL Server with Tweet-SQL

If you’re reading this post, you’re probably a Developer or SQL Server DBA, twitter-sqland you’re probably into Twitter, so you’re probably going to be interested in Rhys Campbell’s Tweet-SQL.

Tweet-SQL is a set of SQL Server stored procedures that let you work with the Open Source Twitter API just by writing T-SQL code. You can do things like:
* Get the list of people you’re following into a database
* Retrieve their messages into a table
* Analyze who’s following who, and figure out who you should be following
* Compile metrics about what’s going on out there

Tweet-SQL Features
* Simple deployment.
* Simple GUI for configuration.
* Stored Procedures for configuration changes with TSQL.
* Over 30 procedures to interact with the Twitter API.
* Flexible ways to deal with resultsets.
* No unfair licensing restricting you to a single Twitter account.
* Free updates for 1 year.

To get started, you’ll need a 30-day eval copy of Tweet-SQL. It’s free to evaluate, and costs £25 at this point of time.

The Twitter API is pretty darned powerful, and it enables you to do things like:
* Find out who your followers are following, which might be people you also find interesting
* Find influential people in your Twitter network
* Get recap reports of what links have been sent out recently, or what hot topics are out there
* Get peoples’ updates without actually following them directly
* Build a web-based equivalent to TweetDeck, with multiple user functionality

For sample scripts, check out SQLCLRNews, Rhys Campbell’s blog where he posts how-to examples for Tweet-SQL.

Add to FacebookAdd to NewsvineAdd to DiggAdd to Del.icio.usAdd to StumbleuponAdd to RedditAdd to BlinklistAdd to Ma.gnoliaAdd to TechnoratiAdd to Furl

Advertisements

February 16, 2009 - Posted by | Blogging, Internet, OpenSource, Programming, Software, Technology, Web 2.0 | , , , ,

1 Comment »

  1. […] Get Your Twitter Feed into SQL Server with Tweet-SQL « T3c-n0-cr@t … […]

    Pingback by Scl 600 Mercedes Benz King 600 Trumpet 4 Pole 600 Volt 3 Phase Motor | Performancebrakes | February 17, 2009 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: