# Reddit's Media Metadata Store and Data Migration Process

DevFeed: [Reddit's Media Metadata Store and Data Migration Process](<https://devfeed.tech/articles/inside-look-at-reddit-s-metadata-store-34685.md>)

Original publisher: [Read original article](<https://newsletter.systemdesigncodex.com/p/inside-look-at-reddits-metadata-store>)

Author: Saurabh Dashora

Published: 2026-03-17T08:41:58Z

Content type: article

Language: en

Sources: [System Design Codex](<https://devfeed.tech/sources/system-design-codex.md>)

Topics: [Reddit](<https://devfeed.tech/topics/reddit.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [migration](<https://devfeed.tech/topics/migration.md>), [data](<https://devfeed.tech/topics/data.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [API](<https://devfeed.tech/topics/api.md>), [proxy](<https://devfeed.tech/topics/proxy.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [aws](<https://devfeed.tech/tags/aws.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [latency](<https://devfeed.tech/tags/latency.md>), [migration](<https://devfeed.tech/tags/migration.md>), [proxy](<https://devfeed.tech/tags/proxy.md>), [reddit](<https://devfeed.tech/tags/reddit.md>), [s3](<https://devfeed.tech/tags/s3.md>)

## AI overview

This article explains why Reddit built a unified media metadata store for media-related information previously scattered across multiple systems. It describes the store's requirements, its AWS Aurora Postgres architecture with an API service and pgBouncer, and a migration process using dual writes, data backfilling, and dual reads while serving high request volume.

## Source excerpt

How it works