A community based topic aggregation platform built on atproto
bretton.dev
1-- Add performance indexes for OAuth tables
2-- Migration: 004_add_oauth_indexes.sql
3-- Created: 2025-10-06
4
5-- Index for querying sessions by expiration (used in token refresh logic)
6CREATE INDEX IF NOT EXISTS idx_oauth_sessions_did_expires
7ON oauth_sessions(did, expires_at);
8
9-- Partial index for active sessions (WHERE expires_at > NOW())
10-- This speeds up queries for non-expired sessions
11CREATE INDEX IF NOT EXISTS idx_oauth_sessions_active
12ON oauth_sessions(expires_at)
13WHERE expires_at > NOW();
14
15-- Index on oauth_requests expiration for faster cleanup
16-- (Already exists via migration 003, but documenting here for completeness)
17-- CREATE INDEX IF NOT EXISTS idx_oauth_requests_expires ON oauth_requests(expires_at);