search

dogsheep / twitter-to-sqlite

Save data from Twitter to a SQLite database
Apache License 2.0
402 stars 21 forks source link

Command to import home-timeline #18

Closed simonw closed 5 years ago

simonw commented 5 years ago

Feature request: https://twitter.com/johankj/status/1182563563136868352

Would it be possible to save all tweets in my timeline from the last X days? I would love to see how big a percentage some users are of my daily timeline as a metric on whether I should unfollow them/move them to a list.

simonw commented 5 years ago

https://developer.twitter.com/en/docs/tweets/timelines/api-reference/get-statuses-home_timeline

simonw commented 5 years ago

Rate limit is tight: 15 requests every 15 mins!

simonw commented 5 years ago

In order to support multiple user timelines being saved in the same database, I'm going to import the tweets into the tweets table AND add a new timeline_tweets table recording that a specific tweet showed up in a specific user's timeline.

simonw commented 5 years ago

Documented here: https://github.com/dogsheep/twitter-to-sqlite/blob/master/README.md#retrieving-tweets-from-your-home-timeline