よしよし、sqls のコメントを含んだ複数ステートメントのフォーマッタが書けた。
Discussion
Mattn-san, quick question(s) about BuzzWord-bot:
What's the time period that BuzzWords reads the posts to find trends (last 1 hour only or is it number of kind1s basis?)
Does it count frequency only or frequency by unique npub?
The ranking is compiled from the posts of the past an hour. In fact, they are accumulated in a real-time queue, which always holds posts from the past an hour.