Migration Plan

Phase A: Data Export & Transform

Weeks 17–18 of build (parallel with Phase 5 frontend work)

Extract all data from the live MongoDB at api.workshop17.co.za and transform into PostgreSQL-compatible format.

Approach

• Use the existing JXP API to export data — GET /api/{model}?limit=10000 for each of the 88 models. The API already supports pagination and field selection.
• Claude Code writes the transformation scripts: one per model group (core, financial, CRM, infra)
• Transformations handle: ObjectID → UUID mapping, denormalised fields → foreign keys, Mixed/schemaless fields → typed columns or jsonb

Key Transformations

Phase B: API Compatibility Layer

Week 18 (1 week, built by Claude Code)

Build a thin translation layer that accepts JXP-style requests and routes them to the new PostgreSQL-backed API. This allows any existing integrations or scripts that hit api.workshop17.co.za to keep working during transition.

What It Translates

Phase C: Parallel Run & Reconciliation

Weeks 19–20 (2 weeks)

Both systems run simultaneously. The new platform handles all reads and new writes. The old system remains available as a fallback.

Parallel Run Rules

• DNS: New platform goes live on a subdomain (e.g. app.proximity.green) while my.workspaceman.nl stays active
• Reads: New platform serves all read traffic from PostgreSQL
• Writes: New platform is the primary. Critical writes (payments, invoices) also logged to reconciliation queue
• Reconciliation: Daily automated check comparing user counts, wallet balances, invoice totals, and booking counts between old and new

Daily Reconciliation Script

// Runs via Inngest every 24 hours
async function reconcile() {
    const oldUsers = await fetch('https://api.workshop17.co.za/count/user');
    const newUsers = await db.select(count()).from(users);

    const oldInvoiceTotal = await fetch(
        'https://api.workshop17.co.za/aggregate/invoice',
        { body: [{ $group: { _id: null, total: { $sum: "$total" } } }] }
    );
    const newInvoiceTotal = await db
        .select(sum(invoices.total))
        .from(invoices);

    // Compare and alert on discrepancies > 1%
    if (Math.abs(oldTotal - newTotal) / oldTotal > 0.01) {
        await alert('Invoice total mismatch', { oldTotal, newTotal });
    }
}

Rollback Criteria

• If balance discrepancies exceed 1% for any user — pause and investigate
• If payment processing fails on the new platform — redirect payments to old system
• If more than 5 user-reported issues in first 48 hours — rollback DNS

Phase D: Cutover & Decommission

End of Week 20

Switch all traffic to the new platform and decommission WorkSpaceMan.

Cutover Sequence

1. Final data sync: export any records created in old system during parallel run
2. DNS switch: api.workshop17.co.za → compatibility layer on new platform
3. Member portal: my.workspaceman.nl redirects to app.proximity.green
4. CRM: crm.workspaceman.nl redirects to new CRM interface
5. Monitor: 48-hour hypercare with on-call developer
6. Remove compatibility layer after 30 days (all consumers migrated)
7. Archive old MongoDB data (encrypted backup, retain for 12 months)
8. Decommission old VPS infrastructure