Posts Tagged ‘Tweet-SQL’

Tweet-SQL Version 3 released

Tweet-SQL version 3 has been released! Here’s a quick summary of the new features. Full 64 bit OS Support. (Previously the installer would fail to created the required registry keys on 64 bit Operating Systems). Full support for oAuth authentication. Support for the new Twitter List methods. See sqlserverpedia list with Tweet-SQL for this in […]

Configuring oAuth for Tweet-SQL

Twitter are soon requiring that all applications accessing their API use oAuth instead of basic authentication. This means you don’t have to provide your password to third parties when using their apps. I’ve been busy adding this to the upcoming version of Tweet-SQL and here’s a quick guide to setting up oAuth. After installing Tweet-SQL […]

Using TwitterCounter with Tweet-SQL

TwitterCounter is a service that provides Twitter user statistics. In their own words; “The TwitterCounter API allows you to retrieve everything TwitterCounter knows about a certain Twitter username.” TwitterCounter basically provides statistics on followers and predictions on growth. The next version of Tweet-SQL will include a procedure to work with this data. Here’s how you […]

Shrinking Tweets with Tweet-SQL

To get your point across on Twitter you sometimes have to try and shorten your tweets. This can be a pain for anyone over 30 who doesn’t know txtspk. Thankfully some clever chap has come to the rescue with TweetShrink and I’ve integrated it into Tweet-SQL. Here’s how you use it; ?View Code TSQLDECLARE @shrunk […]

Know who your friends are with Tweet-SQL

Tweet-SQL version 2 supports the new Twitter social graph API methods. These are two very simple methods to get all of your followers, or friends, Twitter user ids. There are four procedures in Tweet-SQL that support these methods. tweet_sog_followers – Returns the ids of the authenticating users followers or, if a non-null value is supplied […]