icantrap

You could always use Smart HTTP.

For read-only (git:) urls, install corkscrew.

1. Download git-proxy.sh. Put it somewhere and make it executable.

2. Run git config --global core.gitproxy '/usr/local/bin/git-proxy.sh'

To clone, push, pull over ssh, add the contents of ssh_config to your ~/.ssh/config file.

repeatingbeats

/**
 * Example structure for nodeunit tests with nested groups and setup/teardown
 * functions. Run | nodeunit nodeunit_example.js | to see a printout of
 * function names in the order that they are called. There aren't any actual
 * tests here.
 */

process.env.NODE_ENV = 'test';

var testCase = require('nodeunit').testCase;

bonyiii

# Function returns user.login, current year, the primary_key which is the id, in 5 length (Example: 00045) 
string format
# http://developer.postgresql.org/pgdocs/postgres/functions-formatting.html
# to_char(5,'00000') results the same number format
CREATE OR REPLACE FUNCTION "public"."function_name" () RETURNS trigger AS
'
BEGIN
    NEW.title = (SELECT login FROM users WHERE id = NEW.author) || to_char(NOW(),\'YYYY\') || lpad(NEW.id::char, 5, \'0\');
    RETURN NEW;
END

springmeyer

/*

wget http://dl.dropbox.com/u/342088/10m-us-parks-area.sqlite

ogr2ogr -f SQLite parks.sqlite ParkPly_900913.shp

dane$ ogr2ogr -f SQLite parks.sqlite ~/Documents/MapBox/cache/2976a0c1-10m-us-parks-area/2976a0c1-10m-us-parks-area.shp

*/

neolitec

var Color = function() {
    this.r = this.g = this.b = 0;
    this.h = this.s = this.l = 0;
    this.a = 1;
};
/** RGB */
Color.prototype.cssRGB = function() {
    return "rgb("+Math.round(255*this.r)+","+Math.round(255*this.g)+","+Math.round(255*this.b)+")";
};
Color.prototype.cssRGBA = function() {

bmcbride

<?php
/**
 * PostGIS to GeoJSON
 * Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
 * 
 * @param 		string		$geotable		The PostGIS layer name *REQUIRED*
 * @param 		string		$geomfield		The PostGIS geometry field *REQUIRED*
 * @param 		string		$srid			The SRID of the returned GeoJSON *OPTIONAL (If omitted, EPSG: 4326 will be used)*
 * @param 		string 		$fields 		Fields to be returned *OPTIONAL (If omitted, all fields will be returned)* NOTE- Uppercase field names should be wrapped in double quotes
 * @param 		string		$parameters		SQL WHERE clause parameters *OPTIONAL*

drawcode

select table_name from user_tab_columns
where table_name = myTable and column_name = myColumn;

mjackson

/**
 * Converts an RGB color value to HSL. Conversion formula
 * adapted from http://en.wikipedia.org/wiki/HSL_color_space.
 * Assumes r, g, and b are contained in the set [0, 255] and
 * returns h, s, and l in the set [0, 1].
 *
 * @param   Number  r       The red color value
 * @param   Number  g       The green color value
 * @param   Number  b       The blue color value
 * @return  Array           The HSL representation

matt-baker

-- SELECT polygon centroid as latitude/longitude in PostGIS
SELECT 
	st_x(st_transform(ST_Centroid(the_geom),4326)) as lat, 
	st_y(st_transform(ST_Centroid(the_geom),4326)) as long

FROM table;

gsainio

#!/usr/public/bin/perl -w

use strict;
use JSON;
use JSON::WebToken;
use LWP::UserAgent;
use HTML::Entities;


my $private_key_string = q[-----BEGIN PRIVATE KEY-----