Rakhmad Azhari rakhmad

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Easy parallel python with concurrent.futures

As of version 3.3, python includes the very promising concurrent.futures module, with elegant context managers for running tasks concurrently. Thanks to the simple and consistent interface you can use both threads and processes with minimal effort.

For most CPU bound tasks - anything that is heavy number crunching - you want your program to use all the CPUs in your PC. The simplest way to get a CPU bound task to run in parallel is to use the ProcessPoolExecutor, which will create enough sub-processes to keep all your CPUs busy.

We use the context manager thusly:

with concurrent.futures.ProcessPoolExecutor() as executor:

patch-edid.rb

A script to fix EDID problems on external monitors in macOS.

Instructions

Connect only the problem display.
Create this directory structure (if it doesn't already exist):

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

	#!/usr/bin/env python3
	'''

	This Script Is Mainly From A Youtube User,
	I Only Modified It Slightly To Make It Python3 Compatable,
	And Added Custom Microphone Recording Support
	Original Source Code: http://pastebin.com/BY1t5AcC
	Thanks To Youtube User NoBeansJose

	License:

	# Try running this in http://coffeescript.org 's "Try CoffeeScript" tab while having the DevTools console open.
	class Foo
	thin: (arg) ->
	console.log 'thin', this, @value?(), arg

	fat: (arg) =>
	console.log 'fat', this, @value?(), arg

	value: ->
	'foobar'

	public class BatteryActivity extends Activity {

	//UI Elements
	private TextView mTextViewLevel;
	private TextView mTextViewTemperature;
	private TextView mTextViewVoltage;
	private TextView mTextViewHealth;

	//Battery details
	private int level;

	package main

	import (
	"net/http"
	"database/sql"
	"fmt"
	"log"
	"os"
	)

	require 'rubygems'
	require 'openssl'
	require 'digest/md5'
	key = OpenSSL::PKey::RSA.new(2048)
	cipher = OpenSSL::Cipher::AES.new(256, :CBC)
	ctx = OpenSSL::SSL::SSLContext.new
	puts "Spoof must be in DER format and saved as root.cer"
	raw = File.read "root.cer"
	cert = OpenSSL::X509::Certificate.new raw
	cert.version = 2

	// Just before switching jobs:
	// Add one of these.
	// Preferably into the same commit where you do a large merge.
	//
	// This started as a tweet with a joke of "C++ pro-tip: #define private public",
	// and then it quickly escalated into more and more evil suggestions.
	// I've tried to capture interesting suggestions here.
	//
	// Contributors: @r2d2rigo, @joeldevahl, @msinilo, @_Humus_,
	// @YuriyODonnell, @rygorous, @cmuratori, @mike_acton, @grumpygiant,