Bob Zoller bobzoller

Redwood Montessori 2016 - Career Day for Computer Programming

A Lego program created by my daughter's preschool class (and transcribed by me).

Howto

Download & Install ACSLogo for Mac OSX
Run the program!

Screenshot

Keybase proof

I hereby claim:

I am bobzoller on github.
I am bobzoller (https://keybase.io/bobzoller) on keybase.
I have a public key whose fingerprint is A905 691E 9AEE BF8A 6F5D F98F 7A31 A43E A910 0301

To claim this, I am signing this object:

We have an issue where Snowflake returns a different value for a column depending on the order of joins and usage of using vs on:

join vendors last, with using

this incorrectly returns product_types.created_at_utc in the place of products.created_at_utc.

query id: ef66f8a8-70b2-44eb-a612-f41afb8b5aa2

snowsql>select products__intermediate.product_id, product_types.created_at_utc as product_type, products__intermediate.created_at_utc as product,
        vendors.created_at_utc as vendor from temp.products__intermediate left join staging.product_types on products__intermediate.product_type

	#!/bin/sh
	#
	# Compiles a static xvfb for the Heroku platform.
	#
	# This script is a conglomeration of:
	# * https://github.com/ddollar/heroku-buildpack-apt
	# * http://stackoverflow.com/questions/14845291/compile-static-linked-binary-of-xvfb
	# * gumption

	set -e # fail fast

	#!/bin/bash
	set -e
	set -o pipefail
	#set -x

	ACCOUNT=prod

	arns=$(aws-vault exec "$ACCOUNT" -- aws ecs list-task-definitions \| jq -r '.taskDefinitionArns \| join("\n")')
	families=$(echo "$arns" \| awk -F '/' '{print $2}' \| awk -F ':' '{print $1}' \| sed '/^[[:space:]]*$/d' \| sort \| uniq)
	for family in $families; do

	#!/usr/bin/env bash

	while read -r dir; do
	echo "$dir"
	cd "$(dirname "$dir")" \|\| exit 1
	origin=$(git remote get-url origin 2>/dev/null)
	if echo "$origin" \| grep -q '^https://github.com/'; then
	repo=$(echo "$origin" \| sed 's#^https://github.com/##')
	echo "fixing $dir $repo"
	git remote set-url origin "git@github.com:$repo"

	require "json"

	STDIN.each_line do \|line\|
	begin
	log = JSON.parse(line).as_h
	time = log.delete "time"
	line = log.to_json
	line = "{\"time\":\"#{time}\",#{line[1..-1]}"
	puts line
	rescue JSON::Error

	unless ARGV.size > 0
	puts " Missing executable file argument"
	puts " Usage (in a Dockerfile)"
	puts " RUN crystal run ./path/to/list-deps.cr -- ./bin/executable"
	exit 1
	end

	executable = File.expand_path(ARGV[0])

	unless File.exists?(executable)

	function downcaseJSONKeys(obj) {
	if (!obj) {
	return;
	}
	if (typeof obj !== 'Object' && typeof obj !== 'object') {
	return;
	}
	var keys = Object.keys(obj);
	var result = {};
	keys.map(function(k, v) {

	/node_modules
	/config.*.json