| Use RDBMS (PostgreSQL) |
โ |
0001 โ
|
โ |
โ |
โ |
โ |
โ
|
Foundation |
| Backend Architecture |
โ |
0002 โ
|
โ |
โ |
โ |
โ |
โ
|
Spring Boot + Virtual Threads |
| Cache Strategy |
โ |
0003 โ
|
โ |
โ |
โ |
โ |
โ
|
Guava LRU |
| Frontend Structure |
โ |
0004 โ
|
โ |
โ |
โ |
โ |
โ
|
Vanilla JS โ React |
| LRU Video Cache |
โ |
0005 โ
|
โ |
โ |
โ |
โ |
โ
|
Video chunk caching |
| Admin Dashboard |
โ |
0007 โ
|
โ |
โ |
Plan ๐ |
โ |
๐ |
|
| React Migration |
PRD โ
|
0008 โ
|
โ |
Seq โ
|
Plan |
โ |
โ
|
|
| Unified Video List API |
โ |
0009 ๐ก |
โ |
โ |
โ |
โ |
๐ |
|
| Trivy Container Scanning |
โ |
0010 โ
|
โ |
โ |
Plan |
โ |
โ
|
CI scanning |
| Hot Video Priority |
PRD โ
|
0011 โ
|
โ |
Seq ๐ |
Plan ๐ |
PRD deck ๐ค |
๐ |
|
| Bitwise Permissions |
โ |
0015 โ
|
Spec โ
|
โ |
Plan |
โ |
โ
|
AS-BUILT docs |
| Hot Score Migration |
โ |
โ |
โ |
โ |
Plan ๐ |
โ |
๐ |
|
| File-based Hooks |
โ |
โ |
โ |
โ |
Plan A ๐ ยท Plan B ๐ |
โ |
๐ |
|
| Bookmark Feature |
PRD ๐ |
0012 โ
|
โ |
Seq โ
|
Plan ๐ ยท Library Collections โ
|
โ |
๐ |
ADR amended 2026-10-13: collections-first, no bookmarks table; admin public collections |
| Watch History (v2) |
PRD โ
|
0021 โ
|
โ |
Seq โ
|
Plan โ
|
โ |
โ
|
0a2a365 BE (table, API, recording on the view call) + 4c46791 FE (History tab, progress/resume, badges); QA-1 verified on prod 2026-10-18. Supersedes ADR-0013/0014 |
| User Settings |
PRD โ
|
0016 โ
|
Spec โ
|
Seq โ
|
Plan โ
|
โ |
โ
|
Pushed to main dd45fc0; coverage 95.91% |
| Video Reactions (like / unlike / dislike) |
โ |
โ |
โ |
โ |
Plan โ
|
โ |
โ
|
28cc167; fixes 404 on /video/like; per-user reactions, optional-auth GET |
| Admin Comment Moderation |
โ |
โ |
โ |
โ |
Plan โ
|
โ |
โ
|
acfc953 soft remove/restore with policy reasons; 6f66b15 bulk (โค100) |
| Comment Replies |
โ |
โ |
โ |
โ |
Plan โ
|
โ |
โ
|
a23950f 2-level threads, author delete keeps others' replies; 368bf0c reply-to-reply notifies the replied author |
| i18n (Vietnamese + English) |
PRD โ
|
0020 โ
|
โ |
Seq โ
|
Plan โ
|
โ |
โ
|
react-i18next, browser default; UI + API errors + emails + Admin. FE-1..5 + BE-1..3 done; QA-1 verified on prod by owner (recorded 2026-10-18) |
| Collection Reorder (drag & drop) |
โ |
0012 โ
|
โ |
โ |
Plan โ
|
โ |
โ
|
position column + PATCH /collections/{id}/videos/{videoId} (afterVideoId); FE "Sแบฏp xแบฟp" mode with @dnd-kit; new videos at the top. QA-1 verified on prod by owner (2026-10-18) |
| Video Suggestions (+ button) |
PRD โ
|
โ |
โ |
Seq โ
|
Plan โ
|
โ |
โ
|
Users suggest YouTube/FB links โ admin approves โ import pipeline; replaces legacy share; History โ My suggestions; ~6.5d |
| User Notifications |
PRD โ
|
0017 โ
|
โ |
Seq โ
|
Plan โ
|
โ |
โ
|
a11d31e in-app + SSE (fetch + header auth) + 15-min digest; verified on prod 2026-10-03; nginx worker_connections 768โ8192 |
| Password Login (optional) |
PRD โ
|
0018 โ
|
โ |
Seq โ
|
Plan โ
|
โ |
โ
|
fd319cf email + password next to magic link, lockout 5/15 min, cv session revocation; e6d6a3f/63e21f0 modal + ๐ icon; 3de7a4a role in login response; verified on prod 2026-10-09 |
| Admin Video Import (YouTube / Facebook โ Drive) |
PRD โ
|
0019 โ
|
โ |
Seq โ
|
Plan โ
|
โ |
โ
|
795ec5e yt-dlp โ Drive (OAuth uploader) โ existing cron ingests; bulk โค20, run now / 5-min schedule slots, polling progress; d9bddd9 FB reels; setup guide; verified on prod 2026-10-11 |
| Drive Sync Time Filter |
โ |
โ |
โ |
โ |
Plan โ
|
โ |
โ
|
cc7f8f2b BE + ad0adc82/31f01e86 FE. DRIVE_SYNC tab: server-side filter on Drive created time (GET /files?from&to), default last 12 h, presets 1h/12h/24h/7d/30d, All, custom from/to (VN time); orphans only under All. QA-1 verified on prod by owner (2026-10-18) |
| Admin Drive Force Sync |
โ |
โ |
โ |
โ |
Plan ๐ |
โ |
๐ |
1e961cc tab DRIVE_SYNC: Drive โ local โ DB states; ADMIN views, SUPER_ADMIN force-syncs (re-download + upsert, โค50/run); unique (source_type, source_id); prod E2E pending |
| /autopilot skill (dev tooling) |
โ |
ADR-0028 โ
|
โ |
โ |
Plan โ
|
โ |
๐ |
Built 2026-10-19 (f8fa31ce, d52f6b2e); QA-1 dry run pending. One skill chains plan โ plan review โ [you approve] โ implement โ review โ QA tests ร2 โ commit โ [you approve push]; round caps 3, run ledger |
| Suggestion Re-review |
โ |
โ |
โ |
โ |
Plan โ
|
โ |
โ
|
6c16388e BE + 29c1fd94 FE (first /autopilot run). Admin Reopen (REJECTED, or APPROVED with FAILED/CANCELLED job) โ Pending; submitter re-review request after rejection (max 2, optional message). SR-QA-1 verified on prod by owner (2026-10-19) |
| Dynamic Cron Jobs |
โ |
ADR-0023 โ
|
โ |
โ |
Plan โ
|
โ |
โ
|
985ba5b5 BE + e7b53b4f FE (autopilot). Schedules of the 6 AppScheduler jobs in scheduled_job; Admin โ Scheduled jobs: ADMIN views, SUPER_ADMIN edits cron/zone/enabled or runs now. Cron editor modal + tooltip (ADR-0024). Prod check pending |
| Headless Autopilot |
โ |
0022 โ
+ 0025 โ
|
โ |
โ |
Plan โ
|
โ |
โ
|
Label autopilot on an issue โ draft PR with plan โ /approve โ build on the PR branch โ owner merges. Opt-in labels autopilot:auto-merge / autopilot:auto skip Gate 2 / both gates (ADR-0025, needs secret AUTOPILOT_MERGE_TOKEN). First run issue #26 โ PR #27 merged 2026-10-19 (3 workflow fixes on the way: allowlist, foreground workers, mandatory code review + cost comment) |
| In-App Report |
PRD โ
|
0026 โ
|
Spec ๐ |
Seq โ
|
Plan โ
|
โ |
โ
|
Report menu above Settings (ADMIN/SA) โ GitHub issue with autopilot via the owner's fine-grained PAT; auto labels SA only; 5/h per user + 10 autopilot reports/24 h. Done IR-1..IR-7 (ca21f28e..1cde69c8); live on prod 2026-10-21. D7 webhook state (plan): done WH-1..WH-5 (5582b2fc, 90dd0a78), live 2026-10-21. Closed-issue notification to the reporter (plan): built RN-1..RN-3 (801dcb9f, b3030e52) |
| Contributor Autopilot Permissions |
PRD ๐ |
0030 โ
|
Spec โ
|
Seq โ
|
Plan โ
|
โ |
โ
|
New CONTRIBUTOR role (Report only); SA grants per-account bits AUTOPILOT_AUTO_MERGE / AUTOPILOT_AUTO to CONTRIBUTOR or ADMIN; checked in ReportServiceImpl against the DB; shared cap 10/24 h. Amends ADR-0026. Spec drops @HasPermission(ADMIN) on report endpoints. Done CA-1..CA-6 (e1eeb892..102fced0) by autopilot (report); owner prod check pending |
| HLS Streaming |
PRD โ
|
0031 โ
|
Spec โ
|
Seq โ
|
Plan โ
|
โ |
โ
|
Opt-in HLS per video (SUPER_ADMIN toggle), single-job stream-copy worker with ffprobe + disk guard, Harness flag hls_streaming_enabled decides if hlsUrl is offered; Range stays as fallback. Replaces the deleted ADR-0006 draft. Done HL-1..HL-7 (5c485b5f..64d66721) by autopilot (report); prod verified 2026-10-24 (49/60 videos H.264, 11 VP9 need re-import; HLS + Range fallback checked in browser) |
| Basic PWA |
โ |
โ |
โ |
โ |
Plan โ
|
โ |
โ
|
Hand-written service worker (navigation shell + hashed assets only; API/video never intercepted), installable manifest + iOS meta, "new version" banner from polled version.json. No new dependency. Built by autopilot (report); owner install check pending |
| Web Push |
PRD ๐ |
0032 ๐ก |
โ |
โ |
โ |
โ |
๐ก |
Daily new-video digest (19:00 VN, text only) + admin alerts (import DONE/FAILED, HLS ERROR) for signed-in users; standard Web Push + VAPID implemented in-house on JCA (no new dependency); CTR tracking. Next: approve ADR, /spec |
| Spring Boot 4.1 Upgrade |
PRD โ
|
0033 โ
|
Spec โ
|
Seq โ
|
Plan โ
|
โ |
โ
|
3.5.0 (OSS EOL 2026-06-30) โ 4.1.x on Java 24; direct Jackson 3 migration, jjwt โ jjwt-orgjson, BOM owns versions; JSON wire format semantically unchanged (order may change), old JWTs stay valid, no schema change. Plan: SB4-1..SB4-5 (baseline tests, jjwt-orgjson, internal Jackson 3 on 3.5, then the 4.1.2 bump). Done SB4-1 08e8127f, SB4-2 jjwt-orgjson 02fe8707, SB4-4 Boot 4.1.2 + Jackson 3 6f42137d (SB4-3 folded in) by autopilot (report). SB4-5: prod start clean (Liquibase 0 pending, no migrator renames โ migrator removed 9e0d298d), mock-test 22/22, owner smoke pass; 7-day watch closed early by owner 2026-10-29 |
| Frontend Dependency Upgrade |
PRD โ
|
0034 โ
|
Spec ๐ |
Seq โ
|
Plan โ
|
โ |
โ
|
All 27 outdated webapp packages to latest in one commit: Vite 8 + plugin-react 6, Vitest 5, jsdom 29, ESLint 10, react-hooks 7, React 19.3; CI (deploy-web, autopilot) on Node 22; unused FontAwesome removed; hls.js exact pin 1.7.4. Plan: FD-1..FD-6 (in-range bumps, FontAwesome removal, build/test toolchain, lint toolchain, Node 22 + docs, land), squashed into one commit. Built by autopilot as 82be7105 (report): npm outdated empty, 655/655 tests, main chunk 248.37 kB gzip, audit 16 โ 1 moderate; react-hooks 7 rules set-state-in-effect/refs/immutability briefly at warn, then all 23 lint warnings fixed and rules back to error (6ed44dde); flaky admin comment selection bug fixed (d212e176); jsdom stays 29 (30 needs Node โฅ 22.22.2/24.15). Deploy Frontend green on Node 22, owner prod smoke pass 2026-10-29 |
| Collection-Only Videos |
PRD โ
|
0035 โ
|
Spec โ
|
Seq โ
|
Plan โ
|
โ |
โ
|
Research videos out of the feed, search and Explore hero but playable from collections, watch history and direct links. visibility enum (FEED, COLLECTION_ONLY, HIDDEN) replaces is_hide in one release with owner-approved downtime; Import form option; Admin "Add to collection"; deep-link fallback inserts a non-feed video at slide 0. Plan: CO-1..CO-7 + CO-F1 (atomic backend schema switch, admin endpoint, import, 3 FE tasks, land in two pushes). CO-1..CO-3 02376098, CO-4..CO-6 488e285f built by autopilot (report); 380 QA tests ร2 green. Landed in two pushes; UI fixes (badge stack, title column, โฎ row menu) b2415b8f; CO-F1 removed the legacy {hidden} body 352b428a; owner prod smoke (CO-7) passed 2026-10-31 |
| Admin Bulk Actions |
PRD โ
|
0036 โ
|
โ |
Seq โ
|
Plan โ
|
โ |
โ
|
Multi-select + bulk bar on Video Vault/Flagged (status, visibility, delete, add to collection), Accounts (role, permission bit, delete), Suggestions (approve, reject), Imports (cancel, retry). One POST โฆ/bulk per resource; per-row transactions through the existing single-row services (ADR-0036). Comments keep their bulk; Drive Sync already bulk; Scheduled Jobs out of scope. Plan: BK-1..BK-12. BK-1..BK-11 built by /swarm-execute in 3 waves (2026-11-01), each wave reviewed (fixes 7664769f, 2f2e38bf, e7b228a7, d489d42b); BE mvn verify + 750 FE tests green; deployed prod-119, owner prod smoke per tab passed 2026-11-02 (BK-12) |
| SePay Payments |
PRD ๐ |
0037 ๐ |
โ |
Seq ๐ |
Plan โ
|
โ |
๐ |
Donations (guest + user) and Premium plans paid by VietQR; SePay bank-transfer webhook (HMAC) + reconciliation job; admin Donations tab + notifications; entitlement users.premium_until only, no gated features yet. Plan: PAY-1..PAY-10. PAY-1..4, 6..9 + security fixes built by /swarm-execute (2026-11-12); PAY-5 reconcile deferred (v2 UUID vs webhook numeric id); PAY-10 launch pending |
| Payment Provider Abstraction |
โ |
0038 โ
|
โ |
โ |
Plan โ
|
โ |
โ
|
PaymentProvider port + registry; SePay becomes the first adapter; neutral ingestion/reconcile; sepay_transactions โ payment_transactions (provider + string tx id). Switching vendor = one adapter package + config. Plan: PP-1..PP-6 |
| Admin Video Size |
โ |
โ |
โ |
โ |
Plan โ
|
โ |
โ
|
File size column (video_sources.file_size, ingest + one-time backfill) shown in the admin Video Vault, Total Size stat card; VS-1..VS-9; prod-132 smoke OK 2026-11-12 |
| Agent Evolve Loop (self-improvement) |
โ |
0027 โ
|
โ |
โ |
Plan โ
|
โ |
โ
|
Local /evolve: metrics signals โ path allowlist + seeded-bug eval gate (scripts/evolve.mjs) โ owner approves. Compress (D6) cuts duplicate/dead/stale text. Weekly headless workflow back 2026-10-22 with staged proposals (ADR-0029). First evolution: reviewer rule for assumptions about unchanged code, case 2026-10-19-swallowed-job-exceptions caught 0/3 โ 3/3 |