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
* 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