Mike Slattery slattery

A quick visual reference to every ColorBrewer scale; colors by Cynthia Brewer. Available in CSS and JS format. Click on a palette to log the constituent colors in hexadecimal RGB to the console.

just change out app_name for your purposes

openssl genrsa 2048 > app_name-wildcard.key

openssl req -new -x509 -nodes -sha1 -days 3650 -key app_name-wildcard.key > app_name-wildcard.cert

# Common Name (eg, your name or your server's hostname) []:*.app_name.com

openssl x509 -noout -fingerprint -text &lt; app_name-wildcard.cert &gt; app_name-wildcard.info

Some thoughts on using node-postgres in a web application

This is the approach I've been using for the past year or so. I'm sure I'll change and it will change as I grow & am exposed to more ideas, but it's worked alright for me so far.

Pooling:

I would definitely use a single pool of clients throughout the application. node-postgres ships with a pool implementation that has always met my needs, but it's also fine to just use the require('pg').Client prototype and implement your own pool if you know what you're doing & have some custom requirements on the pool.

	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
	<style type="text/css">

	body {
	margin: 40px;
	font: 14px Helvetica Neue;
	}

	var fs = require("fs")
	var ssl_options = {
	key: fs.readFileSync('privatekey.pem'),
	cert: fs.readFileSync('certificate.pem')
	};

	var port = process.env.PORT \|\| 3000;
	var express = require('express');
	var ejs = require('ejs');
	var passport = require('passport')

	$scope.safeApply = function(fn) {
	var phase = this.$root.$$phase;
	if(phase == '$apply' \|\| phase == '$digest')
	this.$eval(fn);
	else
	this.$apply(fn);
	};

	// OR

	CREATE OR REPLACE FUNCTION cut_nicely(my_string VARCHAR, my_length INTEGER) RETURNS varchar AS $$
	DECLARE
	my_pointer INTEGER;
	BEGIN
	my_pointer := my_length;
	WHILE my_pointer < length(my_string) AND transliterate(substr(my_string, my_pointer, 1)) ~* '[a-z]' LOOP
	my_pointer := my_pointer + 1;
	END LOOP;

	RETURN substr(my_string, 1, my_pointer);

	-- PostgreSQL 9.2 beta (for the new JSON datatype)
	-- You can actually use an earlier version and a TEXT type too
	-- PL/V8 http://code.google.com/p/plv8js/wiki/PLV8

	-- Inspired by
	-- http://people.planetpostgresql.org/andrew/index.php?/archives/249-Using-PLV8-to-index-JSON.html
	-- http://ssql-pgaustin.herokuapp.com/#1

	-- JSON Types need to be mapped into corresponding PG types
	--

	-- Function: json_path(json, text)

	-- DROP FUNCTION json_path(json, text);

	CREATE OR REPLACE FUNCTION json_path(data json, path text)
	RETURNS text AS
	$BODY$
	/* JSONPath 0.8.0 - XPath for JSON
	*
	* Copyright (c) 2007 Stefan Goessner (goessner.net)

	# Editor backup files
	*.bak
	*~