Cloud Services

Supabase ให้บริการ:
├─ PostgreSQL Database
├─ Authentication & Authorization
├─ Real-time Subscriptions
├─ Edge Functions
├─ File Storage
└─ Auto-generated APIs

ข้อดีสำหรับธุรกิจไทย:
✅ Free tier ใช้งานได้จริง
✅ ไม่ต้องดูแล database
✅ Real-time สำหรับ chat
✅ ใช้งานง่ายกว่า Firebase

Vercel ให้บริการ:
├─ Static Site Hosting
├─ Serverless Functions
├─ Edge Network
├─ Automatic Deployments
└─ Performance Analytics

ข้อดีสำหรับ Half-Stack:
✅ Deploy จาก GitHub อัตโนมัติ
✅ Serverless functions ฟรี
✅ Global CDN
✅ เหมาะกับ Next.js

Railway ให้บริการ:
├─ Docker Container Hosting
├─ PostgreSQL Databases
├─ Static IP Addresses
├─ Custom Domains
└─ Environment Variables

ข้อดีสำหรับ n8n:
✅ รัน n8n ได้ง่าย
✅ มี IP คงที่สำหรับ webhook
✅ Auto-scaling
✅ ราคาเป็นธรรม

CREATE TABLE customers (
  id SERIAL PRIMARY KEY,
  line_user_id VARCHAR(255) UNIQUE,
  name VARCHAR(255),
  phone VARCHAR(20),
  email VARCHAR(255),
  created_at TIMESTAMP DEFAULT NOW()
);

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  order_id VARCHAR(50) UNIQUE,
  customer_id INTEGER REFERENCES customers(id),
  items JSONB,
  total_amount DECIMAL(10,2),
  status VARCHAR(50),
  created_at TIMESTAMP DEFAULT NOW()
);

FROM n8nio/n8n
ENV N8N_ENCRYPTION_KEY=your-key
ENV WEBHOOK_URL=https://your-app.railway.app/

Supabase:
├─ 500MB Database
├─ 50MB File Storage
├─ 2GB Bandwidth
├─ 60,000 API calls/month
└─ 2 Edge Functions

Vercel:
├─ 100GB Bandwidth
├─ 100 Serverless Function invocations
├─ 1 Static Site
└─ Unlimited projects

Railway:
├─ $5 credit/month
├─ 500 hours compute
└─ 100GB data transfer

Small Business:
├─ Supabase: $0 (Free tier)
├─ Vercel: $0 (Free tier)
├─ Railway: $5-20 (n8n hosting)
└─ Total: $5-20/month

Growing Business:
├─ Supabase: $25 (Pro tier)
├─ Vercel: $20 (Pro tier)
├─ Railway: $20-50 (multiple services)
└─ Total: $65-95/month

Enterprise:
├─ Supabase: $599+ (Team tier)
├─ Vercel: $100+ (Team tier)
├─ Railway: $100+ (multiple apps)
└─ Total: $799+/month

LINE OA → n8n (Railway) → Custom API (Vercel) → Supabase Database

Customer → Frontend (Vercel) → API (Vercel) → Supabase → n8n (Railway) → Notifications

Sensors → API (Vercel) → Supabase (Real-time) → Dashboard (Vercel) → n8n (Alerts)

# Supabase
SUPABASE_URL=https://your-project.supabase.co
SUPABASE_ANON_KEY=your-anon-key
SUPABASE_SERVICE_KEY=your-service-key

# Vercel
NEXT_PUBLIC_SUPABASE_URL=your-url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key

# Railway
DATABASE_URL=postgresql://user:pass@host:port/db
N8N_ENCRYPTION_KEY=your-encryption-key

// Vercel Function - Protect with API key
export default async function handler(req, res) {
  const apiKey = req.headers['x-api-key'];
  
  if (apiKey !== process.env.API_KEY) {
    return res.status(401).json({ error: 'Unauthorized' });
  }
  
  // Your API logic here
}

-- Supabase RLS (Row Level Security)
ALTER TABLE customers ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Users can view own data" ON customers
  FOR SELECT USING (auth.uid() = line_user_id);

CREATE POLICY "Users can update own data" ON customers
  FOR UPDATE USING (auth.uid() = line_user_id);

Schedule Trigger → Health Check Functions → IF Node → Alert System

# Backup Vercel deployment
vercel pull --environment=production

# Backup Railway data
railway logs > app-logs.txt

# GitHub backup (code)
git push origin main

# Export local database
pg_dump local_db > backup.sql

# Import to Supabase
psql $DATABASE_URL < backup.sql

# Update environment variables
# Deploy to Vercel/Railway

Firebase → Supabase:
├─ Export Firestore data
├─ Convert to SQL schema
├─ Import to Supabase
└─ Update authentication

Heroku → Railway:
├─ Export database
├─ Create Dockerfile
├─ Deploy to Railway
└─ Update DNS