I’m facing an issue where I store small binary data blobs within a Postgres column in order to benefit from delete cascades.

I’m considering moving the binary data into S3 and then doing the sync layer on the server (which means the front end requests the data from the backend and is given it back as a JSON object with base64 values).

Doing this manually via code isn’t impossible, just API intensive, so I’m wondering if this is a solved issue for anyone.

The why: The JSON blobs are recordings of words and sentences that can be copied between articles.