bacalj

ACCESS-CI Dev Journal

Gist mirror: https://gist.github.com/bacalj/a6c6f9726844611df5a09c83884a0e83

2026-02-28 — A.1: Argilla → pgvector sync pipeline

Goal: Get Q&A pairs from Argilla into access-qa-service (pgvector) so they're searchable via semantic search.

Discovery: access-qa-service already had a /admin/sync endpoint and argilla_sync.py — but the code was scaffolded with placeholder logic that didn't match the actual Argilla v2 API or the record schema created by access-qa-extraction.

bacalj

How Lifecycle Events Work in Squash Team One

The core idea: There is no "lifecycle event" entity. An "Initial Assessment" or "Vision Development Session" is just a session template that a coach creates, fills with whatever drills and metrics they want, and optionally tags (once #63 ships) as milestone, onboarding, etc. The system doesn't know what an "Initial Assessment" is. It knows what a session template is, what a tag is, and what a due date is. The coach defines the meaning.

The flow, using only what exists today

1. Coach builds a session template in the library — specific drills, specific metrics (could be court drills with numeric metrics, reflection exercises with text prompts, or a mix)
2. Coach instantiates it for a player → creates a real session with snapshotted drills, session_template_id recording lineage, a due_at for the deadline
3. Player (or coach) does the work, records measures
4. Coach clicks "Mark Complete" → completed_at is set once, permanently

bacalj

ACCESS-CI: Feb/March 2026 Work Plan

Owner: Joe Bacal Collaborator: Andrew Pasquale Last updated: 2026-02-28 Status: A.1–A.2 complete, ready for A.3 evaluation

---

Context

bacalj

ACCESS-CI Q&A Extraction — Full-Run Cost Estimates

Date: 2026-02-26 Pipeline: Two-shot (battery + discovery + judge) — 3 LLM calls per entity Branch: feat/two-shot

How costs are calculated

Each entity gets 3 LLM calls:

1. Battery — system prompt (~800 tokens) + entity JSON (~500-2000 tokens) → response (~500-1500 tokens)

bacalj

  /*
  * ----------------------------------------------------------------------------------------------------
  * Muscle SpikerShield Arduino UNO Code for Interface with Dataflow
  * This code is up to date for use with the "Claw Pro R3"
  *
  * This sketch allows for two way communication between Concord Consortium's Dataflow Tile and
  * Backyard Brains' Muscle Spiker Shield & associated hardware.
  *
  * Based on original script by Backyard Brains 2015, by Marcio Amorim and Stanislav Mircic
  * Adapted by Concord Consortium, 2023.

bacalj

{
  "rowMap": {
    "B0rVs5_fa3cLYNH_": {
      "id": "B0rVs5_fa3cLYNH_",
      "isSectionHeader": true,
      "sectionId": "start",
      "tiles": []
    },
    "GTGXP-3bG7lQpFmt": {
      "id": "GTGXP-3bG7lQpFmt",

bacalj

  /*
  * ----------------------------------------------------------------------------------------------------
  * Muscle SpikerShield Arduino UNO Code for Interface with Dataflow
  * This code is up to date for use with the "Claw Pro R3"
  *
  * This sketch allows for two way communication between Concord Consortium's Dataflow Tile and
  * Backyard Brains' Muscle Spiker Shield & associated hardware.
  *
  * Based on original script by Backyard Brains 2015, by Marcio Amorim and Stanislav Mircic
  * Adapted by Concord Consortium, 2023.

bacalj

/*
  * ----------------------------------------------------------------------------------------------------
  * THIS IS FOR THE 2022 Version of the Gripper
  *
  * Muscle SpikerShield Arduino UNO Code for Interface with Dataflow
  *
  * This sketch allows for two way communication between Concord Consortium's Dataflow Tile and
  * Backyard Brains' Muscle Spiker Shield & associated hardware.
  *
  * Based on original script by Backyard Brains 2015, by Marcio Amorim and Stanislav Mircic

bacalj

  /*
  * ----------------------------------------------------------------------------------------------------
  * THIS IS FOR THE 2023 Version of the Gripper
  *
  * Muscle SpikerShield Arduino UNO Code for Interface with Dataflow
  *
  * This sketch allows for two way communication between Concord Consortium's Dataflow Tile and
  * Backyard Brains' Muscle Spiker Shield & associated hardware.
  *
  * Based on original script by Backyard Brains 2015, by Marcio Amorim and Stanislav Mircic

bacalj

  /*
  * ----------------------------------------------------------------------------------------------------
  * THIS IS FOR THE 2022 Version of the Gripper
  *
  * Muscle SpikerShield Arduino UNO Code for Interface with Dataflow
  *
  * This sketch allows for two way communication between Concord Consortium's Dataflow Tile and
  * Backyard Brains' Muscle Spiker Shield & associated hardware.
  *
  * Based on original script by Backyard Brains 2015, by Marcio Amorim and Stanislav Mircic