kenaniah

<?php
$reader = fopen("file.csv", "r");
$headers = null;
while($row = fgetcsv($reader)):

	if(!$headers):
		foreach($row as $k => $v) $row[$k] = trim(preg_replace("/\s+/", " ", $v));
		$headers = $row;
		continue;
	endif;

kenaniah

<?php
/**
 * Database abstraction and query result classes (requires PHP 5.3)
 *
 * This class is built primarily for PostgreSQL 8.4+
 * Compatibility with other database types is not guaranteed
 *
 * @author Kenaniah Cerny <kenaniah@gmail.com>
 * @version 1.2.0
 * @license http://creativecommons.org/licenses/by-sa/3.0/

kenaniah

<?php
/**
 * Simple, scoped template rendering engine
 *
 * Variables may be passed to templates by setting dynamic
 * properties of this class or by passing them at call time.
 *
 * @author Kenaniah Cerny <kenaniah@gmail.com> https://github.com/kenaniah/insight
 * @license http://creativecommons.org/licenses/by-sa/3.0/
 * @copyright Copyright (c) 2009, Kenaniah Cerny

kenaniah

#!/bin/bash

# Lock file script written to ensure only once process at a time holds a lock
# Automatically kills zombie processes past the threshold
# https://gist.github.com/1350609

if [ $# -ne 3 ]; then
        echo "Usage: `basename $0` <lockfile> <timeout> <command>";
        exit 2;
fi

kenaniah

CREATE OR REPLACE FUNCTION public.hstore2json (
  hs public.hstore
)
RETURNS text AS
$body$
DECLARE
  rv text;
  r record;
BEGIN
  rv:='';