Using Python feedparser + sqlite-utils + GitHub Actions to backup Mastodon feeds

In today's video I will show you how to backup your Mostodon toots / posts to a sqlite database using sqlite-utils.

We will explore how to use GitHub Actions' schedule feature as a cronjob and have it commit changes to version control.

We'll also look at a simple Streamlit app to show some trends in the data.

And lastly, I show you some pytest code to prove that the upsert functionality works + a fixture to clean up the test DB.

Hope you pick up some new tricks from this video today. Enjoy!

Links:

---

And last but not least, we appreciate any feedback to make our YouTube content better 💡

[Pybites]

Dependency fix + adding username arg to trends.py are already handled in two issues on the repo :)