alexhwoods

create table teams (
  id uuid primary key default gen_random_uuid(),
  name text not null,
  city text not null
);

create table players (
  id uuid primary key default gen_random_uuid(),
  team_id uuid references teams(id),
  name text,

alexhwoods

Route *.localhost traffic to localhost

Inspired and adjusted from this gist.

1. Install dnsmasq

brew install dnsmasq

2. Setup

alexhwoods

function auth0Url(tenant: string, userId: string) {
  const userIdInUrl = btoa(encodeURIComponent(userId))
  return `https://manage.auth0.com/dashboard/us/${tenant}/users/${userIdInUrl}`
}

auth0Url("foo-development", "auth0|1234")

alexhwoods

1. Download the Confluent Platform.
2. Decompress the downloaded file, and move the confluent-x.y.z (where x.y.z is the major.minor.patch version) to your $HOME directory
3. Add the following line your .bashrc or .zshrc

export PATH="${HOME}/confluent-x.y.z/bin:${PATH}"

alexhwoods

mysql -h <host-name> -D <database-name> -u <username> --password=<password> -e "SELECT 1;" | tr '\t' ',' >> output.csv

alexhwoods

Issue

You're trying to use Kafka Connect, using the Debezium to Postgres, and your Postgres database is running on Aiven. You have pgoutput selected as the plugin name (this is the best choice).

You're getting this error: Caused by: org.postgresql.util.PSQLException: ERROR: must be superuser to create FOR ALL TABLES publication.

Why This is Happening

Aiven doesn't allow you to have a superuser. Debezium tries to create a publication, and fails, because it's not using a superuser.

alexhwoods

docker kill $(docker ps -q)

alexhwoods

restart() {
    if [[ $@ == "wifi" ]]; then
        command networksetup -setairportpower en0 off
	    command networksetup -setairportpower en0 on
	else
        command echo not yet defined
    fi
}

alexhwoods

const AWS = require('aws-sdk')

AWS.config.update({
  accessKeyId: "access-key",
  secretAccessKey: "secret-access-key"
});

new AWS.S3().putObject(
  {
    Bucket: "bucket-name",

alexhwoods

const util = require('util')

module.exports = (obj) => util.inspect(obj, { showHidden: false, depth: null })