Skip to content

Keybase Binding Queries

Query Inspiration

Reminders

  • We already indexed the character length as well as word length
  • Should we also index number of reactions, YES it will make things much easier
  • I need to fix the indexing of topic names, entire string not there
  • I should count the reactions as a int when initially indexing
  • I should index the size of each message when initially indexing
  • Skip Pagiation for now, just get 250
  • Don't try and get everything working at once
  • We can look for the most of a specific character or word
  • Analysis Queries

Query Brainstorming

  • Who sent the most messages
  • Who sent the most message, within a certain time range
  • Who sent reacted the most per message sent
  • Who replied the most per message sent
  • Who sent the more ( reactions
  • Who was replied to the most
  • Longest active user
  • Shortest active user
  • Average Half Life of a User

Base Queries (Not in dashboard)

List

Ways to measure things

  • Existence of characteristic exists
  • User has or hos not posted in Topic or Team
  • User has or has not replied to or mentioned another user
  • Longest
  • Message relative to User, Topic, and Team
  • Most
  • Reactions to Message across topic, team, or specific user
  • Replies to message across topic, team, or specific user
  • Messages within or from a specific topic, team, or user
  • Mentions of user across topic or team
  • Mentions of topic, across team
  • Time / Chronology
  • Oldest
  • Newest
  • Restricted time range