Skip to content

Instantly share code, notes, and snippets.

View deckarts's full-sized avatar

detlef deckarts

View GitHub Profile
@rviscomi
rviscomi / gatsby-cwv.sql
Created September 3, 2020 17:11
Calculating the % of Gatsby websites with "good" Core Web Vitals performance
#standardSQL
# Gatsby Core Web Vitals performance
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
);
@MarkTiedemann
MarkTiedemann / api.js
Last active March 31, 2021 04:13
Latest Deno version API, built using CloudFlare Workers
let last_known_version = "1.2.2";
const api_root = "https://XXX.workers.dev/version/";
const x86_64_apple_darwin = api_root + "x86_64-apple-darwin";
const x86_64_unknown_linux_gnu = api_root + "x86_64-unknown-linux-gnu";
const x86_64_pc_windows_msvc = api_root + "x86_64-pc-windows-msvc";
const re_x86_64_apple_darwin = /href="\/denoland\/deno\/releases\/download\/v(.*?)\/deno-x86_64-apple-darwin.zip"/;
const re_x86_64_unknown_linux_gnu = /href="\/denoland\/deno\/releases\/download\/v(.*?)\/deno-x86_64-unknown-linux-gnu.zip"/;
const re_x86_64_pc_windows_msvc = /href="\/denoland\/deno\/releases\/download\/v(.*?)\/deno-x86_64-pc-windows-msvc.zip"/;
@dsottimano
dsottimano / gist:e3e6294f80cb1cbb526d1defed322850
Last active January 5, 2024 20:01
Tech seo boost 2019 - Dave Sottimano - Apps script demo
//serpApiKey from serpapi.com
var GLOBAL_VARIABLES = {
serpApiKey : "add your api key"
}
/*
/***************************
/BEGIN PRESENTATION SCRIPTS
@ericelliott
ericelliott / gitclean.sh
Created January 31, 2016 04:57
gitclean.sh - cleans merged/stale branches from origin
git remote prune origin
git branch -r --merged master | egrep -iv '(master|develop)' | sed 's/origin\///g' | xargs -n 1 git push --delete origin