Lucius Humm lulezi

Drizzle ORM PostgreSQL Best Practices Guide (2025)

Latest Drizzle ORM features and optimal schema patterns

Major 2025 Update: PostgreSQL now recommends identity columns over serial types. Drizzle has fully embraced this change.

import { pgTable, integer, text, timestamp, varchar } from 'drizzle-orm/pg-core';

Setting up Time Machine Backups Using Proxmox (v8.2) and Ubuntu (24.04)

This guide assumes you already have a basic Ubuntu 24.04 VM running on Proxmox. If not, you should set that up first. The VM can be fairly minimal; for example, 8GB of storage and 1GB of RAM should suffice.

It also assumes you have a USB Storage device that you want to use for Time Machine backups

Mapping a USB Drive to the Ubuntu VM Using Virtio in Proxmox

Mapping a USB drive via the Proxmox GUI is quick and easy, but the performance may be suboptimal because the driver is emulated. For better performance, it's recommended to use the virtio driver, which is paravirtualized. Paravirtualization allows the guest VM to interact more directly with the hardware, improving I/O performance compared to emulated devices.

🚀 GNU Parallel Mastery: The Ultimate Cheat Sheet

📊 Basic Usage

Command	Description	Example
`parallel echo ::: A B C`	🔤 Process items in parallel	Output: A, B, C (in any order)
`parallel echo {} ::: *.txt`	🔍 Use {} as placeholder	Echoes names of all .txt files
`cat file.txt \| parallel echo`	📥 Read input from stdin	Processes each line of file.txt
`parallel -j4 command ::: item1 item2 item3`	🔢 Limit to 4 jobs at a time	Runs 'command' on items, max 4 parallel

logmojis

A collection of useful emojis for logging and debugging. Cheerio 🙃.

status


✔️	success, done
❌	failure, error

git commit stats

Commands to get commit statistics for a Git repository from the command line -
using git log, git shortlog and friends.

Install
Shell exports
Directory explanations
Automatic Imports
Private repo access
Guard (automatic go run)
Godo
Spurious
AWS SDK with Go (inc. some old possibly broken examples)
Build and Compilation

	# The initial version
	if [ ! -f .env ]
	then
	export $(cat .env \| xargs)
	fi

	# My favorite from the comments. Thanks @richarddewit & others!
	set -a && source .env && set +a

	#!/usr/bin/env bash

	# This is based on this excellent gist https://gist.github.com/jvenator/9672772a631c117da151
	# Nothing of this is my original work, except that I made the download link an argument
	# to this script, so it installs on OSX 10.11
	#
	# Thank you jvenator & sethetter
	set -e

	error() { info "$1"; exit 1; }

	# block content
	location ~ ^/content/(.*).(txt\|md\|mdown)$ {
	rewrite ^/content/(.*).(txt\|md\|mdown)$ /error redirect;
	}

	# block all files in the site folder from being accessed directly
	location ~ ^/site/(.*)$ {
	rewrite ^/site/(.*)$ /error redirect;
	}