sulthan
bfae84c5c3
Closes #43 Persist kagane cover bytes in a dedicated Postgres covers table keyed by image ID. The web handler reads storage before the browser, writes validated fetches through, and no longer keeps an in-process cover cache. Added migration, store persistence tests including reopen, handler coverage for stored/miss/rejected paths, and corrected repository guidance. Verification: - go test ./... - CGO_ENABLED=0 go build ./... Reviewed-on: #49 Co-authored-by: Sulthan Zaki <sultankiki05@gmail.com> Co-committed-by: Sulthan Zaki <sultankiki05@gmail.com>
9 lines
301 B
SQL
9 lines
301 B
SQL
-- Kagane cover bytes belong in their own table so image blobs never enter the
|
|
-- series queries that drive the latest-chapter poller.
|
|
CREATE TABLE covers (
|
|
image_id text PRIMARY KEY,
|
|
body bytea NOT NULL,
|
|
content_type text NOT NULL,
|
|
fetched_at timestamptz NOT NULL DEFAULT now()
|
|
);
|