Coaching, das nicht in Tabellen verloren geht

// One persistent LISTEN socket per Node process —// sql.listen() uses a dedicated connection, not the pool.await sql.listen(CHANNEL, (payload) => {    const parsed = JSON.parse(payload) as StreamEvent    if (parsed.userId) publish(parsed.userId, parsed)}) export async function notifyUser(event: StreamEvent) {    await sql.notify(CHANNEL, JSON.stringify(event))}

// Median of all pairwise slopes. A single water-weight// spike only touches N-1 of the N(N-1)/2 pairs, so its// leverage on the trend is negligible.export function theilSenSlope(xs: number[], ys: number[]) {    const slopes: number[] = []    for (let i = 0; i < xs.length; i++) {        for (let j = i + 1; j < xs.length; j++) {            const dx = xs[j]! - xs[i]!            if (dx === 0) continue            slopes.push((ys[j]! - ys[i]!) / dx)        }    }    slopes.sort((a, b) => a - b)    return median(slopes)}

export async function updateExercise(    id: string, name: string,): Promise<ActionResult> {    // Middleware is not a security boundary (CVE-2025-29927) —    // every Server Action verifies auth independently.    const session = await auth()    if (!session?.user?.id)        return { success: false, error: "Not authenticated" }    if (session.user.role !== "coach")        return { success: false, error: "Not authorized" }     await db.transaction(async (tx) => { /* ... */ })    return { success: true }}