I've been building an internal application for Fedihosting Foundation. It's an automation that queries Lemmy's PostgreSQL database for statistics about user count per community and stores it to a database for time-series analysis.
These are the requirements our CIO Jelloeater wrote up for me:
