Scene Release Tracker -

CREATE TABLE users ( id SERIAL PRIMARY KEY, email TEXT UNIQUE, discord_webhook TEXT, telegram_chat_id TEXT );

[IRC scraper] ─┐ [PreDB API] ─┼─→ [Normalizer] ─→ [PostgreSQL/DB] ─→ [Web Frontend] [RSS parser] ─┘ │ └──→ [Notification worker] CREATE TABLE releases ( id SERIAL PRIMARY KEY, release_name TEXT UNIQUE NOT NULL, category VARCHAR(20), -- movies, tv, music, games, apps, xxx group_name VARCHAR(50), size_mb INTEGER, release_date TIMESTAMP WITH TIME ZONE, nfo_preview TEXT, source_url TEXT, created_at TIMESTAMP DEFAULT NOW() ); CREATE INDEX idx_release_date ON releases(release_date DESC); CREATE INDEX idx_group_name ON releases(group_name); scene release tracker

CREATE TABLE watchlist ( user_id INTEGER REFERENCES users(id), keyword TEXT, -- e.g., "Windows 11 PRO", "Marvel" group_name TEXT, -- e.g., "EVILBUD" PRIMARY KEY (user_id, keyword, group_name) ); Header: Logo + search bar + category pills (Movies | TV | Music | Games) CREATE TABLE users ( id SERIAL PRIMARY KEY,