http://e26whn2524322mkxb3cbyk27ev2ihhq2biz35hty7gzgsyrwrygq27yd.onion/posts/blog/security/digging-into-the-behaviour-of-a-self-authenticating-mastodon-scraper-bot.html
/bin/bash
#
# Query Mastodon's database and look for newly created apps
#
POSTGRES="docker exec postgres psql -
U postgres -d mastodon"
# Who are we emailing?
DEST="
[email protected]"
# Run the query
RESP=`$POSTGRES -c "SELECT id, name, redirect_uri, scopes, created_at, updated_at, superapp, website FROM public.oauth_applications WHERE created_at > now() - interval '24 hour' "`
# Any results?