promolic1

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)

WordPress database clean up queries

Orphan rows
Other

Two way iframe communication

The main difference between the two pages is the method of sending messages. Recieving messages is the same in both.

Parent

Send messages to iframe using iframeEl.contentWindow.postMessage Recieve messages using window.addEventListener('message')

iframe

Authentication in SPAs

Quick role based authentication: http://arthur.gonigberg.com/2013/06/29/angularjs-role-based-auth/
How to do Authorization and Role based permissions in AngularJs: http://nadeemkhedr.wordpress.com/2013/11/25/how-to-do-authorization-and-role-based-permissions-in-angularjs/
Handling Oauth2 with Node.js and Angular.js – Passport to the rescue!: http://www.flashics.com/2013/11/24/handling-oauth2-with-node-js-and-angular-js-passport-to-the-rescue/
Easy Node authentication setup and local: http://scotch.io/tutorials/javascript/easy-node-authentication-setup-and-local

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

	import urlparse
	import argparse
	import redis
	import sys
	from multiprocessing import Pool
	import signal

	def parse_redis_url(s):
	url = urlparse.urlparse(s)
	if not url.scheme:

	// This particular code works with html that looks like this:

	<div class="upload_container" id="photo_number_1">
	<div><input name="upload" class="photo_upload_field" type="file" /></div>
	<div><input type="button" class="upload_photo_submit" value="Upload Photo"></div>
	<p class="center loading hidden"><img src="/assets/loading.gif"></p>
	<script>
	// yes, I know, don't actually put this in a script tag here. It's for illustration purposes only
	$('.upload_photo_submit')[0]).click(function(event){ajaxFileUpload(event);});
	</script>

	ADD RULE with PORT and IPADDRESS
	sudo iptables -A INPUT -p tcp -m tcp --dport port_number -s ip_address -j ACCEPT

	ADD RULE for PORT on all addresses
	sudo iptables -A INPUT -p tcp -m tcp --dport port_number --sport 1024:65535 -j ACCEPT

	DROP IPADRESS
	sudo iptables -I INPUT -s x.x.x.x -j DROP

	VIEW IPTABLES with rule numbers

	#!/usr/bin/env python
	import Image
	from math import sqrt
	import sys

	def creaImg(entrada, salida):
	with open(entrada, 'r') as f:
	datos = f.read()
	bytes_datos = bytearray(datos)
	pixeles = []

	var Twit = require("twit");
	var config = require('./oauthconfig');

	console.log("config:");
	console.log(config);

	var T = new Twit({
	consumer_key: config.consumer_key,
	consumer_secret: config.consumer_secret,
	access_token: config.access_token,