alysonla

-- Active issues
-- Count of total active issues in the specified time frame
-- Source: githubarchive public data set via Google BigQuery http://githubarchive.org/

SELECT
	COUNT(DISTINCT JSON_EXTRACT_SCALAR(events.payload, '$.issue.id')) AS events_issue_count
FROM (SELECT * FROM TABLE_DATE_RANGE([githubarchive:day.],TIMESTAMP('2015-09-01'),TIMESTAMP('2016-08-31')))
 AS events

-- 10,723,492 active issues

chrsgrffth

# To get the `action` prop:
#
# 1. Go to your dashboard on mailchimp.com and navigate 
#    to Lists > Signup Forms > Embedded Forms.
#
# 2. Copy the `<form>` action from the generated HTML code.
#
# 3. Pass that into the component via the prop, like so:
#
#      <mailchimp-subscribe 

cliffano

variable "bucket_site" {}
variable "region" {}
variable "route53_domain_name" {}
variable "route53_domain_zoneid" {}
variable "route53_domain_alias_name" {}
variable "route53_domain_alias_zoneid" {}

provider "aws" {
    region = "${var.region}"
}

arfon

How many times shouldn't it happen...

-- https://news.ycombinator.com/item?id=11396045

SELECT count(*)
FROM (SELECT id, repo_name, path
        FROM [bigquery-public-data:github_repos.sample_files]
 ) AS F

evantoli

Configure Git to use a proxy

In Brief

You may need to configure a proxy server if you're having trouble cloning or fetching from a remote repository or getting an error like unable to access '...' Couldn't resolve host '...'.

Consider something like:

byrnedo

#!/bin/bash
set -euo pipefail

function useDockerEnv {
    eval "$(docker-machine env $1)"
}


function getIfaceIP {
    local machine="$1"

robinheghan

module Main where

import Signal


type alias Message =
    { operation : String
    , message : String
    }

OlegIlyenko

In this gist I would like to describe an idea for GraphQL subscriptions. It was inspired by conversations about subscriptions in the GraphQL slack channel and different GH issues, like #89 and #411.

Conceptual Model

At the moment GraphQL allows 2 types of queries:

• query
• mutation

Reference implementation also adds the third type: subscription. It does not have any semantics yet, so here I would like to propose one possible semantics interpretation and the reasoning behind it.

subfuzion

Docker quick start for Node.js developers

Install Dependencies

Install Docker Toolbox

For Mac and Windows users, just install Docker Toolbox. It provides what you need to get started, including:

oyvindholmstad

/*	
	A script to generate a Google BigQuery-complient JSON-schema from a JSON object.
	
	Make sure the JSON object is complete before generating, null values will be skipped.
	
	References:
	https://cloud.google.com/bigquery/docs/data
	https://cloud.google.com/bigquery/docs/personsDataSchema.json
	https://gist.github.com/igrigorik/83334277835625916cd6
	... and a couple of visits to StackOverflow