Joël Galeran Jolg42

PostgreSQL Major Version Upgrades (Docker)

Major PostgreSQL upgrades (e.g., 14→18) require a full dump and restore — the data files are not compatible across major versions.

Note: Immich requires vector extensions, and they supply an image with them bundled in as ghcr.io/immich-app/postgres:18-vectorchord0.5.3-pgvector0.8.1

Procedure

Dump: docker exec -t <container> pg_dumpall --clean --if-exists --username=<user> | gzip > dump.sql.gz
Stop the stack: docker compose down

Safari release notes history and Technical Preview versions -> release version mapping

Official docs

Safari release history

If you're using a high-end bluetooth headset on your Macbook Pro it's likely your mac is using an audio codec which favors battery efficiency over high quality. This results in a drastic degradation of sound, the SBC codec is the likely culprit, read more about it here.

Find out what codec you're using

Play a song on your headphones
Option (⌥) click the Bluetooth button at the top of your screen
If you're using AAC or aptX, you can stop here—those are the highest quality codecs.

Change your codec to AAC or aptX

Adobe XD Plugin Development - Important Links

Part 1: Understanding plugin basics

Starter project files

Part 2: Creating a "button frame" plugin

Adobe XD API Reference
Finished code from this part

Backing Up All Photos from Flickr to Google Photos

Request an archive of your photos and metadata (json) from the "Your Flickr Data" section of your Flickr user account page.
Extract all provided zip files to a single folder with the JSON files unzip to a json subfolder.
Install exiftool, a command-line application for reading, writing and editing meta information in a wide variety of files..
Sort your Flickr photos into yearly folders by EXIF timestamp and set file-system timestamps from the command line:

Chrome:

Version: 62.0.3202.94 (Official Build) (64-bit) User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36

Firefox:

Version: 57.0

	// Helper to pause execution
	const sleep = (ms) => new Promise((resolve) => setTimeout(resolve, ms));

	function getNextOldCatppuccinStyle() {
	// Grab ALL entries on the page
	const entries = document.querySelectorAll(".entry");

	for (const entry of entries) {
	const nameLink = entry.querySelector(".style-name-link");
	const styleInfo = entry.querySelector(".style-info");

	############
	# HOW TO CONNECT FROM LINUX?
	# HERE IS THE SCRIPT TO SETUP YOUR PC
	############

	#

	sudo apt install -y shadowsocks-libev wget

	sudo wget -O- "https://github.com/shadowsocks/v2ray-plugin/releases/download/v1.3.1/v2ray-plugin-linux-amd64-v1.3.1.tar.gz" \| tar -zxv

	ruby '2.7.1'

	gem 'rails', github: 'rails/rails'
	gem 'tzinfo-data', '>= 1.2016.7' # Don't rely on OSX/Linux timezone data

	# Action Text
	gem 'actiontext', github: 'basecamp/actiontext', ref: 'okra'
	gem 'okra', github: 'basecamp/okra'

	# Drivers

	# compare fonts with ttx
	ttdiff () {
	if [ "$#" -lt 2 ]
	then
	echo "Usage: ttdiff FONT1.ttf FONT2.ttf [tables ...]"
	return 1
	fi
	first="$1"
	if [ ! -f "$first" ]; then
	echo "File $first not found"