- Simple deployment.
- Simple GUI for configuration.
- Stored Procedures for configuration changes with TSQL.
- Over 90 procedures to interact with the Twitter API and more (see the table below).
- Functions for handling dates and url encoding strings.
- Flexible ways to deal with resultsets.
- No unfair licensing restricting you to a single Twitter account.
- Free updates for 1 year.
- Free upgrade for all Tweet-SQL users to version 3 to allow oAuth authentication.
- Version 2 list. Update to version 3 coming soon. In the meantime consult the manual.
| Procedures | Comment |
|---|---|
| tweet_acc_archive | Legacy prodecure. * |
| tweet_acc_end_session | Terminates any active Twitter session. |
| tweet_acc_rate_limit_status | Query your current rate limit status. |
| tweet_acc_update_delivery_device | Update your delivery device settings. |
| tweet_acc_update_location | Update your location on Twitter. Depreciated in favour of tweet_acc_update_profile. * |
| tweet_acc_update_profile | Update your profile details. |
| tweet_acc_update_profile_colors | Update your profile colours. |
| tweet_acc_verify_credentials | Verify the credentials Tweet-SQL holds. |
| tweet_blk_create | Block a Twitter user. |
| tweet_blk_destroy | Remove a block on a Twitter user. |
| tweet_cfg_http_request_timeout | A Tweet-SQL configuration procedure to change the http timeout value. |
| tweet_cfg_licensekey | A Tweet-SQL configuration procedure to change the license key. |
| tweet_cfg_loginDetails | A Tweet-SQL configuration procedure to change username & password. |
| tweet_cfg_no_type_array | A Tweet-SQL configuration procedure to change type array settings. |
| tweet_cfg_resultset_send | A Tweet-SQL configuration procedure to change the way resultsets are presented. |
| tweet_fav_create | Favorite a specific status. |
| tweet_fav_destroy | Destory an existing favorite. |
| tweet_fav_favourites | Return your Favorites. |
| tweet_frd_create | Make friends with another user. |
| tweet_frd_destroy | Unfriend another user. |
| tweet_frd_exists | Check to see if a friendships exists between two users. |
| tweet_hlp_downtime_schedule | Returns the same text displayed on http://twitter.com/home when a maintenance window is scheduled |
| tweet_hlp_test | Returns 'OK'. |
| tweet_msg_destroy | Deletes a direct message. |
| tweet_msg_direct_messages | Return your direct messages. |
| tweet_msg_new | Send a new direct message. |
| tweet_msg_sent | View your sent messages. |
| tweet_not_follow | Enable update notifcations from a specific user. |
| tweet_not_leave | Disable update notifcations from a specific user. |
| tweet_sog_followers | Returns a list of follower ids for a specific user. |
| tweet_sog_followersTable | Like tweet_sog_followers but copies the data to a local table. |
| tweet_sog_friends | Returns a list of friend ids for a specific user. |
| tweet_sog_friendsTable | Like tweet_sog_friends but copies the data to a local table. |
| tweet_src_search | Query the Twitter Search API |
| tweet_sts_destroy | Delete a specific status. |
| tweet_sts_friends_timeline | Return your friends statuses. This is the equivalent of /home on the Web. |
| tweet_sts_public_timeline | Return the public timeline. |
| tweet_sts_replies | Returns the authenticating user's @replies. |
| tweet_sts_show | Shows a specific status. |
| tweet_sts_update | Update your status. |
| tweet_sts_user_timeline | Return user statuses. |
| tweet_usr_featured | Legacy prodecure. * |
| tweet_usr_followers | Return a user's followers. |
| tweet_usr_friends | Return user friends. |
| tweet_usr_show | Returns extended information for a specific user. |
| tweet_util_shortenUrl | Shorten URLs with TinyURL. |
| Functions | |
| tweet_fnc_dateconvert | A Tweet-SQL function to convert HTTP formatted dates into ODBC format. |
| tweet_fnc_httpformat | A Tweet-SQL function to convery ODBC formatted dates into HTTP format. |
| tweet_fnc_urlEncode | A Tweet-SQL function to urlencode strings. |
* These procedures have had their API methods removed, or depreciated, from the official Twitter documentation so you are encouraged not to use these. These may cease to function at any time if Twitter withdraws support from the API.