Turbo87

name	brainstorm
description	Guide structured brainstorming from a rough idea into a design, specification, and eventual implementation plan. Use when the user wants to brainstorm, talk through an idea, refine a product or technical design, turn an idea into a spec, or asks for one-question-at-a-time ideation. Do not implement during the brainstorm unless the user explicitly exits brainstorming.

Brainstorm

Help the user turn an initial idea into a coherent design and spec through focused questions and staged synthesis.

Workflow

Turbo87

name

cooperative-code-review

description

Review a pull request, branch, commit, staged change, or working-tree diff interactively with the user in small readable chunks. Use when the user asks to review code together, walk through changes one chunk at a time, inspect a PR collaboratively, or wants a code-first review with pause points and ready-to-post findings. Do not use for one-shot review reports, addressing existing review comments, or CI debugging.

Cooperative Code Review

Analyze the complete change first, then help the user review it one readable chunk at a time. Compose the existing review workflows instead of duplicating their specialist guidance.

Resolve the review scope

Turbo87

🔴 excessive-permissions: overly broad permissions
   severity: High, confidence: High
   --> .github/workflows/mdbook.yml:18
   |   pages: write
   = pages: write is overly broad at the workflow level
   docs: https://docs.zizmor.sh/audits/#excessive-permissions

🔴 excessive-permissions: overly broad permissions
   severity: High, confidence: High
   --> .github/workflows/mdbook.yml:19

Turbo87

crates.io Frontend Framework Evaluation

Context

The crates.io frontend is currently built with Ember.js. We're evaluating alternatives due to:

• Difficulty finding contributors: Ember's declining mindshare makes it hard to attract help
• Bundle size: Current JS payload is larger than ideal
• Ecosystem decline: Fewer packages, less community activity, uncertain long-term future

Turbo87

CREATE OR REPLACE FUNCTION semver_ord(num varchar) RETURNS jsonb AS $$
DECLARE
    max_prerelease_parts constant int := 30;
    match_result text[] := regexp_match(num, '^(\d+).(\d+).(\d+)(?:-([0-9A-Za-z\-.]+))?');
    prerelease jsonb;
    prerelease_part text;
    i int := 0;
BEGIN
    IF match_result[4] IS NULL THEN
        -- A JSONB object has higher precedence than an array and versions without

Turbo87

INSERT INTO background_jobs (job_type, data)
VALUES
    ('sync_to_git_index', '{"krate": "CoreFoundation-sys"}'::jsonb),
    ('sync_to_sparse_index', '{"krate": "CoreFoundation-sys"}'::jsonb),
    ('sync_to_git_index', '{"krate": "IOKit-sys"}'::jsonb),
    ('sync_to_sparse_index', '{"krate": "IOKit-sys"}'::jsonb),
    ('sync_to_git_index', '{"krate": "accelerate-src"}'::jsonb),
    ('sync_to_sparse_index', '{"krate": "accelerate-src"}'::jsonb),
    ('sync_to_git_index', '{"krate": "advapi32-sys"}'::jsonb),
    ('sync_to_sparse_index', '{"krate": "advapi32-sys"}'::jsonb),

Turbo87

UPDATE versions SET links = 'CoreFoundation' WHERE id = 11136; -- CoreFoundation-sys 0.1.0
UPDATE versions SET links = 'CoreFoundation' WHERE id = 14768; -- CoreFoundation-sys 0.1.1
UPDATE versions SET links = 'CoreFoundation' WHERE id = 16877; -- CoreFoundation-sys 0.1.2
UPDATE versions SET links = 'CoreFoundation' WHERE id = 17646; -- CoreFoundation-sys 0.1.3
UPDATE versions SET links = 'CoreFoundation' WHERE id = 71134; -- CoreFoundation-sys 0.1.4
UPDATE versions SET links = 'IOKit' WHERE id = 11300; -- IOKit-sys 0.1.0
UPDATE versions SET links = 'IOKit' WHERE id = 11362; -- IOKit-sys 0.1.1
UPDATE versions SET links = 'IOKit' WHERE id = 16878; -- IOKit-sys 0.1.2
UPDATE versions SET links = 'IOKit' WHERE id = 17647; -- IOKit-sys 0.1.3
UPDATE versions SET links = 'IOKit' WHERE id = 28038; -- IOKit-sys 0.1.4

Turbo87

-- from https://github.com/ioguix/pgsql-bloat-estimation/blob/8fde3c9e0e015ece51e10c1450228d23f7747db1/table/table_bloat.sql

SELECT tblname, bs*tblpages AS real_size,
       (tblpages-est_tblpages)*bs AS extra_size,
       CASE WHEN tblpages > 0 AND tblpages - est_tblpages > 0
                THEN 100 * (tblpages - est_tblpages)/tblpages::float
            ELSE 0
           END AS extra_pct, fillfactor,
       CASE WHEN tblpages - est_tblpages_ff > 0
                THEN (tblpages-est_tblpages_ff)*bs

Turbo87

use anyhow::Context;
use chrono::NaiveDate;
use crates_io_cdn_logs::DownloadsMap;
use diesel::prelude::*;
use diesel::PgConnection;

table! {
    temp_downloads (name, version, date) {
        name -> Text,
        version -> Text,

Turbo87

{
  "models": [
    {
      "id": 219,
      "name": "AFH 22",
      "index": 98,
      "type": "glider",
      "weglideId": 283
    },
    {