A community based topic aggregation platform built on atproto
bretton.dev
1-- +goose Up
2-- Add performance indexes for OAuth tables
3-- Migration: 004_add_oauth_indexes.sql
4-- Created: 2025-10-06
5
6-- Index for querying sessions by expiration (used in token refresh logic)
7CREATE INDEX IF NOT EXISTS idx_oauth_sessions_did_expires
8ON oauth_sessions(did, expires_at);
9
10-- Index for active sessions expiration (removed WHERE clause due to NOW() immutability requirement)
11-- This speeds up queries for non-expired sessions
12CREATE INDEX IF NOT EXISTS idx_oauth_sessions_active
13ON oauth_sessions(expires_at);
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);
18
19-- +goose Down
20DROP INDEX IF EXISTS idx_oauth_sessions_active;
21DROP INDEX IF EXISTS idx_oauth_sessions_did_expires;