Skip to content

Instantly share code, notes, and snippets.

View adamanthil's full-sized avatar

Andrew Bender adamanthil

View GitHub Profile
@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 / 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 = '';
; 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 / large-csv-sample.csv
Created August 13, 2014 03:09
Sample CSV File that does not trigger 'record_parsed' events for all rows when using the csvtojson library. See issue: https://github.com/Keyang/node-csvtojson/issues/28
ID Number
0157181 8002
0157741 6523
0158106 11339
0158685 1246589927
0159044 10240
0159470 6320
0161143 1246588356
0161144 1246589434
0162198 9277
@adamanthil
adamanthil / csvtojson-large-file-issue.js
Created August 13, 2014 03:28
The following javascript should stop triggering events before running through the entire sample csv file using the csvtojson module. See issue: https://github.com/Keyang/node-csvtojson/issues/28
var importIndex = 0;
var csvConverter = new Converter({ constructResult:false });
var fileStream = fs.createReadStream('large-csv-sample.csv');
csvConverter.on('record_parsed',function(rowObj, rowArray, rowIndex){
var rowId = rowArray[0];
var fileNum = rowArray[1];
importIndex++;
console.log(rowId, importIndex);
@adamanthil
adamanthil / load-json.as
Last active August 29, 2015 14:05
Loads some JSON into a dynamic text field
import flash.events.Event
import flash.net.URLLoader;
import flash.net.URLRequest;
var loader:URLLoader = new URLLoader();
var request:URLRequest = new URLRequest();
request.contentType = "application/json";
request.url="http://jsonip.com/";
loader.load(request);
@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
@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'
@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 / 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);