jefrydco

  // Available variables:
  // - Machine
  // - interpret
  // - assign
  // - send
  // - sendParent
  // - spawn
  // - raise
  // - actions

jefrydco

#standardSQL
# This query processes 735.9 MB.
# Calculate the percent of origins that comply with each Core Web Vital's "good" threshold for 75% or more of experiences.

CREATE TEMP FUNCTION IS_GOOD (good FLOAT64, needs_improvement FLOAT64, poor FLOAT64) RETURNS BOOL AS (
  good / (good + needs_improvement + poor) >= 0.75
);

CREATE TEMP FUNCTION IS_NON_ZERO (good FLOAT64, needs_improvement FLOAT64, poor FLOAT64) RETURNS BOOL AS (
  good + needs_improvement + poor > 0

jefrydco

#!/bin/bash

# Create postgres directory with pgvolume and pga4volume as child directory.
mkdir -p postgres/{pgvolume,pga4volume}

# Navigate to postgres directory
cd postgres

# Create pg.env that holds environment variable for postgres docker container.
cat << EOF > pg.env

jefrydco

# Serve all resources labeled as `text/html` or `text/plain`
# with the media type `charset` parameter set to `UTF-8`.

AddDefaultCharset utf-8


# Disable the pattern matching based on filenames.

Options -MultiViews