What the Twitter plugin collects

The Twitter plugin collects your tweets, your friends' tweets, mentions of your @username, retweets of any of your tweets, your favorite tweets, the tweets you've replied to, your follower count (every crawl), the users you follow, the users who follow you, all links in all the tweets captured, image thumbnails from links in all the captured tweets, individual places (lat/long, place name), places as they are related to individual tweets and users, hashtags (realtime only), what tweets of yours anyone has favorited (realtime only), and relationships between users (whether or not they've friended/followed each other).

Source: https://github.com/ginatrapani/ThinkUp/wiki/Configuration:-Twitter via Anyone else surprised by the size of their database?




Database setup

[root@server1 ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database thinkup;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on thinkup.* to 'thinkup'@'localhost' identified by 'REDACTED';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)


Home | About | Sitemap | Recent changes | © Philip Durbin | @philipdurbin | philipdurbin@gmail.com