If you’re going to use SQLite regularly, you’ll need some extra infrastructure. OP’s post provides some boilerplate that would help you on your way.

What has really made the difference for me recently though, is Simon Willison’s sqlite_utils package. It’s heavier weight than OP’s wrapper classes, but it’s infinitely more powerful and has made using a local database a joy instead of the kludge I usually make of it. I’ll be bummed to writing stuff for PostGres when I have to do that

+1 for this question. Postman was a thing of simple beauty before they tried chasing the VC money

While I would love to see Twitter auguring straight into the ground, Twitter’s API changes would explain some portion of this traffic changes. I wonder if there are any other proxy measures for audience engagement as separate from basic traffic