πŸ“š Node [[moa schema]]
πŸ““ moa schema.md (text) by @anagora@matrix.org
  • [[2022-05-11 21:40:50]] [[@flancian:matrix.org]] (link):
    • [[moa schema]]:
    • table [[bridge]] contains one row per moa user, with separate fields prefixed twittter_, mastodon_, instagram_ for auth tokens and last cross posted resource
    • [[bridgemetadata]] maps bridges to workers, keeps track of time of last tweet/toot
    • [[bridgestat]] has counts and such -- unsure why it's a separate table from the above
    • [[mapping]] contains the association of a mastodon post id and a twitter id, unsure why it doesn't have instagram (perhaps it was created after instagram broke?)
    • [[mastodon host]] contains information about the instances
    • [[settings]] has all the checkboxes from the UI
    • [[workerstat]] does what it says in the tin :)

this is all managed with [[alembic]], which I still haven't learnt :) but mean to.

Receiving pushes... (requires JavaScript)
Loading context... (requires JavaScript)
πŸ›οΈ Stoas for [[moa schema]]
πŸ“– Open document (Hedgedoc) at https://doc.anagora.org/moa-schema
πŸ“– Open document (Etherpad) at https://stoa.anagora.org/p/moa-schema
πŸ“Ή Video conferencing space (Jitsi Meet) at https://meet.jit.si/moa-schema