[DATABASE] SurrealDB Graph Schema & Qdrant Setup

[hdenizkaraman]

🎯 Task Description

Set up database schemas to query event relationships via Graph queries and perform fast Semantic RAG over historical event summaries.

🛠️ Affected Domain / Package

• apps/dashboard (Next.js Live Monitoring Panel)
• apps/identity (Next.js Live Monitoring Panel)
• apps/gateway (Rust Axum API Gateway & Realtime SSE)
• apps/stream (Video Ingestion & Dynamic Frame Sampling)
• apps/ai (Agentic Reasoning & Decision Logic)
• packages/optics (Image & Media Processing Toolkit)
• packages/database (SurrealDB, Qdrant)
• platform/ or tools/ (Docker, Infrastructure & Benchmarks)
• Other (please specify): ``

---

📋 Task Checklist

• Define video, entity, event, and insight nodes in SurrealDB.
• Implement directional graph edges (APPEARS_IN, INVOLVED_IN, TRIGGERS) using SurrealQL.
• Create an embedding collection in Qdrant Vector DB for storing historical event summaries.
• Configure shared Rust SDK dependencies under packages/database.

---

🔗 Related Resources / Docs

• TEKNOFEST Requirements: [3rd Scenario Specs]
• Internal Docs: documents/features/database.md