DEV Community

Amrendra N Mishra
Amrendra N Mishra

Posted on

ChromaDB Tutorial: Vector Database for Your AI Apps

Why Automate Content Creation

Creating content manually for 9 channels would take 8+ hours daily. I have a full-time job as VP at JPMorgan. The math doesnt work.

The Pipeline

Trending Topic CSV
       ↓
  AI Script (Ollama/Gemini)
       ↓
  Google Cloud TTS (Voice)
       ↓
  Pexels Images + MoviePy Video
       ↓
  YouTube API Upload
Enter fullscreen mode Exit fullscreen mode

Scheduling with Mac LaunchAgents

<plist version="1.0">
<dict>
  <key>Label</key>
  <string>com.gyaaninfive.youtube</string>
  <key>ProgramArguments</key>
  <array>
    <string>/usr/bin/python3</string>
    <string>/path/to/upload.py</string>
  </array>
  <key>StartCalendarInterval</key>
  <dict>
    <key>Hour</key><integer>18</integer>
    <key>Minute</key><integer>15</integer>
  </dict>
</dict>
</plist>
Enter fullscreen mode Exit fullscreen mode

One plist per channel. Runs at the exact scheduled time.

Total Monthly Cost

Google Cloud TTS: Free (4M chars/month)
Pexels API: Free
YouTube API: Free
Ollama: Free (local)

Total: ₹0/month

Full code on GitHub


9 channels. Daily uploads. Zero manual work.

Top comments (0)