HLS-Steam Converter
Simple DB Stru for - renditions
CREATE TABLE renditions ( id varchar PRIMARY KEY DEFAULT gen_random_uuid(), job_id varchar NOT NULL REFERENCES transcoding_jobs(id) ON DELETE CASCADE, quality text NOT NULL, -- e.g. '240p', '720p' height integer, -- pixel height bitrate text, -- e.g. '2800k' status text NOT NULL DEFAULT 'pending', -- 'pending'|'processing'|'complete'|'failed' progress integer DEFAULT 0, -- 0-100 size integer, -- bytes playlist_url text, created_at timestamp DEFAULT now(), updated_at timestamp DEFAULT now() );
CREATE INDEX idx_renditions_job_id ON renditions(job_id);
Simple DB Stru for - audio_streams
CREATE TABLE audio_streams ( id varchar PRIMARY KEY DEFAULT gen_random_uuid(), job_id varchar NOT NULL REFERENCES transcoding_jobs(id) ON DELETE CASCADE, stream_index integer NOT NULL, -- index in the original file codec text, bitrate text, channels integer, sample_rate integer, size integer, -- bytes url text, status text DEFAULT 'pending', created_at timestamp DEFAULT now(), updated_at timestamp DEFAULT now() );
CREATE INDEX idx_audio_streams_job_id ON audio_streams(job_id);