Skip to content

Instantly share code, notes, and snippets.

@mrw34
mrw34 / package.json
Created April 6, 2016 16:45
Mixpanel export
{
"dependencies": {
"moment": "^2.12.0",
"request": "^2.70.0",
"underscore": "^1.8.3"
}
}
@mrw34
mrw34 / postgres.sh
Last active March 26, 2024 00:24
Enabling SSL for PostgreSQL in Docker
#!/bin/bash
set -euo pipefail
openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req -keyout privkey.pem
openssl rsa -in privkey.pem -passin pass:abcd -out server.key
openssl req -x509 -in server.req -text -key server.key -out server.crt
chmod 600 server.key
test $(uname -s) = Linux && chown 70 server.key
docker run -d --name postgres -e POSTGRES_HOST_AUTH_METHOD=trust -v "$(pwd)/server.crt:/var/lib/postgresql/server.crt:ro" -v "$(pwd)/server.key:/var/lib/postgresql/server.key:ro" postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key
@mrw34
mrw34 / INSTALL.sh
Created March 17, 2018 15:26
Install "go read" on App Engine using Google Cloud Shell
# open https://console.cloud.google.com/home/dashboard?cloudshell=true
PROJECT_ID=go-read-123456
gcloud projects create $PROJECT_ID
gcloud app create --project=$PROJECT_ID
goapp get -d github.com/mjibson/goread
cd ~/gopath/src/github.com/mjibson/goread/app/
sed s/go-read/$PROJECT_ID/ app.sample.yaml >app.yaml
cp ../settings.go.dist ../settings.go
goapp deploy
@mrw34
mrw34 / file.sh
Created October 2, 2020 14:51
CSV to JSON using Python 2
python -c "import csv,json,fileinput;print(json.dumps(list(csv.DictReader(fileinput.input()))))" file.csv