Notes and Tips

This info is now deprecated. See Twitter API access levels and versions

I had been using self-programmed apps with Twitter API v1.1 to backup and provide search capability for my tweets, likes, and RTs.

But then I found out about the twitter-to-sqlite and sqlite-utils apps created by Simon Willison. These provide a much easier and very powerful way to backup, analyze, and search the full range of one's twitter data, including timeline, followers, following, lists, mentions, etc. Data is saved in a sqlite3 database for easy searching and analysis with sql querying.

It can also be used with the Twitter archive .zip download of one's data. Both twitter-to-sqlite and sqlite-utils are Python modules and are part of the Datasette suite of apps created by Simon.

Note: since this post was created on a Writefreely federated blog (via ActivityPub), it could be directly added to my Mastodon instance timeline by boosting it's federated link.

#Datasette #Mastodon #Python #Sqlite #TwitterAPI #Writefreely