Skip to content

Instantly share code, notes, and snippets.

View adamanthil's full-sized avatar
I may be slow to respond.

Andrew Bender adamanthil

I may be slow to respond.
View GitHub Profile
@adamanthil
adamanthil / gemp-recursive-runtime-error.log
Created August 1, 2018 03:23
Triggered stack overflow error post-react in battle on GEMP
2018-08-01 00:44:51,896 ERROR SwccgoHttpRequestHandler:368 - Error while processing request
java.lang.StackOverflowError
at java.util.LinkedList.addAll(LinkedList.java:406)
at java.util.LinkedList.addAll(LinkedList.java:385)
at com.gempukku.swccgo.filters.Filters.sameCardId(Filters.java:14248)
at com.gempukku.swccgo.filters.Filters.changeToFilter(Filters.java:74)
at com.gempukku.swccgo.filters.Filters.convertToFilters(Filters.java:16665)
at com.gempukku.swccgo.filters.Filters.and(Filters.java:14115)
at com.gempukku.swccgo.logic.modifiers.MayDeployAsReactToTargetModifier.<init>(MayDeployAsReactToTargetModifier.java:44)
at com.gempukku.swccgo.logic.modifiers.MayDeployAsReactToTargetModifier.<init>(MayDeployAsReactToTargetModifier.java:33)
#!/bin/sh
#
# voodoo-vpn.sh: Amazon EC2 user-data file for automatic configuration of a VPN
# on a Ubuntu server instance. Tested with 12.04.
#
# See http://www.sarfata.org/posts/setting-up-an-amazon-vpn-server.md
#
# DO NOT RUN THIS SCRIPT ON YOUR MAC! THIS IS MEANT TO BE RUN WHEN
# YOUR AMAZON INSTANCE STARTS!
#
#!/bin/bash
# Finds and deletes unused aws security groups, following template for determining unused groups here:
# https://stackoverflow.com/a/24704644
region=$1
comm -23 <(aws ec2 describe-security-groups --query 'SecurityGroups[*].GroupId' \
--output text --region $region | tr '\t' '\n'| sort) \
<(aws ec2 describe-instances --query 'Reservations[*].Instances[*].SecurityGroups[*].GroupId' \
@adamanthil
adamanthil / insert-sample-pivot-data.sql
Last active September 19, 2016 04:31
Inserts sample data for a hypothetical book sales database used for demonstrating methods of writing PIVOT queries in PostgreSQL. Assumes schema described here: http://bender.io/2016/09/18/dynamic-pivot-tables-with-json-and-postgresql
---------------------------------------------------------------------
-- Assumes book, customer, and sale tables in the requisite format
---------------------------------------------------------------------
INSERT INTO book VALUES (1, 'The Martian', 'Andy Weir', 2014, 'Science Fiction', 14.88);
INSERT INTO book VALUES (2, 'Augustus: First Emperor of Rome', 'Adrian Goldsworthy', 2014, 'History', 24.29);
INSERT INTO book VALUES (3, 'Ready Player One', 'Ernest Cline', 2011, 'Science Fiction', 9.69);
INSERT INTO book VALUES (4, 'The Hitchhiker''s Guide to the Galaxy', 'Douglas Adams', 1979, 'Science Fiction', 7.19);
INSERT INTO book VALUES (5, 'The Girl with All the Gifts', 'M. R. Carey', 2014, 'Dystopian Fiction', 11.48);
INSERT INTO book VALUES (6, 'Predictably Irrational', 'Dan Ariely', 2008, 'Behavioral Economics', 9.52);
@adamanthil
adamanthil / create-self-signed-ssl-cert.sh
Created February 25, 2016 01:14
Series of shell commands to create a self-signed SSL cert for use in a dev environment.
# Create self signed cert
# Reference: http://www.akadia.com/services/ssh_test_certificate.html
# Create key (will prompt for a passphrase. This password will be removed later for convenience)
openssl genrsa -des3 -out server.key 2048
# Generate CSR
openssl req -new -key server.key -out server.csr
# Remove key passphrase
@adamanthil
adamanthil / osx-install-php-composer.sh
Created February 10, 2016 20:02
Install PHP Composer globally on OSX
# Install php composer on OSX:
curl -sS https://getcomposer.org/installer | php
sudo mv composer.phar /usr/local/bin
# Add alias in .bashrc / .zshrc etc:
alias composer='php /usr/local/bin/composer.phar'
; supervisor config file
[unix_http_server]
file=/var/run/supervisor.sock ; (the path to the socket file)
chmod=0700 ; sockef file mode (default 0700)
[supervisord]
logfile=/var/log/supervisor/supervisord.log ; (main log file;default $CWD/supervisord.log)
pidfile=/var/run/supervisord.pid ; (supervisord pidfile;default supervisord.pid)
childlogdir=/var/log/supervisor ; ('AUTO' child log dir, default $TEMP)
@adamanthil
adamanthil / read_api.js
Created September 10, 2013 23:08
read http response on localhost:3000
var http = require('http');
var options = {
hostname: 'localhost',
port: '3000',
path: '/'
};
callback = function(response) {
var str = '';
@adamanthil
adamanthil / apache2.conf
Created March 17, 2011 06:35
Apache configuration file
#
# Based upon the NCSA server configuration files originally by Rob McCool.
#
# This is the main Apache server configuration file. It contains the
# configuration directives that give the server its instructions.
# See http://httpd.apache.org/docs/2.2/ for detailed information about
# the directives.
#
# Do NOT simply read the instructions in here without understanding
# what they do. They're here only as hints or reminders. If you are unsure
@adamanthil
adamanthil / brand-table-hierarchical-query.sql
Created June 22, 2015 05:20
An adjusted query to return nested objects in a brand database. Fixes issue where two separate joins caused additional values in aggregates.
--use images and logos tables
with images as (
select
im.brand,
json_agg(
row_to_json(
(select r from (select im.name, im.path as poster) r)
)
) as images
from images im