Skip to content

Instantly share code, notes, and snippets.

View julienma's full-sized avatar

Julien Ma julienma

View GitHub Profile
# fetch @patio11's tweets from microconf (roughly apr 3 on)
# signature generated from https://dev.twitter.com/rest/reference/get/statuses/user_timeline
curl --get 'https://api.twitter.com/1.1/statuses/user_timeline.json' --data 'count=200&screen_name=patio11&since_id=717036680947965953' --header 'Authorization: OAuth oauth_consumer_key="x6nmC5cEByCeyudJjVKsMA", oauth_nonce="56b83cf5f068e31996fc484364e99423", oauth_signature="0vY6VEDKTI2Bb8J09osG0yqTA6M%3D", oauth_signature_method="HMAC-SHA1", oauth_timestamp="1460264255", oauth_token="49019793-1cje0xH21w4OsEudjSXTIj1hDQhorGifIrfuBQ0Eb", oauth_version="1.0"' --verbose > tweets.json
# import into postgres
psql -d test -c "CREATE TABLE pgtweets (data json)"
psql -d test -c "COPY pgtweets FROM '$(pwd)/tweets.json'"
# total activity over these 200 tweets
@julienma
julienma / dokku-pg-backup.sh
Last active September 4, 2019 14:40 — forked from dommmel/dokku-pg-backup.sh
dokku postgres (and volume folders) backup cronjob (using https://github.com/dokku/dokku-postgres)
#! /bin/bash
MAILTO=$(whoami)
SHELL=/bin/bash
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
# directory to save backups in, must be rwx by dokku user
BASE_DIR="/var/lib/dokku/data/storage/backups/postgres"
YMD=$(date "+%Y-%m-%d")
DIR="$BASE_DIR/$YMD"