Tech Stack

Overview of technologies used in MediaMagic CRM.

Core Technologies

Component Details

EspoCRM

Aspect	Technology
Backend	PHP 8.2
Frontend	Backbone.js, Handlebars
Database	MySQL 8.0
API	REST API

Why EspoCRM?

• Open-source and self-hosted
• Highly customizable entities
• Built-in workflow automation
• Kanban boards and list views
• API-first architecture

Bridge API

Aspect	Technology
Runtime	Node.js 20
Framework	Express.js
Database	PostgreSQL (pg)
HTTP Client	Axios

Key Dependencies:

{
  "express": "^4.18.x",
  "pg": "^8.11.x",
  "axios": "^1.6.x",
  "node-cron": "^3.0.x"
}

PostgreSQL

Aspect	Details
Version	16
Use Case	Time-series analytics
Tables	4 main tables

Schema Overview:

-- social_metrics: Daily platform metrics
-- post_performance: Per-post analytics
-- platform_followers: Follower history
-- content_metrics: Video/podcast stats

Grafana

Aspect	Details
Version	11
Data Source	PostgreSQL
Dashboards	2 pre-built

Features Used:

• Time series panels
• Stat panels
• Table panels
• Variables for filtering

Docker

Component	Purpose
Docker	Container runtime
Docker Compose	Multi-container orchestration
Volumes	Persistent data storage
Networks	Service communication

External Services

Ayrshare

• Purpose: Social media scheduling and analytics
• Platforms: X, Facebook, Instagram, LinkedIn, YouTube, TikTok
• Features: Post scheduling, analytics API, history

X Server

• Purpose: Platform automation via browser
• Technology: Playwright (Node.js)
• Platforms: Rumble, YouTube, Boxcast, Brighteon, Odysee, etc.
• Capabilities: Livestream creation, video uploads

n8n

• Purpose: Workflow automation
• Technology: Node.js
• Use Cases: Notifications, email, integrations
• Trigger: Webhook-based

Claude API (Anthropic)

• Purpose: AI analysis
• Use Cases: Clip suggestions, transcript analysis
• Model: Claude 3.5 Sonnet

Deepgram / AssemblyAI

• Purpose: Audio/video transcription
• Features: Speaker diarization, timestamps
• Use Case: Video editor transcript

Bunny.net

• Purpose: CDN and storage
• Features: Edge storage, video delivery
• Use Case: Media file hosting

Version Requirements

Component	Minimum	Recommended
Docker	20.0	Latest
Docker Compose	2.0	Latest
Node.js	18	20 LTS
PHP	8.1	8.2
MySQL	8.0	8.0
PostgreSQL	14	16

Development Tools

Tool	Purpose
VS Code	IDE
Docker Desktop	Local containers
Postman/Insomnia	API testing
pgAdmin	PostgreSQL GUI
MySQL Workbench	MySQL GUI

Related

• Architecture Overview
• Services Overview
• Bridge API