kmatt

Using https://github.com/dandavison/delta

~/.gitconfg

[core]
    pager = delta

[interactive]
 diffFilter = delta

kmatt

#!/bin/bash

if [ "$#" -eq 0 ]; then
    echo "Usage: $0 FILENAME | 'WILDCARD' (in single quotes)"
    exit
fi

slug() {
    # Replace non-alpha characters and rename file
    f=$(basename "$1")

kmatt

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

kmatt

# Download all Gists
for i in $(gh gist list -L 1000 | cut -f1); do echo "ID: $i"; gh gist view $i > $i; done

# Rename each file with a slug of the first line / description
for f in *; do mv -v $f $(gawk 'NR==1{gsub(/[^[:alnum:]]/, "-"); gsub(/-+/, "-"); print $0 "_" FILENAME}' $f); done   

kmatt

#
# This shell prompt config file was created by promptline.vim
#
function __promptline_host {
  local only_if_ssh="0"

  if [ $only_if_ssh -eq 0 -o -n "${SSH_CLIENT}" ]; then
    if [[ -n ${ZSH_VERSION-} ]]; then print %m; elif [[ -n ${FISH_VERSION-} ]]; then hostname -s; else printf "%s" \\h; fi
  fi
}

kmatt

(Get-EventLog *).Log | fzf | % { Get-EventLog -LogName $_.Trim() -after (Get-Date).AddDays(-7) } | fzf

kmatt

param ([string]$s, [string[]] $d, [switch]$commit, [switch]$verbose, [string]$path=(Get-Location))

# Install-Module -Name SqlServer -Scope CurrentUser

# Systemd service unit:
#   ExecStart=/usr/bin/pwsh /localdata/SMOSchema/scripter.ps1 -s ALL -commit
#
# Add to $SERVICENAME.service.d/override.conf 
#   [Service]
#   Environment=SQLCMDUSER=

kmatt

def pl_to_sql(df, table, replace=False):
    """
    to_sql() without Pandas
    Appends or overwrites a SQL Server table using data from a DataFrame

    Parameters:
        df (DataFrame): df used to create/append table
        table (str): Name of existing SQL Server table
        replace (bool): Truncate before insert
    Returns:

kmatt

SELECT tbl::TEXT, HASH(tbl::TEXT), MD5(tbl::TEXT) FROM tbl;

D create table tbl as (select 1 as a, 2 as b, 3 as c);
D select tbl::text, hash(tbl::text), md5(tbl::text) from tbl;
┌──────────────────────────┬────────────────────────────┬──────────────────────────────────┐
│   CAST(tbl AS VARCHAR)   │ hash(CAST(tbl AS VARCHAR)) │    md5(CAST(tbl AS VARCHAR))     │
│         varchar          │           uint64           │             varchar              │
├──────────────────────────┼────────────────────────────┼──────────────────────────────────┤
│ {'a': 1, 'b': 2, 'c': 3} │        6764392534128998287 │ e31681d6e7ab078c9679fcd4f50136eb │
└──────────────────────────┴────────────────────────────┴──────────────────────────────────┘

kmatt

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\npp.exe]
@="C:\\Program Files (x86)\\Notepad++\\notepad++.exe"