Skip to content

Instantly share code, notes, and snippets.

@virusdave
virusdave / DCSS latest morgue.txt
Last active January 10, 2022 07:57
My current kickass DCSS character
Dungeon Crawl Stone Soup version 0.27.1-34-g3ba077fa99 (console) character file.
Sorcratal the Annihilator (Deep Elf Conjurer) Turns: 206153, Time: 20:04:02
Health: 199/199 AC: 26 Str: 6 XL: 27
Magic: 79/79 EV: 16 Int: 48 God: Vehumet [******]
Gold: 13033 SH: 11 Dex: 17 Spells: 4/80 levels left
rFire + + . SeeInvis + a - +0 staff of Battle
rCold + + + Faith . H - +3 buckler "Jaomnimm" {rElec}
#!/usr/bin/env bash
XL=-2.0;XH=1;YL=-1;YH=1;MI=500;MC=7;X=$COLUMNS;Y=$LINES; for ((y=0;y<$Y;y++)); do for ((x=0;x<$X;x++)); do
R=$(echo "define g(){scale=10;v=x=((${XH}-(${XL}))*${x}/${X}+(${XL}));w=y=-((${YH}-(${YL}))*${y}/${Y}+(${YL}));for(i=1;i<${MI};i++){a=v*v-w*w+x;b=2*v*w+y;v=a;w=b;if(v*v+w*w>4){scale=0;return (${MC}-l(i)*(${MC}-1)/l(${MI}))};};return (0)}g()"|bc -l);echo -n -e "\e[4${R}m \e[0m";done;echo;done

WTF?

TL;DR: I wrote a scala program (Scala 2.12, Bazel 3.2, JDK zulu8) that uses Presto JDBC to connect to a company-internal Presto cluster.

It works fine.

Upgrade some stuff, it stops working. When it works and when it fails takes me MANY

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQCi+GbiMk0UqGYfG+7jmTGaKRtIVTFBwVG0p6kg3l4rsG2S7LCBG9MAgMQQKCfBay1SdXVZvr8wrc7TMj2dk0ZrnQklBd7Cn6hXE3rOiIa+1FFAtXfI4r6gMhzIa91uF63okW09wPYCUxUYmhNSGwC1rTytU5SE1jf5o/Asp/ZfHvmxhm5EUxw5qacS/Ilf4OhEWyQaQG6xeHnO4NCGThIpdTxC2Q9LpQAPlz6lZedEWTTLcXRTcG+olhxfudQ/JMdzQhqluVRCOgolIS32rvKi9st7H3D6q2sZH8MNnbl22FQNHg8f4fl34L1X/n/Zf6573eL0V5uKEtdachwrN+X5FUgwwzn7ivHjAxOHVHuWuADk+HVCG95zN1eyPLbCR8FwF/LtfjfQiF6Erwd3mNdjMK9J1upAfZkix7Ap8UDi2qmK5fzWNXcvFV7bFSo8kRd7ztMRUzHU7iTynRBUGhQel0+S27oMkOrf8yucvEWwf6dq064IleQEjronyweUmLgcSIWrxZJcLohnruleJzSz1MngZ8lsccMNGQys1D1ycayYirMFqBneNnRPtpaqesy9aADvxyzCvp69DogeJEfe++FGGVaKijxRc//EwCqqSyaie+eH1+eVMva+QN3G3yjNgIiNo3ztc60hqQq0sG/K447zHuyr5xFc54fYFv2ZwQ== dave_dot_nicponski@gmail.com
@virusdave
virusdave / chromebook-nix.sh
Last active June 2, 2019 03:42 — forked from puffnfresh/chromebook-nix.sh
Installation script for Nix on ChromeOS
#!/bin/sh
sudo mount -o remount,exec /tmp
# I was unable to get nix 2.2.2 to install successfully on my chromebook.
NIX_VER=2.1.3
NIX_ID=nix-${NIX_VER}-x86_64-linux
NIX_LOC=/usr/local/nixstrap
if [ -x ${NIX_LOC}/proot-x86_64 ] && [ -h ~/.nix-profile ]; then
@virusdave
virusdave / postgres_queries_and_commands.sql
Last active January 27, 2022 21:33 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- CHECK TIMINGS ON ACTIVE AND EXPENSIVE QUERIES
SELECT activity.*
FROM (
SELECT
pid,
CASE WHEN state = 'active' THEN AGE(clock_timestamp(), query_start)
ELSE AGE(state_change, query_start)
END as query_duration, -- This is how long the most recent query was running (or is running so far, if still active)
AGE(clock_timestamp(), xact_start) as xact_duration, -- Same, but for the currently active transaction
CASE WHEN state = 'active' THEN INTERVAL '0'
### Keybase proof
I hereby claim:
* I am virusdave on github.
* I am virus_dave (https://keybase.io/virus_dave) on keybase.
* I have a public key whose fingerprint is 61B6 9419 A26A 393C 4EDA 075B FDB7 5E1A 09F6 04C2
To claim this, I am signing this object: