3 ms·
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
by yasserf 5y ago
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.
- dafelst 5y agoIt's hard to give any advice on this until you detail the problem you're trying to solve. For example: Where/why is your current system failing/inadequate/cumbersome? Why do you want to move the data to s3? Why are delete cascades important?