Storing AI-Generated Images for 3 Years: Object Storage vs Relational Databases (and Why)
Short answer: keep the image bytes in private object storage and keep tenant ownership, object keys, checksums, retention decisions, and audit events in a relational database. An image is a large, unstructured binary object; the questions about who may retrieve it, when it must disappear, and whether deletion completed are relational questions. This split is the least complex design that can still produce a tenant-scoped export for an edtech product.
Object storage is a better home for the bytes because it is optimized for binary large objects, scales horizontally, supports metadata, and generally has lower per-gigabyte economics than a relational database. It is not a complete retention system by itself.…