Migration Guides

# Export conversations
pnpm export:conversations
 
# Backup Supabase database
pg_dump $DATABASE_URL > backup-v1.sql

# Update to latest versions
pnpm add next@15 @ai-sdk/openai@latest ai@latest
pnpm add @supabase/supabase-js@latest

-- Add new columns
ALTER TABLE conversations ADD COLUMN model TEXT DEFAULT 'gpt-4o';
ALTER TABLE users ADD COLUMN daily_message_count INT DEFAULT 0;
ALTER TABLE users ADD COLUMN is_pro BOOLEAN DEFAULT false;
 
-- Update existing data
UPDATE conversations SET model = 'gpt-4o' WHERE model IS NULL;

# New required variables
ENCRYPTION_KEY=your-32-byte-hex-key
NEXTAUTH_SECRET=your-secret

# Updated variable names
OPENAI_API_KEY=sk-proj-...  # Changed format

// Old way (v1.x)
import { OpenAI } from 'openai';
const openai = new OpenAI({ apiKey: process.env.OPENAI_API_KEY });
 
// New way (v2.x)
import { openai } from '@ai-sdk/openai';
import { streamText } from 'ai';

// Export users
const users = await db.collection('users').find({}).toArray();
const usersCSV = convertToCSV(users);
 
// Export conversations
const conversations = await db.collection('conversations').find({}).toArray();
const conversationsCSV = convertToCSV(conversations);

# Install Supabase CLI
pnpm add -g @supabase/cli
 
# Initialize project
supabase init
 
# Start local development
supabase start

-- Create tables
CREATE TABLE users (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  email TEXT UNIQUE,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);
 
CREATE TABLE conversations (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id UUID REFERENCES users(id),
  title TEXT,
  model TEXT DEFAULT 'gpt-4o',
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

# Upload CSVs to Supabase
supabase db import users.csv
supabase db import conversations.csv

// firestore-export.js
const admin = require('firebase-admin');
const fs = require('fs');
 
admin.initializeApp({
  credential: admin.credential.cert(serviceAccount),
});
 
const db = admin.firestore();
 
async function exportCollection(collectionName) {
  const snapshot = await db.collection(collectionName).get();
  const data = snapshot.docs.map(doc => ({
    id: doc.id,
    ...doc.data()
  }));
 
  fs.writeFileSync(`${collectionName}.json`, JSON.stringify(data, null, 2));
}
 
exportCollection('users');
exportCollection('conversations');

// transform-data.js
const firebase_users = require('./users.json');
const supabase_users = firebase_users.map(user => ({
  id: user.uid,
  email: user.email,
  created_at: user.createdAt._seconds * 1000
}));
 
fs.writeFileSync('supabase_users.json', JSON.stringify(supabase_users));

-- Use Supabase Dashboard or SQL
INSERT INTO users (id, email, created_at)
SELECT
  (data->>'id')::uuid,
  data->>'email',
  to_timestamp((data->>'created_at')::bigint / 1000)
FROM json_array_elements($1::json) AS data;

# Old format
OPENAI_API_KEY=sk-...

# New format (if applicable)
OPENAI_API_KEY=sk-proj-...

// Old way
import OpenAI from 'openai';
const openai = new OpenAI();
 
const completion = await openai.chat.completions.create({
  model: 'gpt-4',
  messages: messages,
  stream: true,
});
 
// New way
import { openai } from '@ai-sdk/openai';
import { streamText } from 'ai';
 
const result = await streamText({
  model: openai('gpt-4o'),
  messages: messages,
});

# Run migration test
pnpm test:migration
 
# Check API connectivity
curl -H "Authorization: Bearer $OPENAI_API_KEY" \
  https://api.openai.com/v1/models

pnpm add @ai-sdk/anthropic  # For Claude
pnpm add @ai-sdk/google     # For Gemini

ANTHROPIC_API_KEY=sk-ant-api03-...
GOOGLE_AI_API_KEY=AIzaSy...

// lib/ai/models.ts
import { anthropic } from '@ai-sdk/anthropic';
 
export const modelConfigs = {
  // ... existing models
  'claude-3-opus': {
    provider: 'anthropic',
    model: anthropic('claude-3-opus-20240229'),
    name: 'Claude 3 Opus',
    contextWindow: 200000,
  }
};

# Export current environment
env | grep -E '^(OPENAI|SUPABASE|ANTHROPIC)' > .env.production

pnpm add -g vercel
vercel login

# Link project
vercel link
 
# Set environment variables
vercel env add OPENAI_API_KEY production
vercel env add SUPABASE_URL production
 
# Deploy
vercel --prod

vercel domains add console.yourdomain.com

# Dockerfile
FROM node:22-alpine
 
WORKDIR /app
COPY package*.json ./
RUN pnpm install --prod --frozen-lockfile
 
COPY . .
RUN pnpm build
 
EXPOSE 3000
CMD ["pnpm", "start"]

# docker-compose.yml
version: '3.8'
services:
  app:
    build: .
    ports:
      - "3000:3000"
    environment:
      - NODE_ENV=production
      - OPENAI_API_KEY=${OPENAI_API_KEY}
      - SUPABASE_URL=${SUPABASE_URL}

docker-compose up -d