Viaceslavas Duk firebotQL

Exposed headers

Service	SSL	status	Response Type	Allowed methods	Allowed headers

Redshift Tables Used

pg_table_def, stl_query, stl_querytext, stl_tr_conflict, stl_explain, stl_alert_event_log, stl_ddltext, stl_scan, stl_save, stl_hashjoin, stl_hash, stl_plan_info, stl_return, and information_schema.table_constraints.

Queries to Extract Features

execution time

select (endtime - starttime) as execution_time_in_ms 
from stl_query 
where query = QUERY_ID;

Google Calendar notifications

Create a Gmail filter that will find all Google Calendar-related emails. I use it to apply a label to the emails so I can go and bulk delete them later.

(("invitation" OR "updated invitation" OR "declined" OR "canceled event") AND (-collaborate OR -"invitation to edit")) AND (has:attachment)

Notes

OUTDATED, see comments below

Install Homebrew:

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Update Homebrew formulae:

brew update

First verify the version of Java being used is not Sun Java 8 SDK

java -version

Check the latest version a build numbers in http://www.oracle.com/technetwork/java/javase/downloads/index.html

For url http://download.oracle.com/otn-pub/java/jdk/8u91-b14/jdk-8u91-linux-x64.tar.gz, the variables should be defined as:

java_base_version="8"
java_sub_version="11"

ANNOUNCEMENT

I have moved this over to the Tech Interview Cheat Sheet Repo and has been expanded and even has code challenges you can run and practice against!

\



	All possible locales:

	en-IE = €1,205.34
	ro-MD = 1.205,34 MDL
	br = ¤ 1 205,34
	en-GY = $1,205
	es-GT = Q1,205.34
	shi-Tfng-M = 1 205,34MAD

	/*
	After purchasing a humble book bundle, go to your download page for that bundle.
	Open a console window for the page and paste in the below javascript
	*/
	$('a').each(function(i){
	if ($.trim($(this).text()) == 'MOBI') {
	$('body').append('<iframe id="dl_iframe_'+i+'" style="display:none;">');
	document.getElementById('dl_iframe_'+i).src = $(this).data('web');
	}
	});

	#!/usr/bin/env python

	import json
	import os
	import requests
	import time

	debug = False
	debug_path = 'debug'

	// a list of useful queries for profiler analysis. Starting with the most basic.
	// 2.4 compatible
	//

	// output explained:
	//
	{
	"ts" : ISODate("2012-09-14T16:34:00.010Z"), // date it occurred
	"op" : "query", // the operation type
	"ns" : "game.players", // the db and collection