zdk

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

zdk

Haproxy conditions

Since I keep forgetting them I've put them here.

To form a condition, you can use the following syntax after the rule that it applies to:

<HAProxy action statement> if|unless [!]acl1 <AND|OR|or|'||'> [!]acl2 ...

• if - the condition is TRUE if the result of the ACLs is TRUE.

zdk

[
  {
    "zipCode": "10100",
    "subDistrictList": [
      {
        "subDistrictId": "100801",
        "districtId": "1008",
        "provinceId": "10",
        "subDistrictName": "ป้อมปราบ"
      },

zdk

#!/bin/bash

set -u
set -e

set -o pipefail

export PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

cat <<'EOF' > /etc/modprobe.d/blacklist-ipv6.conf

zdk

Register a droplet in AWS OpsWorks

AWS Requirements

• create a new IAM user and attach the AWS OpsWorks Register Policy
• for testing: create a new stack on AWS OpsWorks and fetch its ID
• customize all variables prefixed with YOUR_ from the cloud-config.yml

DigitalOcean

zdk

yum -y install flex bison openssl-devel rpm-build gcc pam-devel

wget http://mmonit.com/monit/dist/monit-5.14.tar.gz
tar zxvf monit-5.14.tar.gz 
mkdir -p /usr/src/rpm/SOURCES/
cp monit-5.14.tar.gz /usr/src/rpm/SOURCES/monit-5.14.tar.gz
cd monit-5.14
rpmbuild -bb --clean system/packages/redhat/monit.spec
rpm -ivh /usr/src/rpm/RPMS/x86_64/monit-5.14-1.x86_64.rpm

zdk

require 'json'
require 'rash'

@response = <<END
{
    "productHeader": {
        "totalHits": 147
    },
    "products": [{
        "name": "Morgan Sport",

zdk

Deploy Rails 4 app with Dokku on DigitalOcean

Install dokku

First create a Ubuntu 13.04 x64 droplet on DigitalOcean Control Panel

Then ssh with root account, run this in termianl:

$ wget -qO- https://raw.github.com/progrium/dokku/master/bootstrap.sh | sudo bash

zdk

# configuration for osx clipboard support


set-option -g default-command "reattach-to-user-namespace -l sh"