gary.info
posts
tags
#code
Turning Clipboard SQL into a Self-Healing mycli Workflow
Dec 30, 2025
4 min
Designing Claude Code Tools Using an MVC Mental Model
Dec 29, 2025
3 min
Combining BM25 and embeddings instead of using semantic search everywhere
Dec 25, 2025
5 min
Using cheap embeddings to route language model requests
Dec 25, 2025
5 min
Using Postgres pgvector and HNSW Instead of Dedicated Vector Databases
Dec 25, 2025
4 min
Using Atuin to store zsh shell history in SQLite and fix Up arrow keybindings
Dec 21, 2025
2 min
Using yamlfmt to consistently auto-format YAML files
Dec 21, 2025
5 min
Using Bash history expansion to auto-escape strings
Dec 21, 2025
5 min
Interpreting EXIF orientation and GPS data for galleries and maps
Dec 21, 2025
5 min
Flattening nested JSON objects with jq for SQLite import
Dec 21, 2025
4 min
Using Google Programmable Search Engine JSON API for Web Queries
Dec 21, 2025
7 min
Using Google Sheets API with public read-only access
Dec 21, 2025
5 min
Converting arrays of arrays into objects with jq
Dec 21, 2025
3 min
Tracing macOS process file access with fs_usage
Dec 21, 2025
5 min
Discovering macOS sips scriptable image processing
Dec 21, 2025
5 min
Using NDJSON with ripgrep and jq
Dec 21, 2025
4 min
Managing MySQL users, passwords, and privileges safely
Dec 21, 2025
4 min
Clipping partial YouTube livestreams with yt-dlp and ffmpeg
Dec 21, 2025
5 min
Scraping Reddit JSON endpoints with curl and jq
Dec 21, 2025
4 min
Using SQL Server DMVs to audit and design indexes
Dec 21, 2025
6 min
← Newer
1 / 2
Older →