Notes and Tips

Mastodon

A couple people I follow decided to host their own personal Mastodon server so they can be in full control of their instance. Here are their notes about it:

Read more...

Get verified on Mastodon with your website (Opensource.com)

Verifying your GitHub profile on Mastodon (Simon Willison’s TILs)

How to Verify Write.as and WriteFreely Blogs on Mastodon: I have verified that this works on Write.as. I was unable to get it to work on WriteFreely v13.2 but it does work on v14.0 – see this procedure.

Read more...

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