Skip to content

Instantly share code, notes, and snippets.

View p37307's full-sized avatar

Paul Chambers p37307

View GitHub Profile
@ufuk
ufuk / postgresql-export-tables-to-s3-as-csv-file.sh
Last active July 10, 2023 04:04
BASH script to export some tables from the PostgreSQL database to S3 as CSV files.
#!/bin/bash
export AWS_ACCESS_KEY_ID=...
export AWS_SECRET_ACCESS_KEY=...
export AWS_DEFAULT_REGION=...
PG_HOST=...
PG_USER=...
PG_PASS='...'
PG_DB=...
This gist has moved to https://github.com/AndrewBreyen/Jellyfin-TV-Post-Process
This gist has moved to https://github.com/AndrewBreyen/Jellyfin-TV-Post-Process
@JPVenson
JPVenson / docs.md
Last active July 19, 2023 13:03
cleanup collections.xml for jellyfin

BEFORE YOU START: BACKUP YOUR CONFIGURATION. YOU. HAVE. BEEN. WARNED!

This is the Cs version of the script posted by michaelkrieger at jellyfin/jellyfin#1907 (comment) to cleanup the collection.xml for missing link entires.

Linux Host

To run this on linus, ensure you have a dotnet version installed.
https://learn.microsoft.com/en-us/dotnet/core/install/linux
or for the most part, this oneliner will install dotnet on your system:

#!/bin/bash
date "+%m/%d/%Y,"| tr -d '\n' >> ~/mastodon-stats.txt && (curl -s https://orangebunny.net/api/v1/instance | jq ".stats | [.user_count, .status_count, .domain_count] | @csv" | tr -d '\"') >> ~/mastodon-stats.txt
curl -s https://orangebunny.net/api/v1/instance | jq ".stats | [.user_count, .status_count, .domain_count] | @csv"
#!/usr/bin/env bash
#
# Mastodon update script
# v3 (2024.02.18)
#
# Changelog
# * v1 - initial version
# * v2 - added mastodon-bird-ui
# * v3 - added import of temporary email domains