zhuomingliang’s gists

zhuomingliang / fork.c

Created January 20, 2019 12:07 — forked from Cr4sh/fork.c

fork() for Windows

	/*
	* fork.c
	* Experimental fork() on Windows. Requires NT 6 subsystem or
	* newer.
	*
	* Copyright (c) 2012 William Pitcock <nenolod@dereferenced.org>
	*
	* Permission to use, copy, modify, and/or distribute this software for any
	* purpose with or without fee is hereby granted, provided that the above
	* copyright notice and this permission notice appear in all copies.

zhuomingliang / gist:e923744cca64acf46fdde787059e3adc

Created December 10, 2018 16:42 — forked from juniorb2ss/gist:1bc2e1fc25c17f7b03262a735d063d3a

Commands to ElasticBeanstalk

	commands:
	00_update_composer:
	command: export HOME=/root && export COMPOSER_HOME=/root && /usr/bin/composer.phar self-update

	option_settings:
	- namespace: aws:elasticbeanstalk:application:environment
	option_name: COMPOSER_HOME
	value: /root
	- namespace: aws:elasticbeanstalk:application:environment
	option_name: HOME

zhuomingliang / postgresql_kmeans.sql

Created November 3, 2018 08:45 — forked from thiagomata/postgresql_kmeans.sql


	/**
	* Based on the mysql cluster
	* @link http://jonisalonen.com/2012/k-means-clustering-in-mysql/
	*/
	-- SELECT
	-- * FROM
	-- unnest(kmeans(array(SELECT
	-- (
	-- lat,

zhuomingliang / example.sql

Created November 1, 2018 10:03 — forked from marcocitus/example.sql

Safe incremental rollups on Postgres and Citus

	-- Create the raw events table
	CREATE TABLE page_views (
	site_id int,
	path text,
	client_ip inet,
	view_time timestamptz default now(),
	view_id bigserial
	);

	-- Allow fast lookups of ranges of sequence IDs

zhuomingliang / gist:c3df9a7a7c63c8848d3c43f6a7435786

Created October 25, 2018 14:13

PLDT Router password

	User Name: admin (Red Arrow) Password: 1234 (Blue Arrow)
	OR
	User Name: adminpldt (Red Arrow) Password: 1234567890 or 0123456789 (Blue Arrow)

zhuomingliang / PostgreSQL Lock View.sql

Last active October 25, 2018 14:07

PostgreSQL Lock View

	-- cannot be a temporary view because other sessions must see it
	DROP VIEW IF EXISTS lockview CASCADE;

	CREATE VIEW lockview AS
	SELECT pid, virtualtransaction AS vxid, locktype AS lock_type,
	mode AS lock_mode, granted,
	CASE
	WHEN virtualxid IS NOT NULL AND transactionid IS NOT NULL
	THEN virtualxid \|\| ' ' \|\| transactionid
	WHEN virtualxid::text IS NOT NULL

zhuomingliang / rfc3161.txt

Created May 8, 2018 13:27 — forked from Manouchehri/rfc3161.txt

List of free rfc3161 servers.

	http://sha256timestamp.ws.symantec.com/sha256/timestamp
	http://timestamp.globalsign.com/scripts/timstamp.dll
	https://timestamp.geotrust.com/tsa
	http://timestamp.verisign.com/scripts/timstamp.dll
	http://timestamp.comodoca.com/rfc3161
	http://timestamp.wosign.com
	http://tsa.startssl.com/rfc3161
	http://time.certum.pl
	http://timestamp.digicert.com
	https://freetsa.org

zhuomingliang / postgres-bdr-setup.md

Created May 4, 2018 20:20 — forked from RafaelMCarvalho/postgres-bdr-setup.md

A PostgreSQL BDR step-by-step Debian setup guide. May become a small post someday.

1. Configure SO locale

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales

zhuomingliang / softether.sh

Created April 7, 2018 08:58 — forked from bouroo/softether.sh

Install softether vpn server on ubuntu 16.04+

	#!/usr/local/env bash
	# Update system
	apt-get update && apt-get -y upgrade

	# Get build tools
	apt-get -y install build-essential wget curl gcc make wget tzdata git libreadline-dev libncurses-dev libssl-dev zlib1g-dev

	# Define softether version
	RTM=$(curl http://www.softether-download.com/files/softether/ \| grep -o 'v[^"]*e' \| grep rtm \| tail -1)
	IFS='-' read -r -a RTMS <<< "${RTM}"

zhuomingliang / postgres_queries_and_commands.sql

Created January 28, 2018 20:06 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'