Skip to content

Instantly share code, notes, and snippets.

View angrytoast's full-sized avatar

Gary Gao angrytoast

18 followers · 2 following
View GitHub Profile
@angrytoast
angrytoast / packages.config
Created December 1, 2015 20:37
{
"bootstrapped": true,
"in_process_packages":
[
],
"installed_packages":
[
"Alignment",
"Base16 Color Schemes",
"Better CoffeeScript",
@angrytoast
angrytoast / nginx.conf
Created December 18, 2015 22:34
worker_processes 4;
error_log /usr/local/etc/nginx/logs/error.log debug;
events {
worker_connections 1024;
}
http {
include mime.types;
@angrytoast
angrytoast / Gemfile.lock
Created December 23, 2015 22:15
GEM
remote: https://rubygems.org/
specs:
addressable (2.3.5)
breakpoint (2.0.5)
compass (>= 0.12.1)
sass (>= 3.2.0)
celluloid (0.15.2)
timers (~> 1.1.0)
chunky_png (1.2.8)
@angrytoast
angrytoast / gist:de5bed83974beeccb0c0
Created December 24, 2015 00:12
*** LOCAL GEMS ***
addressable (2.3.8, 2.3.6, 2.3.4)
bigdecimal (1.2.0)
breakpoint (2.5.0, 2.0.5)
bundler (1.10.6)
celluloid (0.16.0)
CFPropertyList (2.2.8)
chunky_png (1.3.4, 1.3.3, 1.2.8)
coderay (1.1.0, 1.0.9)
@angrytoast
angrytoast / gist:7c386ffe6392c85944eb
Created February 3, 2016 19:20
{
"alignment_chars":
[
"=",
":"
],
"alignment_space_chars":
[
"=",
":"
@angrytoast
angrytoast / PR template bookmarklet.js
Created February 3, 2016 23:09
javascript:(function() {jQuery.get('https://github.com/tableau-mkt/www7/wiki/Style-Guide-for-Commits,-Issues,-and-PRs').done(function(data) {var prText = jQuery(data).find('#user-content-pull-requests').parent().nextAll('pre').eq(0).text();var e = jQuery('[id^=pull_request_body]');if (e.length) {e.val(prText)} });})();
@angrytoast
angrytoast / nginx.conf
Created February 18, 2016 17:58
worker_processes 4;
error_log /usr/local/etc/nginx/logs/error.log debug;
events {
worker_connections 1024;
}
http {
include mime.types;
@angrytoast
angrytoast / tableau.pre.html
Created April 23, 2016 00:15
<!DOCTYPE html>
<!--[if IEMobile 7]><html class="no-js ie iem7" lang="en" dir="ltr"><![endif]-->
<!--[if lte IE 6]><html class="no-js ie lt-ie9 lt-ie8 lt-ie7" lang="en" dir="ltr"><![endif]-->
<!--[if (IE 7)&(!IEMobile)]><html class="no-js ie lt-ie9 lt-ie8" lang="en" dir="ltr"><![endif]-->
<!--[if IE 8]><html class="no-js ie ie8 lt-ie9 lt-ie10 lt-ie11" lang="en" dir="ltr"><![endif]-->
<!--[if IE 9]><html class="no-js ie ie9 lt-ie10 lt-ie11" lang="en" dir="ltr"><![endif]-->
<!--[if IE 10]><html class="no-js ie ie10 lt-ie11" lang="en" dir="ltr"><![endif]-->
<!--[if (gt IE 10)|(gt IEMobile 7)]><html class="no-js ie" lang="en" dir="ltr" prefix="fb: http://ogp.me/ns/fb# content: http://purl.org/rss/1.0/modules/content/ dc: http://purl.org/dc/terms/ foaf: http://xmlns.com/foaf/0.1/ og: http://ogp.me/ns# rdfs: http://www.w3.org/2000/01/rdf-schema# sioc: http://rdfs.org/sioc/ns# sioct: http://rdfs.org/sioc/types# skos: http://www.w3.org/2004/02/skos/core# xsd: http://www.w3.org/2001/XMLSchema# schema: h
@angrytoast
angrytoast / indianish-recipes.md
Last active December 9, 2019 21:18

Jess Anand's Chickpea Curry

Ingredients

  • Vegetable oil to cover pan
  • 1 Onion, chopped
  • 1 TSP whole cumin
  • 1/2 TSP whole cloves
  • 2 TSP dried coriander, ground
  • 1/2 TSP cinnamon, ground
  • 1/2 TSP nutmeg, ground
@angrytoast
angrytoast / results.md
Last active December 10, 2016 04:31
Results

Query

EXPLAIN SELECT DISTINCT field_revision_field_sections.entity_type AS entity_type, field_revision_field_sections.entity_id AS entity_id, field_revision_field_sections.revision_id AS revision_id, field_revision_field_sections.bundle AS bundle FROM field_revision_field_sections field_revision_field_sections WHERE  (field_revision_field_sections.field_sections_revision_id = '251315') AND (field_revision_field_sections.deleted = '0') AND(( ( EXISTS  (SELECT na.nid AS nid FROM node_access na WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (field_revision_field_sections.entity_id = na.nid) )) AND (field_revision_field_sections.entity_type = 'node') )OR (field_revision_field_sections.entity_type <> 'node') );

Before

+------+--------------+-------------------------------+------+-----------------------------+---------+---------+-------+--------+-----------------------------------------------------+
| id