newhouseb

The basic idea here is to substantiate the claims made by this square post:
http://corner.squareup.com/2011/06/postgresql-data-is-important.html

In PostgreSQL, and MySQL (MyISAM and InnoDB) I create millions of rows and then add 
and remove columns and add and remove indexes.  For columns without defaults this is
basically free in PostgreSQL and O(n) in MySQL.  For adding indexes its at best O(n) 
everywhere, but with PostgreSQL it claims not to do any locking that would otherwise
prevent table interaction.

Also, PostgreSQL has _awsome_ documentation (it has real examples!). I always get 

xeoncross

<?php
/*
This is a very tiny proof-of-concept SMTP client. Currently it's over 320 characters (if the var names are compressed). Think you can build one smaller?
*/

ini_set('default_socket_timeout', 3);

$user = '[email protected]';
$pass = '';
$host = 'ssl://smtp.gmail.com';

snaga

#!/bin/sh

# alternatives-pgsql
#
# Switch postgresql version for all the commands with using alternatives.
#
# Copyright(C) 2012 Uptime Technologies, LLC. All rights reserved.

PATH=/usr/sbin:$PATH
export PATH

return1

#
# UPDATE for 10.10.4+: please consider this patch obsolete, as apple provides a tool called "trimforce" to enable trim support for 3rd party SSDs
# just run "sudo trimforce enable" to activate the trim support from now on!
#
# Original version by Grant Parnell is offline (http://digitaldj.net/2011/07/21/trim-enabler-for-lion/)
# Update July 2014: no longer offline, see https://digitaldj.net/blog/2011/11/17/trim-enabler-for-os-x-lion-mountain-lion-mavericks/
#
# Looks for "Apple" string in HD kext, changes it to a wildcard match for anything
#
# Alternative to http://www.groths.org/trim-enabler-3-0-released/

extraordinaire

<?php
class ReconnectingPDO
{
    protected $dsn, $username, $password, $pdo, $driver_options;
    
    public function __construct($dsn, $username = "", $password = "", $driver_options = array())
    {
        $this->dsn = $dsn;
        $this->username = $username;
        $this->password = $password;

JagoWang

Mac Port 基本用法总结 

1. Mac Port的下载地址 
http://www.macports.org/install.php 

2. Mac Port的说明文档 
http://guide.macports.org/ 

3. Mac Port中第三方软件下载包存放的默认路径是：/opt/local/var/macports/distfiles/ 
为了提高安装速度，可以在安装新port时直接将此目录下的文件拷贝到新的Mac Port相同的目录中就可以避免Port去网上下载。 

jaxbot

location ~ /\.git {
  deny all;
}

# or, all . directories/files in general (including .htaccess, etc)

location ~ /\. {
  deny all;
}

dashohoxha

#!/bin/bash
### Setup a wifi Access Point on Ubuntu 12.04 (or its derivatives).

### make sure that this script is executed from root
if [ $(whoami) != 'root' ]
then
    echo "
This script should be executed as root or with sudo:
    sudo $0
"

chrisboulton

-- a quick LUA access script for nginx to check IP addresses against an
-- `ip_blacklist` set in Redis, and if a match is found send a HTTP 403.
--
-- allows for a common blacklist to be shared between a bunch of nginx
-- web servers using a remote redis instance. lookups are cached for a
-- configurable period of time.
--
-- block an ip:
--   redis-cli SADD ip_blacklist 10.1.1.1
-- remove an ip:

andrewmackrodt

@echo off
echo.

:: set the local (dynamic) port for the Socks5 proxy
set lport=3128

:: ssh details
set rport=22
set username=andrew
set hostname=myproxy.tld