SQL Bootstrap

Calculate bootstrap confidence intervals in mostly standard SQL, for PostgreSQL and BigQuery.

Companion repo for this blog post.

Notes

Usage

First generate the example data, then run the calculations.

make example-data
make

Local Postgres

postgres -D /usr/local/var/postgres
psql

Cloud SQL Postgres

make cloud-sql-instance
make cloud-sql-proxy
PSQL="psql postgres://postgres:$CLOUD_SQL_PGPASSWORD@localhost:5432" make pg-test benchmark-pg.csv

BigQuery

gcloud config configurations activate ...
gcloud config set project ...