Mish

Prisma Python is dead. Long live Piccolo.

So, the ORM library that Nephthys uses to access its database was discontinued this year D:

Migrating to a more modern one (Piccolo) was a massive effort, with the PR touching 66 files across 36 commits. I also did a lot of testing of the new database migrations, because I really didn’t want to break ~20 HC support bots when I pushed this update.

Oh yeah! We have proper database migrations now. We didn’t before. 😨

Other changes

I also added some new “macros” (which are like preset responses) for Flavortown, added support for more programs, and added to the API.

Tested and accepted @End’s PR to allow admins to add tags from the App Home, along with some other small improvements. Looking forward to adding more features soon, now that Easter has begun!

I added some new APIs to Nephthys!

• Stats v2 improves the response format and adds more statistics to API, and does it for 4 time periods (last 24h, previous 24h, this week, previous week)
• There’s also an API to get many tickets! You can filter by date range and ticket state. This has been used by the Flavortown admins to generate summaries of tickets using ✨AI✨

I also started migrating the bot to use the blockkit library for creating Slack UIs (instead of raw JSON), and updated dependencies to fix some potential DoS vulns.

Finally, Nephthys is now also available for the Stasis YSWS and Hack Club: The Game (sign up!!)

We now have more statistics! Including average time for a question to be resolved, and longest unanswered question.

These are then used in the Flavortown internal dashboard :)

I’ve been working on a new feature called “question tags”! This will let the team track which questions are most asked, and how those trends change over time.

I’ve taken on development of Nephthys (aka helper heidi or Heidi the Assistant) for the launch of Flavortown!

I made the App Home experience faster, made the leaderboard and stats visible to everyone (not just helpers), added a logging pipeline using Loki to make issues easier to troubleshoot, added a new ticket info API endpoint, and made the bot more reliable (e.g. it doesn’t send messages to the main channel if you quickly delete a message any more).

(sorry about the first image; I can’t remove it now :pf:)

Mish!