purcell

COPY (
WITH
  -- Read the raw log line by line by abusing CSV parser
  raw_log AS (
    FROM read_csv_auto('/tmp/log/access.log-20230904.gz', header=false, delim='\0')
)
, combined_log AS ( 
    SELECT regexp_extract(column0
                         , '^(\S+) (\S+) (\S+) \[(.*?)\] "([A-Z]+?) (.*?) HTTP/(.*?)" (\d+) (\d+) "(.*?)" "(.*?)"$'
                         , [ 'ip', 'identity', 'userid', 'timestamp', 'method'

purcell

#!/bin/bash -e

error_exit() {
    echo "$@" >&2
    exit 1
}

usage_exit() {
    cat <<EOF >&2
Allows you to run a local postgres command, e.g. psql or pg_dump,

purcell

#!/bin/bash -e

error_exit() {
    echo "$1" >&2
    exit 1
}

usage_exit() {
    cat <<EOF >&2
Looks up your AWS keys from your 1Password and exports them before running the next command

purcell

• 2023
• 2022
• 2021 - skipped
• 2020
• 2019
• 2018
• 2017
• 2016
• 2015

purcell

@nix { "action": "setPhase", "phase": "unpackPhase" }
unpacking sources
unpacking source archive /nix/store/8lsf1rrc5d3cgn2i1as76l2k3yr16k9r-ocaml-5.0.0.tar.xz
source root is ocaml-5.0.0
setting SOURCE_DATE_EPOCH to timestamp 1671176928 of file ocaml-5.0.0/yacc/wstr.c
@nix { "action": "setPhase", "phase": "patchPhase" }
patching sources
@nix { "action": "setPhase", "phase": "updateAutotoolsGnuConfigScriptsPhase" }
updateAutotoolsGnuConfigScriptsPhase
Updating Autotools / GNU config script to a newer upstream version: ./build-aux/config.sub

purcell

Keybase proof

I hereby claim:

• I am purcell on github.
• I am sanityinc (https://keybase.io/sanityinc) on keybase.
• I have a public key ASD6Zb31etK_0lSccFnXOXQKEk2S1137StrRR5dfWAn4Jgo

To claim this, I am signing this object:

purcell

From 96f7801fd773242cb584d68415b6c72b7db1e123 Mon Sep 17 00:00:00 2001
From: Steve Purcell <steve@sanityinc.com>
Date: Tue, 11 May 2021 15:10:45 +1200
Subject: [PATCH] Use upstreamed poetry2nix overrides for hid and pyusb

---
 nix/sources.json | 12 ++++++++++++
 shell.nix        | 32 +++++---------------------------
 2 files changed, 17 insertions(+), 27 deletions(-)

purcell

let
  # Assumes niv sources, which should include the repos for
  # nimlsp, ast-pattern-matching and jsonschema.
  sources = import ./nix/sources.nix;
  pkgs = import sources.nixpkgs {};

  unpackedSource = d: d.overrideAttrs (orig: {
    name = "${orig.pname}-source";
    phases = ["unpackPhase" "patchPhase" "installPhase"];
    installPhase = "mkdir $out; cp -aR . $out/.";

purcell

{-# LANGUAGE BangPatterns #-}
{-# LANGUAGE DataKinds #-}
{-# LANGUAGE DeriveDataTypeable #-}
{-# LANGUAGE DeriveGeneric #-}
{-# LANGUAGE FlexibleInstances #-}
{-# LANGUAGE GeneralizedNewtypeDeriving #-}
{-# LANGUAGE KindSignatures #-}
{-# LANGUAGE MultiParamTypeClasses #-}
{-# LANGUAGE OverloadedStrings #-}
{-# LANGUAGE RankNTypes #-}

purcell

    (defvar-local flycheck-eglot-current-errors nil)

    (defun flycheck-eglot-report-fn (diags &rest _)
      (setq flycheck-eglot-current-errors
            (mapcar (lambda (diag)
                      (save-excursion
                        (goto-char (flymake--diag-beg diag))
                        (flycheck-error-new-at (line-number-at-pos)
                                               (1+ (- (point) (line-beginning-position)))
                                               (pcase (flymake--diag-type diag)