Gemini API & Supabase Database Workspace Setup (Phase 1)

### Project Mission & Client Profile The client is a disabled senior citizen and veteran South Florida music promoter/archivist (pioneer of the 1980s Miami punk / New Wave scene). He is liquidating a massive physical collection of historical music mementos, collectibles, and personal memoirs spanning forty years. Because the client is a senior citizen managing physical limitations, this entire project is technically managed and directed by his active AI assistant (Jonathan). Technical communications, code audits, and milestone validations will route directly through the AI interface. We are looking for an engineer who possesses high technical competence and a deep respect for historical preservation and accessibility. --- ### CRITICAL: Current Scope is Phase 1 Only Do not quote or bid on the entire pipeline. Your current contract and the $250.00 escrow funding apply strictly to Phase 1. This milestone requires 100% flawless execution before any future phases are authorized. Phase 1 Deliverables (Flat-Rate: $250.00): 1. Restore Supabase Instance: Connect via your own local CLI tools and safely unpause the existing project database. 2. Execute Database Schema: Run the schema.sql file to verify all backend tables and data fields are structurally active. 3. Migrate 2-Month Context Log: Safely import every line of historical chat logs dating back to May into the active Gemini workspace without altering or erasing a single word of the existing context thread. You must not request root master database passwords; all actions must be executed via secure terminal scripts. --- ### Long-Term Project Pipeline & Future Phases We are intentionally dividing this custom AI workspace build into incremental milestones. We are explicitly looking for a long-term technical partner to retain for future paid contract expansions scheduled for later this summer: * Phase 2: Android Mobile Integration: Mapping the backend database architecture cleanly to a mobile Android application. This will enable seamless laptop-to-phone continuity, mobile voice dictation pipelines, and direct mobile camera integrations so the client can snap photos of physical inventory to be processed by the AI in real time. * Phase 3: Advanced Live Media Routing: Leveraging the Gemini Live API alongside local system audio loopback routing. This milestone will establish a real-time multimedia stream, enabling the AI to directly analyze, "watch," and "listen along" to streaming videos, music playback, or live broadcasts simultaneously with active user voice sessions. If you are an engineer who excels at clean data architecture, appreciates cultural music history, and wants a structured, recurring contract relationship with an AI-driven workflow, please apply.