Thoughts

ENN Pipeline Session 34 (2026-03-24): Phase 9 complete. All database + queue infrastructure built and deployed to Railway Postgres. Migrations applied (003-006): flux_asset_library table, blog_posts updated with long_form_video_id, long_form_videos table created, queue fields (rating_score, queue_position, tiktok_video_id) added to shorts. Key discovery: blog_posts table already existed from the exo-news-network website project with different column names (body vs content, companion_short_id vs short_id, character_slug vs character_id). Pipeline scripts writing blog posts need to use the website's column names. Migration adapted to ALTER TABLE instead of CREATE. Built queue-manage.mjs (assign/check/next/cap commands with --dry-run) and queue-status.mjs (dashboard with backlog counts, per-character breakdown, headroom). Backlog caps: 10 shorts, 3 long-form. Also fixed Gemini date hallucination issue: Gemini outputs wrong dates (2023/2024 instead of 2026) in SESSION and DATE fields. Removed DATE field from both Gem instructions entirely. SESSION now uses topic-slug format (e.g., underground-bases-1) instead of dates. Process-scripts skill generates real session_id from processing date + topic slug. Dave ran first Gemini sessions with new ENN Gem instructions. Results are good quality. Task 8.6 (test run) effectively validated. Status: Phases 0-9 complete. Phase 8 has one remaining task (8.6 formal test) but effectively done since Dave tested the Gems. Next up: Phase 10 (Shorts Production Pipeline Update).

UFO UAP RV YT Pipeline - Session 12 Summary (2026-03-19) Phase 1 is now fully complete. All portrait work is done. PORTRAIT SELECTIONS (Dave approved): - Grey: Already had LoRA portraits from Phase 1.5 proof of concept - Reptilian: Option 2 from LoRA candidates (military uniform, dark background, yellow eyes, horns) - Mantis: External image Dave placed in "Dave Select" folder (white lab coat, tie, green head, yellow compound eyes, antennae) - Little Green Man: External image Dave placed in "Dave Select" folder (chibi proportions, lime-green skin, big black eyes, ball-tipped antennae, light hoodie) R2 UPLOADS: All 4 characters have canonical portraits uploaded to Cloudflare R2 bucket "ufo-uap-pipeline-assets" at {slug}/default.png. Grey also has fullbody.png and threequarter.png. POSTGRES: All character_outfits default rows now have consistent full R2 URLs (https://63741793291c8676f4fde6d11df9726e.r2.cloudflarestorage.com/ufo-uap-pipeline-assets/{slug}/default.png). Grey's URL was normalized from a relative path to match the others. DIRECTORY REORGANIZATION: - characters/portraits/{slug}/default.png = canonical portraits (6 total files across 4 characters) - characters/lora/ = only the 4 LoRA result JSON files (grey, reptilian, mantis, little-green-man) - characters/archive/ = all historical files preserved (pre-LoRA Krea images in portraits-pre-cleanup/, lora-candidates/ with all option sets, dave-select/ with original winner files, kontext-test/, lora-test-output/ with rounds 1-8 and grey test videos from Hedra/Fabric/OmniHuman/Hailuo) Scripts created this session: upload-approved-portraits.mjs, organize-portraits.mjs (both in pipeline/scripts/) Next: Phase 2 - Gemini prompt chain development (extraction, scripting, grading, visual planning, character casting prompts)