# Extraction run report - **Sessions:** 3 Sonnet (calibration) + 17 DeepSeek V3 = **20** total - **Cost:** Sonnet $1.3557 + DS $0.8007 = **$2.1564** - **Raw candidates:** 158 - **Evidence verbatim:** 136/158 (86.1%) - **Flagged as likely duplicate vs brain DB:** 1/158 (0.6%) ## Tier breakdown - tier 1: 118 (74.7%) - tier 2: 40 (25.3%) ## Per-session | Session | Project | Model | Candidates | Grounded | Dupes | Cost | |---|---|---|---|---|---|---| | 1a729aef-9a4 | home-3d-and-inventory | deepseek-chat | 13 | 10 | 0 | $0.0703 | | 28ee9855-6b6 | ? | deepseek-chat | 8 | 7 | 0 | $0.0466 | | 2b2deac1-713 | ? | deepseek-chat | 7 | 6 | 0 | $0.0426 | | 3dcc986d-11f | reflector | deepseek-chat | 11 | 9 | 0 | $0.0662 | | 4676908d-36c | pai | sonnet-4-6 | 6 | 5 | 0 | $0.4143 | | 4aaf25b1-652 | ? | sonnet-4-6 | 7 | 6 | 0 | $0.5056 | | 759fe8cd-f72 | use-case-groceries | deepseek-chat | 5 | 4 | 0 | $0.0264 | | 876d1aaa-d00 | data-team | deepseek-chat | 8 | 8 | 0 | $0.0453 | | 9556aed2-0fe | ? | deepseek-chat | 5 | 2 | 0 | $0.0272 | | 9c69ef34-ff8 | pace-nlp-project | deepseek-chat | 6 | 3 | 1 | $0.0387 | | ae3eba80-21d | ? | deepseek-chat | 7 | 7 | 0 | $0.0484 | | b9662050-664 | acebuddy | deepseek-chat | 6 | 5 | 0 | $0.0334 | | c0953633-bde | ? | deepseek-chat | 5 | 3 | 0 | $0.0283 | | c3e19927-9c3 | navigator | deepseek-chat | 17 | 17 | 0 | $0.0984 | | c63dbbc9-8da | tablets-voice-calendar-tasks-groceries-music | deepseek-chat | 7 | 6 | 0 | $0.0403 | | d76e9d36-cf6 | acebuddy | sonnet-4-6 | 6 | 6 | 0 | $0.4358 | | deeaf9f0-5ff | data-workbench | deepseek-chat | 13 | 11 | 0 | $0.0753 | | e6bf3e63-b5d | brain-health | deepseek-chat | 5 | 5 | 0 | $0.0246 | | ef726887-5cf | ? | deepseek-chat | 8 | 8 | 0 | $0.0434 | | f90c8e92-6da | ? | deepseek-chat | 8 | 8 | 0 | $0.0454 | ## Top 15 grounded, non-duplicate candidates (by confidence) - **T1 [0.98]** `grocery` — Mealie API: tags require a slug field on PUT/PATCH - When updating Mealie recipes via PUT/PATCH, tag objects must include both `name` and `slug` fields. Sending only `{"name": "TagName"}` returns HTTP 422 with `"Field required"` on `slug`. The slug must - _from 4676908d-36c / sonnet-4-6_ - **T1 [0.98]** `audio-tts` — Deepgram Aura TTS character limit is 2000, not 4000 - Deepgram Aura TTS has a strict 2000-character limit per request, not 4000 as previously assumed. When chunking text for audio generation, target chunk size must be ≤1800 characters (with margin) to av - _from 9556aed2-0fe / deepseek-chat_ - **T1 [0.98]** `data-team` — data-team doc_chunks table schema: chunk_text not content - The public.doc_chunks table in the data-team database uses column name `chunk_text` for the content, not `content`. Semantic search queries must reference `chunk_text` when querying this table, and ro - _from 876d1aaa-d00 / deepseek-chat_ - **T1 [0.98]** `google-ai` — Gemini 2.0-flash model retired, requires upgrade to 2.5-flash - Google's Gemini 2.0-flash model has been retired and returns HTTP 404 with message 'This model models/gemini-2.0-flash is no longer available to new users.' All code referencing it must be updated to - _from 1a729aef-9a4 / deepseek-chat_ - **T1 [0.98]** `brain-db` — Brain DB user is acebuddy not ace for PostgreSQL access - When connecting to the brain database PostgreSQL container on acebuddy.quest, the username is 'acebuddy' not 'ace'. Using 'ace' results in 'role "ace" does not exist' error. The correct command is `do - _from 1a729aef-9a4 / deepseek-chat_ - **T1 [0.98]** `brain-db` — Brain DB house_items table schema has NOT NULL foreign keys to rooms - The brain DB `house_items` table requires `room_id` (NOT NULL foreign key to `rooms`) and `name` (NOT NULL) columns, which the app's INSERT statements didn't provide. The schema also lacks `updated_at - _from 1a729aef-9a4 / deepseek-chat_ - **T1 [0.98]** `brain-db` — Brain DB memory table: value column is JSONB, requires explicit cast for string functions - In the brain DB `memory` table, the `value` column is JSONB. Calling `LEFT(value, 300)` fails with "function left(jsonb, integer) does not exist". Must cast explicitly: `LEFT(value::text, 300)`. - _from 4aaf25b1-652 / sonnet-4-6_ - **T1 [0.98]** `postgres` — asyncpg SQL parameter binding: ::vector cast syntax conflicts - When using asyncpg with SQLAlchemy, the PostgreSQL `::vector` cast syntax conflicts with asyncpg's parameter binding system. asyncpg interprets `::` as a named parameter binding, causing syntax errors - _from 876d1aaa-d00 / deepseek-chat_ - **T1 [0.98]** `docker` — Navigator route deploy gotcha: route files COPY'd into Docker image, not bind-mounted - Route JSON files (navigator-api/routes/*.json) are baked into the Docker image via COPY in the Dockerfile, not bind-mounted. SCP'ing updated files to the host does nothing for the running container. U - _from c3e19927-9c3 / deepseek-chat_ - **T1 [0.98]** `brain-db` — Brain DB memory table: value column is JSONB, requires explicit cast for string functions - In the brain DB `memory` table, the `value` column is JSONB. Calling `LEFT(value, 300)` fails with "function left(jsonb, integer) does not exist". Must cast explicitly: `LEFT(value::text, 300)` or `va - _from ef726887-5cf / deepseek-chat_ - **T1 [0.98]** `email-analysis` — mboxrd parser regex must match line.rstrip() not raw line due to CRLF endings - When parsing mboxrd files with CRLF line endings, the regex `FROM_LINE.match(line)` fails because the `$` anchor can't match before `\r\n`. The fix is `FROM_LINE.match(line.rstrip())` to remove traili - _from deeaf9f0-5ff / deepseek-chat_ - **T1 [0.98]** `data-workbench` — Workbench session logging: get_current_session() returns None outside active session - The workbench.session.get_current_session() function returns None when called outside an active session context. To log findings, you must first call start_session() to create a session, then get_curr - _from deeaf9f0-5ff / deepseek-chat_ - **T1 [0.98]** `infrastructure` — ntfy action button callbacks must use public URLs, not Docker bridge IPs - When using ntfy action buttons, the callback URLs execute from the phone's network, not the ntfy server. URLs like `http://172.17.0.1:8062/...` (Docker bridge IP) will fail because the phone can't rea - _from c0953633-bde / deepseek-chat_ - **T1 [0.98]** `jupyter` — Jupyter nbconvert fails on Windows paths in cell IDs - When converting Jupyter notebooks on Windows, nbconvert fails if cell IDs contain backslashes from Windows paths (e.g., 'export-report-md-colab\\02'). The error is 'Notebook JSON is invalid: ... does - _from 3dcc986d-11f / deepseek-chat_ - **T1 [0.98]** `health` — Oura movement sensor baseline is 1, not 0 - Oura's movement sensor has no true zero reading — across 26 nights and 23,530 thirty-second epochs, not a single epoch recorded 0 (still). Every stage (deep, light, REM, awake) is always at least 1, m - _from 2b2deac1-713 / deepseek-chat_