Fix Solana token account errors - create missing associated token accounts, rent-exempt minimums, Token vs Token-2022 and reading simulation logs

Fix Prisma Migrate errors - drift, shadow database P3006, failed migration P3009 resolve, baselining an existing DB, dev vs deploy, directUrl

Pydantic models as LLM tool schemas - model_json_schema output, inline $defs refs, extra=forbid, error types to return, lax vs strict coercion

A 20-minute smart contract red-flag checklist - verified source, proxy admin, owner powers, honeypot signs, oracles, liquidity locks and audit evidence

SQLite maintenance - online backup API, VACUUM shrinking 2180 to 1092 KB, WAL and shm files, wal_checkpoint(truncate), integrity_check

SQLite cookbook - ON CONFLICT upsert vs INSERT OR REPLACE, recursive CTE hierarchies, json_extract and json_each, date modifiers, NULL order

SQL NULL pitfalls - = NULL never matches, NOT IN with NULL returns nothing, aggregates skip NULL, joins, sort order and UNIQUE behaviour

Read SQLite EXPLAIN QUERY PLAN - SCAN vs SEARCH, composite index column order, temp B-tree for ORDER BY, and queries that ignore indexes

SQL window functions cookbook - running totals, top-N per group, rank vs row_number, LAG, moving average, frame traps

Fix Pydantic v2 ValidationError - read loc and type, Optional needs default, strict vs lax, v1 to v2 renames, validators, BaseSettings move

Fix CERTIFICATE_VERIFY_FAILED in requests, curl and Node - trust the CA with verify= or --cacert, SAN mismatches, why -k is unsafe

Fix a systemd timer that never runs - list-timers, enable the .timer, systemd-analyze calendar, Persistent, service journal, environment gaps

Count LLM tokens with tiktoken - chars vs tokens table, emoji and digits cost, chunk by tokens with overlap, prompt budget formula

Fix Stripe webhook signature verification failures - raw request body, endpoint secrets, timestamp tolerance, proxies and idempotent retries

Fix TLS certificate renewal failures - certbot logs, HTTP-01 and DNS-01 errors, rate limits and reload hooks

Fix Terraform state lock errors and drift - force-unlock safely, state backups, moved and import blocks, refresh-only plans and unwanted destroys

Tar, zip and gzip recipes - exclude node_modules, -C for clean paths, zip -y for symlinks, gzip -t, sha256sum -c verification

Fix common TypeScript errors - TS2339, TS2322, TS7006, TS2307 and possibly undefined; narrowing, @types, ESM extensions, tsconfig settings

Fix strict TypeScript errors - TS18046 unknown, TS2339 unions, TS2540 as const, TS2353 excess props, TS18048 index access, never exhaustiveness

Verify webhook HMAC-SHA256 signatures - raw body not re-serialized JSON, timestamp tolerance, compare_digest and timingSafeEqual