schacon

// first, grab a list of the field names in a table

SELECT STRING_AGG(column_name, ", \n" ORDER BY ordinal_position)
FROM [project_name].[dataset_name].INFORMATION_SCHEMA.COLUMNS
where table_name = 'blah'
group by table_name

schacon

version: '3'
services:
  app:
    build:
      context: ..
      dockerfile: .devcontainer/Dockerfile
      args:
        VARIANT: 2.6
        NODE_VERSION: "lts/*"
    volumes:

schacon

select month, months_out from (
    select month,
        GENERATE_ARRAY(0, DATE_DIFF(CURRENT_DATE(), month, MONTH)) as months,
    from UNNEST(
        (select 
            GENERATE_DATE_ARRAY(CAST([STARTING_DATE] AS DATE), CAST(max(date_field) AS DATE), 
                INTERVAL 1 MONTH) as date
        from [SOME_TABLE_WITH_A_DATE_FIELD])
    ) as month
) CROSS JOIN UNNEST(months) as months_out

schacon

Keybase proof

I hereby claim:

• I am schacon on github.
• I am scottchacon (https://keybase.io/scottchacon) on keybase.
• I have a public key ASAcTJsFnTw59Ncpg1Bax0VQ1yH1B3N2MQaDHsadrT95aAo

To claim this, I am signing this object:

schacon

#! /usr/bin/env ruby
require 'rubygems'
require 'oily_png'

Dir.glob("book/**/*.png").each do |file|
  puts file
  image = ChunkyPNG::Image.from_file(file)
  p image.width
  p image.height
  if image.width > 800 || image.height > 800

schacon

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

schacon

dfg

schacon

HTTP transfer protocols
=======================

Git supports two HTTP based transfer protocols.  A "dumb" protocol
which requires only a standard HTTP server on the server end of the
connection, and a "smart" protocol which requires a Git aware CGI
(or server module).  This document describes both protocols.

As a design feature smart clients can automatically upgrade "dumb"
protocol URLs to smart URLs.  This permits all users to have the

schacon

Welcome to the second annual Personal Democracy Forum. It’s great to see so many familiar faces from last year’s forum, and to greet so many new folks who are here. It seems our blog-ads on Jeff Gannon’s website paid off.

We’re putting on our conference today in cooperation with the Continuing Education and Public Programs at the Graduate Center of the City University of New York. Thank you David Levine and your whole staff here at CUNY, you’ve been fantastic.

I also want to take a moment to thank the terrific and talented PDF staff for putting together a program interesting and provocative enough to get a room full of techies to put down their Berries and Treos for the better part of a day: Hart Hooton, Dawn Barber, Jen Vento, Isabel Walcott, and our executive editor, Micah Sifry. In particular, I’d like to single out Anthony Russomano and Elizabeth Caputo for their tireless efforts to make today a success

And a special thanks to our distinguished group of sponsors: Google, Burson-Marsteller, Echoditto, E

schacon

Mirror/unmirror displays: ⌘-F1 or ⌘-fn-1

Switch presenter display: x