geoffreylitt

name	explain-diff-html
description	Use when the user asks for a rich explanation of a code change, diff, branch, or PR. Produces HTML output.

Explain Diff

Please make me a rich, interactive explanation of the specified code change.

It should have these sections:

pmarreck

Giving Claude Code a sense of time (rate-limited, low-noise)

A self-contained recipe. Read this one file and you can reproduce the whole mechanism from scratch — a human or another LLM, knowing nothing else.

---

1. The problem

An LLM agent has no clock. It only knows what is in its context window.

TwilightZebby

I've been seeing a lot of misinformation so:

Definitions of terms used here

Word	Meaning
App	A Bot account on Discord, always has the "APP" flair
Server App	A Bot account with support to be added to Servers, so all the Server's members can use it
User App	A Bot account with support to be added to User accounts, so that User can use its commands in across Servers & DMs/GroupDMs

nathanl

Deadlocks Demo

For a basic discussion and demo, see https://www.postgresql.org/docs/current/explicit-locking.html#id-1.5.12.6.8.2

My own demo follows.

Setup

Create two tables with unique indexes:

cpursley

Postgres Full Text Search

Do you really need Elastic Search?

• https://www.postgresql.org/docs/current/pgtrgm.html
• https://scoutapm.com/blog/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity
• https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/
• https://mazeez.dev/posts/pg-trgm-similarity-search-and-fast-like
• https://alexklibisz.com/2022/02/18/optimizing-postgres-trigram-search.html
• https://www.freecodecamp.org/news/fuzzy-string-matching-with-postgresql/

erikig

ProGM

Arel Cheatsheet on Steroids

A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.

Tables

posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord

Table alias

olivierlemoal

Moved to https://github.com/olivierlemoal/i3-swap-focus

DoomHammer

## Prefix like in screen
set -g prefix 'C-a'

## Use xterm keys (makes eg. Ctrl+Arrow navigate words)
set-window-option -g xterm-keys on

## List of plugins
# For this to work you need to install https://github.com/tmux-plugins/tpm
set -g @plugin 'tmux-plugins/tpm'
set -g @plugin 'tmux-plugins/tmux-sensible'

Gorcenski

import numpy as np
from functools import reduce

class Buzzer:
    def __init__(self, **kwargs):
        values = [v for k, v in kwargs.items()]

        self.kwargs = kwargs
        self.lcm = np.lcm.reduce(values)
        self.eps = 1e-7