• stevekrouse avatar
    populateTwitterDB
    @stevekrouse
    Poll Twitter & Populate SQlite database The twitter API (or in this case someone else's wrapper over the twitter API) is finicky, so we just try to get one handle per minute, and shove whatever we get into our database, which could be an error message (this is why handles don't have a unique index).
    Script
  • stevekrouse avatar
    twitterFollowingsMigrations
    @stevekrouse
    Example Hosted SQLite on Turso Creates a database of twitter users and followers Requires tursoURL and tursoToken in your secrets. It references @stevekrouse.stevekrouseFollowing to get a list of all the twitter IDs of the users I follow on twitter and insert them to the users table and the followings table as people I follow. @stevekrouse.populateTwitterDB is a poll job that runs every minute and tries to populate this table with the twitter handles of these users.
    Script
1
Next
October 23, 2023