cihangir

--sql, args := DB.
--    Insect("tab").
--    Columns("b", "c").
--    Values(1, 2).
--    Where("d = $1", 3).
--    Returning("id", "f", "g").
--    ToSQL()

WITH
    sel AS (SELECT id, f, g FROM tab WHERE (d = $1)),

cihangir

nginxVersion="1.9.2"
wget http://nginx.org/download/nginx-$nginxVersion.tar.gz
tar -xzf nginx-$nginxVersion.tar.gz 
ln -sf nginx-$nginxVersion nginx

cd nginx

git clone [email protected]:yaoweibin/nginx_tcp_proxy_module.git
patch -p1 < ./nginx_tcp_proxy_module/tcp.patch

cihangir

    server {
      # just a random port
      listen 81;

      # why we have 2 different if checks? because www redirector block catches
      # all the requests, we should be more precise with the host

      # redirect http://kodingen.com to https://koding.com
      if ($host = "kodingen.com") {
        return 301 https://koding.com;

cihangir

WITH table_scans as (
    SELECT relid,
        tables.idx_scan + tables.seq_scan as all_scans,
        ( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
                pg_relation_size(relid) as table_size
        FROM pg_stat_user_tables as tables
),
all_writes as (
    SELECT sum(writes) as total_writes
    FROM table_scans

cihangir

WITH RECURSIVE numbers(n) AS (
	SELECT 1
	UNION ALL
        SELECT n + 1
        FROM numbers
        WHERE n < 102
) SELECT CASE 
    WHEN n % 3 = 0 AND n % 5 = 0 THEN
            'FizzBuzz'
    WHEN n % 3 = 0 THEN

cihangir

  # redirect www to non-www
  server {
     server_name "~^www.(.*)$" ;
     return 301 $scheme://$1$request_uri ;
  }

cihangir

Keybase proof

I hereby claim:

• I am cihangir on github.
• I am cihangir (https://keybase.io/cihangir) on keybase.
• I have a public key whose fingerprint is 78A4 94A3 25BA 1DD6 35C9 1991 C6B2 BA6E 6276 29F0

To claim this, I am signing this object:

cihangir

   Koding Individual Contributor License Agreement ("Agreement")

In order to clarify the intellectual property license
granted with Contributions from any person or entity, Koding
must have a Contributor License Agreement ("CLA") on file that has
been signed by each Contributor, indicating agreement to the license
terms below. This license is for your protection as a Contributor as
well as the protection of Koding and its users; it does not
change your rights to use your own Contributions for any other purpose.

cihangir

0x08c92d58d2e9e2a8491468f1e0e702dd12bb6981

cihangir

#!/bin/bash

set -euo pipefail

PATHS="./go/src/vendor/golang.org/x/"
REPOS=$(ls $PATHS)

rm -rf ./go/src/golang.org
rm -rf ./go/src/vendor/golang.org