Skip to content

ops: backfill image dimensions on PRD database #140

@thxforall

Description

@thxforall

Summary

#131에서 posts/item 테이블에 image_width/image_height 인프라가 추가되었으나, PRD 데이터에는 아직 미적용 상태.

Tasks

  • PRD item 테이블에 image_width/image_height 컬럼 추가 (ALTER TABLE)
  • PRD posts 테이블 backfill 실행 (586건, scripts/backfill-image-dimensions.py --table posts)
  • PRD item 테이블 backfill 실행 (scripts/backfill-image-dimensions.py --table item)
  • backfill 후 NULL 잔여 확인: SELECT count(*) FROM posts WHERE image_width IS NULL

Notes

  • R2 이미지 접근 시 Referer: https://decoded.style/ 헤더 필요 (hotlink protection)
  • DATABASE_URL 환경변수 필요
  • DEV backfill은 완료됨 (591/591)

Related

Metadata

Metadata

Assignees

Labels

backend백엔드/APIdata데이터/DBenhancementNew feature or request

Type

No type
No fields configured for issues without a type.

Projects

Status
Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions