Skip to content

Instantly share code, notes, and snippets.

Rob Dunham Nilpo

Block or report user

Report or block Nilpo

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
Nilpo / database.sql
Created Apr 12, 2018
A sample of a good database creation script.
View database.sql
-- -----------------------------------------------------
-- Temporarily disable key checks
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema Music
-- -----------------------------------------------------
Nilpo / Boot RetroPie from
Last active Apr 15, 2018
How to boot RetroPie (or Raspbian) from a USB drive on the Raspberry Pi 3 B(+)
View Boot RetroPie from

Boot RetroPie from USB on the Raspberry Pi 3 B(+)

You will need a Raspberry Pi 3 B(+) with a microSD card running RetroPie (or Raspbian).

  1. Update Raspbian.

    $ sudo apt-get update && sudo apt-get upgrade -y
Nilpo /
Last active Jan 13, 2019
Instal Plex on Asus Tinker Board
  1. In terminal, upgrade TinkerOS.

    sudo apt update && apt upgrade -y
    sudo apt dist-upgrade
  2. Install avahi-daemon

Nilpo / Raspberry Pi Plex Media
Last active Jun 26, 2019
Install Plex on Raspbian Stretch for Raspberry Pi 3
View Raspberry Pi Plex Media
  1. In terminal, upgrade Raspbian.

    sudo apt update && sudo apt dist-upgrade -y
  2. Next, use the raspi-config tool to change some default system settings.

    sudo raspi-config
Nilpo /
Created Feb 4, 2018 — forked from brock/
Exporting and Importing Postgres Databases using gzip
# This is just a cheat sheet:
# On production
sudo -u postgres pg_dump database | gzip -9 > database.sql.gz
# On local
scp -C production:~/database.sql.gz
dropdb database && createdb database
gunzip < database.sql.gz | psql database
Nilpo / gist:52eda0bf40fddec539aa4ac4bb0ecc2c
Created Sep 9, 2017 — forked from cdown/gist:1163649
Bash urlencode and urldecode
View gist:52eda0bf40fddec539aa4ac4bb0ecc2c
urlencode() {
# urlencode <string>
local length="${#1}"
for (( i = 0; i < length; i++ )); do
local c="${1:i:1}"
case $c in
[a-zA-Z0-9.~_-]) printf "$c" ;;
View Ultron
from line import LineClient, LineGroup, LineContact, LineMessage
import os
import sys
import re
import ast
from curve.ttypes import OperationType, TalkException
# client5 = LineClient("", "321321Ab", authToken="EiLW77LqJc7usR6vB5z9.7x9TsSw19TOlLNYRF2HOUq.sCuQ9zBZ90djqjN0dkBubuPcT2WDi5mG5razGdrcrgI=", com_name="Aero5", is_mac=False)
# client5 = LineClient(os.environ['LINE_ULTRON_LOGIN'], os.environ['LINE_ULTRON_PASS'], com_name="Aero5", is_mac=False)
Nilpo /
Last active Jul 9, 2017 — forked from seanbehan/
logging on heroku with flask
import os
import sys
import logging
from flask import Flask
app = Flask(__name__)
if 'DYNO' in os.environ:
Nilpo / proxy.apache.conf
Created Jun 26, 2017 — forked from chrisjhoughton/proxy.apache.conf
Sample Nginx reverse proxy to Apache set up for Wordpress.
View proxy.apache.conf
<VirtualHost *:{PORT}>
DocumentRoot /var/www/yourdir/
<Directory /var/www/yourdir>
Options Indexes FollowSymLinks
AllowOverride all
Order allow,deny
You can’t perform that action at this time.