kjivan

SQL Reference

• For basics on Querying I recommend Become a SELECT star! zine
  • Here are some pages that are public and free
• Databricks Functions
  • Databricks DateTime Functions
  • Databricks DateTime Patterns

Time Formats

Description|ORACLE SQL|Databricks

kjivan

Extract Truststore from secret

kubectl get secret <secret> \
-o json \
| jq --raw-output '. | .data."<trust-store>.jks"' \
| base64 -D > <trust-store>.jks

Patch Secret with TrustStore

Bash

kjivan

Shell Prompt Customization

Pre-built Prompts

• Starship
• Powerlevel10k

Bash

• File ~/.bashrc
• Variable PS1="MyTestPrompt> ”
• Special Variables(eg. path)

kjivan

OpenSSL Reference

Cert Info

Get Sites SSL Info

echo | openssl s_client -showcerts -connect jivan.cc:443

Get Certificate From Site

kjivan

#!/usr/bin/env bash
set -e

# rm file
find . -name 'file.json' -exec rm {} \;

# replace strings in file
sed -i '' 's|find|replace|g' filename

# Remove line from file

kjivan

var d = document.createElement("div");
d.style.position = "sticky";
d.style.top = "0px";
d.style.zIndex = "16777271";
d.style.width = "100%";
d.style.height = "30px";
d.style.padding = "2px";
d.style.fontSize = "20px";
d.style.backgroundColor = "red";
d.style.color = "black";

kjivan

Java Key Tool Reference

Most Useful Commands

List Key Store Certs

keytool -list \
-keystore example.p12

kjivan

#!/usr/bin/env bash
set -e

# https://stackoverflow.com/a/41366949
openssl req -x509 -newkey rsa:4096 -sha256 -days 3650 -nodes \
  -keyout example.key -out example.crt -extensions san -config \
  <(echo "[req]"; 
    echo distinguished_name=req; 
    echo "[san]"; 
    echo subjectAltName=DNS:example.com,DNS:www.example.net,IP:10.0.0.1

kjivan

Keybase proof

I hereby claim:

• I am kjivan on github.
• I am kjivan (https://keybase.io/kjivan) on keybase.
• I have a public key ASARSK9UeYVO5XWN6fEcBK_X4QkEu8Npm67E9tJpdVfekgo

To claim this, I am signing this object: