/why-your-queries-are-wrong-talk

2022 talk given at Columbus Ruby Brigaid

Primary LanguageShell

Why your SQL queries are wrong and what to do about it.

export PG_PASSWORD="password"
export PG_PORT="5437"
# run the database server
docker run -it --rm \
  --publish "$PG_PORT":5432 \
  --env POSTGRES_PASSWORD="$PG_PASSWORD" \
postgres
# get the sample database
curl \
  --location \
  --remote-header-name \
  --remote-name \
https://github.com/robconery/dvdrental/raw/master/dvdrental.tar > dvdrental.tar

# load the sample data
docker run -it --rm \
  --env PGPASSWORD="$PG_PASSWORD" \
  --volume "$PWD":/work \
  --workdir /work \
postgres pg_restore \
  -h host.docker.internal \
  -p "$PG_PORT" \
  -U postgres \
  --verbose \
  --dbname postgres \
  ./dvdrental.tar
# connect to the test database
docker run -it --rm \
  --env PGPASSWORD="$PG_PASSWORD" \
  --volume "$PWD/queries":/queries \
  --workdir /queries \
postgres psql \
  -h host.docker.internal \
  -p "$PG_PORT" \
  -U postgres