-- Supabase: 복잡한 관계형 쿼리 예시
SELECT
  users.name,
  orders.total_amount,
  products.title
FROM users
JOIN orders ON users.id = orders.user_id
JOIN order_items ON orders.id = order_items.order_id
JOIN products ON order_items.product_id = products.id
WHERE users.created_at > NOW() - INTERVAL 30 days
ORDER BY orders.total_amount DESC;

// Firebase Firestore 데이터 조회 예시
import { collection, query, where, getDocs } from 'firebase/firestore';

const q = query(
  collection(db, 'orders'),
  where('status', '==', 'completed'),
  where('total', '>=', 50000)
);

const querySnapshot = await getDocs(q);
querySnapshot.forEach((doc) => {
  console.log(doc.id, doc.data());
});

// Supabase 이메일 로그인
import { createClient } from '@supabase/supabase-js';

const supabase = createClient(SUPABASE_URL, SUPABASE_ANON_KEY);

// 회원가입
const { data, error } = await supabase.auth.signUp({
  email: 'user@example.com',
  password: 'securepassword123'
});

// 로그인
const { data: session } = await supabase.auth.signInWithPassword({
  email: 'user@example.com',
  password: 'securepassword123'
});

// Firebase 이메일 로그인
import { getAuth, signInWithEmailAndPassword, createUserWithEmailAndPassword } from 'firebase/auth';

const auth = getAuth();

// 회원가입
await createUserWithEmailAndPassword(auth, email, password);

// 로그인
const userCredential = await signInWithEmailAndPassword(auth, email, password);
const user = userCredential.user;
console.log('로그인 성공:', user.email);

-- Supabase RLS: 본인 데이터만 조회 가능하도록 설정
ALTER TABLE posts ENABLE ROW LEVEL SECURITY;

CREATE POLICY select_own_posts ON posts
  FOR SELECT
  USING (auth.uid() = user_id);

CREATE POLICY insert_own_posts ON posts
  FOR INSERT
  WITH CHECK (auth.uid() = user_id);

// Supabase 실시간 구독
const channel = supabase
  .channel('messages')
  .on(
    'postgres_changes',
    { event: 'INSERT', schema: 'public', table: 'messages' },
    (payload) => {
      console.log('새 메시지:', payload.new);
      setMessages(prev => [...prev, payload.new]);
    }
  )
  .subscribe();

// Firebase Firestore 실시간 리스너
import { onSnapshot, collection, query, orderBy } from 'firebase/firestore';

const q = query(collection(db, 'messages'), orderBy('createdAt'));
const unsubscribe = onSnapshot(q, (snapshot) => {
  const messages = snapshot.docs.map(doc => ({
    id: doc.id,
    ...doc.data()
  }));
  setMessages(messages);
});

# Supabase pgvector로 의미 검색 구현
import openai
from supabase import create_client

supabase = create_client(url, key)
client = openai.OpenAI()

# 임베딩 생성
response = client.embeddings.create(
    input="파이썬 비동기 처리 방법",
    model="text-embedding-3-small"
)
embedding = response.data[0].embedding

# 벡터 유사도 검색
result = supabase.rpc(
    'match_documents',
    {'query_embedding': embedding, 'match_count': 5}
).execute()

for doc in result.data:
    print(doc['title'], doc['similarity'])

# Supabase DB 덤프 (표준 pg_dump 사용 가능)
pg_dump postgresql://user:password@db.supabase.co:5432/postgres > backup.sql

# 다른 PostgreSQL 인스턴스로 복원
psql postgresql://user:password@new-host:5432/mydb < backup.sql