kmatt

podman pull docker.io/library/postrges

podman volume create pg_data

podman run -dt --name postgres \
  -e POSTGRES_PASSWORD=*** \
  --mount type=volume,src=pg_data,target=/var/lib/postgresql/data \
  -p 5432:5432 \
  postgres

kmatt

An opinionated list of excellent Clojure learning materials

These resources (articles, books, and videos) are useful when you're starting to learn the language, or when you're learning a specific part of the language. This an opinionated list, no doubt. I've compiled this list from writing and teaching Clojure over the last 10 years.

• 🔴 Mandatory (for both beginners and intermediates)
• 🟩 For beginners
• 🟨 For intermediates

Table of contents

1. Getting into the language

kmatt

# Alternative to_sql() *method* for mssql+pyodbc or mssql+pymssql
#
# adapted from https://pandas.pydata.org/docs/user_guide/io.html#io-sql-method
import json

import pandas as pd
import sqlalchemy as sa


def mssql_insert_json(table, conn, keys, data_iter):

kmatt

# version 1.2 - 2022-11-01
import pandas as pd
import sqlalchemy as sa


def df_upsert(data_frame, table_name, engine, schema=None, match_columns=None):
    """
    Perform an "upsert" on a SQL Server table from a DataFrame.

    Constructs a T-SQL MERGE statement, uploads the DataFrame to a

kmatt

# On Linux or macOS

export CC="zig cc -target x86_64-windows-gnu
./configure --host x86_64-windows-gnu
make

kmatt

" curl -fLo ~/.vim/autoload/plug.vim --create-dirs https://raw.githubusercontent.com/junegunn/vim-plug/master/plug.vim
  
let g:pymode_python = 'python3'
let g:python3_host_prog = expand('/usr/bin/python3')

call plug#begin()

Plug 'chrisbra/vim-diff-enhanced'
Plug 'cweagans/vim-taskpaper'
Plug 'dsolstad/vim-wombat256i'

kmatt

Create a file:
$ vim /Users/Shared/logoutHook.sh

File content:
#!/bin/bash
say 'Hasta la vista baby!'

Set execution permission:
$ sudo chmod +x /Users/Shared/logoutHook.sh

kmatt

# brew install unixodbc

export CPPFLAGS="-I/opt/homebrew/Cellar/unixodbc/2.3.9_1/include"
export LDFLAGS="-L/opt/homebrew/Cellar/unixodbc/2.3.9_1/lib -liodbc -liodbcinst"
export PKG_CONFIG_PATH="/opt/homebrew/Cellar/unixodbc/2.3.9_1/lib/pkgconfig $PKG_CONFIG_PATH"
pip install --no-binary pyodbc pyodbc

kmatt

# ========= PROMPT =========
# Version control information
autoload -Uz vcs_info
precmd() { vcs_info }
# Format the vcs_info_msg_0_ variable
zstyle ':vcs_info:git:*' formats ' %b '

# Render the prompt
setopt PROMPT_SUBST

kmatt

# Based on https://gist.github.com/kmatt/71603170556ef8ffd14984af77ff10c5
# prompt ">" indicates Powershell commands

# https://docs.microsoft.com/en-us/windows/wsl/install-win10

> dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart
> dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart

# install https://wslstorestorage.blob.core.windows.net/wslblob/wsl_update_x64.msi