@zzxiv @andrewparker @datasetteproj That was one of my first use-cases for twitter-to-sqlite! I have it running on a cron every ten minutes that fetches the most recent 50 tweets that I've favourited
*/10 * * * * run-one twitter-to-sqlite favorites /home/simon/twitter.db -a /home/simon/auth.json --stop_after=50
*/10 * * * * run-one twitter-to-sqlite favorites /home/simon/twitter.db -a /home/simon/auth.json --stop_after=50
@zzxiv @andrewparker @datasetteproj Then I can use Datasette to search my favorites - I have 23,993 favorited tweets in the index now 
@zzxiv @andrewparker @datasetteproj I'm not yet fetching the content of the linked articles, but I've thought about doing that - I could have a separate DB table with URLs and article contents which is also setup for full-text search pretty easily
@zzxiv @andrewparker @datasetteproj You might enjoy github.com/rixx/goodreads… too - I have a cron running which fetches my latest Goodreads activity into a SQLite database that I can browse with Datasette as well
