Skip to content

Instantly share code, notes, and snippets.

View dtseiler's full-sized avatar
🏒

Don Seiler dtseiler

🏒
View GitHub Profile
#!/usr/bin/python
#from gpiozero import Button, LED
from gpiozero import Button, LEDBoard
import time
import vlc
BTW_BUTTON_PIN=2
BTW_LED_PIN=17
GOAL_LED_PIN=21
@dtseiler
dtseiler / partition.sql
Last active June 20, 2020 20:40
pg_partman with PG12 native partitioning
-- Setup users table and populate
CREATE TABLE users (
id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
email VARCHAR(40) NOT NULL UNIQUE,
created_at TIMESTAMP NOT NULL
);
INSERT INTO users (email, created_at)
SELECT
'user_' || seq || '@' || (
CASE (RANDOM() * 2)::INT
@dtseiler
dtseiler / furnace_line_blueprint.txt
Last active September 24, 2019 04:01
Furnace Line Blueprint
0eNqdlWFvgyAQhv/LfcYE1GnrX1mWxeq1I1EwCMuaxv8+artua5F5+0QQfN7j7t7cCXadw8FIZaE6gWy0GqF6PsEoD6ruzt/scUCoQFrsgYGq+/MOO2yskU2yd0bVDcLEQKoWP6AS0wsDVFZaiRfWvDm+Ktfv0PgLyxQGgx79j1qdlT0sSRkc/ZJNE3sApQSQiHCyG6fT6pC81f4hbSLViMb688egsgtMhGD5DbavRxujpF8UBq00/gHzWR5gPv1mOh+fORjt12SHnQ2wRZDtFa/V1M4OzkJAq6Bq8T+kpFpQKolpTyNZ36zNulid9C2xkMG4BCeX7kLj9MoJQdbKrpFTSye+rddjK12f3Bw46A4XlXgwR2T/iVDYoRqKnIjmq8l3nrSmVuOgjY265L6qIXBBA1+TsYZc0kwSbugNtclEvJ+Xe2xLVUrj3bzsnJQT2znSzek/xlt4utHHm+f42TtP6urHYGfwjmacL5cZF5ttUXBRTtMnvoOrZw==

Keybase proof

I hereby claim:

  • I am dtseiler on github.
  • I am dtseiler (https://keybase.io/dtseiler) on keybase.
  • I have a public key ASDHCw6U19aPWmSL-CJGIjHekNCaukYdH8y__aRPjRj9YAo

To claim this, I am signing this object:

#!/bin/bash
DATESTAMP=`date +%Y%m%d`
SITESFILE=${HOME}/.drupalsites
# SITESFILE contents are in the following format:
# SITENAME:DBNAME:DBUSER:DBPASSWD
DRUPALDIR=/path/to/drupal
BACKUPDIR=${HOME}/backups/${DATESTAMP}
mkdir -p ${BACKUPDIR}