buckbanzai/seattlecitylight-mastodon-bot
1
0
Fork 0
Code Issues 7 Pull requests Projects Releases Packages 1 Wiki Activity

Distributed Operation #135

New issue
Open
opened 2025-11-03 13:44:50 -08:00 by buckbanzai · 0 comments
buckbanzai commented 2025-11-03 13:44:50 -08:00
Owner
Copy link

Since this bot's operation could be impacted in the event of a power outage, we should migrate to rqlite as the database, so multiple copies of the script can run on multiple servers to protect against an outage.

Some things to be considered:

  1. We should expose the SQLAlchemy connection string via config
  2. We should offer a table name prefix to allow sharing a database with other projects (like kuow-mastodon-bot)
  3. How to protect against simultaneous updates from multiple workers
  4. Other dependencies (Mastodon, Nominatim, OSM Tiles)
Since this bot's operation could be impacted in the event of a power outage, we should migrate to [rqlite](https://rqlite.io/) as the database, so multiple copies of the script can run on multiple servers to protect against an outage. Some things to be considered: 1. We should expose the SQLAlchemy connection string via config 2. We should offer a table name prefix to allow sharing a database with other projects (like [kuow-mastodon-bot](https://scm.gruezi.net/buckbanzai/kuow-mastodon-bot)) 3. How to protect against simultaneous updates from multiple workers 4. Other dependencies (Mastodon, Nominatim, OSM Tiles)
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
edit-posts
switch-map-generator
No results found.
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
buckbanzai/seattlecitylight-mastodon-bot#135
No description provided.