| Left column (80%) | Right column (20%) | |-------------------|--------------------| | table | Top groups today | | Release name (click for NFO) | 1. EVILBUD (12 releases) | | Group | Size | Age | 2. DTR (8 releases) | | Pagination | Live feed (websocket) showing new releases as they arrive |
class Release(BaseModel): name: str group: str category: str date: datetime scene release tracker
[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); | Left column (80%) | Right column (20%)
| Source type | Examples | Reliability | |-------------|----------|-------------| | | pre.corrupt-net.org, srrDB, predb.me, orlydb.com | High (dedicated to Scene pre logs) | | IRC announce channels | #moviereleases, #mp3releases on P2P nets | Medium (real-time but noisy) | | RSS from torrent sites | TorrentGalaxy, RARBG clone (if any) | Low (delayed, sometimes incomplete) | release_name TEXT UNIQUE NOT NULL
CREATE TABLE users ( id SERIAL PRIMARY KEY, email TEXT UNIQUE, discord_webhook TEXT, telegram_chat_id TEXT );